search for: users_id_seq

I have reached a development plateau and now want to integrate some of the rails niceties that I passed over to get the system online. I am fooling with migrations. I am using postgresql. I put in my migration script (at the end of the ''up'' method, the following raw sql code... # set up primary key restratints for PostgreSQL execute ''ALTER TABLE ONLY

...prepare ** Invoke db:test:clone (first_time) ** Invoke db:schema:dump (first_time) ** Invoke environment ** Execute db:schema:dump ** Execute db:test:clone ** Invoke db:schema:load (first_time) ** Invoke environment ** Execute db:schema:load NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users" ** Execute test:units /usr/local/bin/ruby -Ilib:test "/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake/rake_test_loader.rb&quot...

...have a *very* simple rails app with three tables, one of which is the users table: users: Column | Type | Modifiers ---------------+-----------------------------+----------------- id | integer | not null default nextval(''public.users_id_seq''::text) login | character varying(25) | not null password | character varying(150) | not null user_type | character varying(20) | not null first_name | character varying(30) | not null last_name | character varying(30) | not null email_a...

...the unit tests by doing ''rake test_units'', then I get the following error message: <error-message> [brasse@keso login-test]$ rake test_units (in /home/brasse/RAILS/login-test) psql:db/development_structure.sql:29: NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for "serial" column "users.id" psql:db/development_structure.sql:38: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "users_pkey" for table "users" psql:db/development_structure.sql:46: ERROR: must be owner of schema public /usr/bin...

...://wiki.rubyonrails.com/rails/pages/SaltedLoginGeneratorQuickstart), my version of rake is 0.7.0. This is my error message [brasse@keso login-test]$ rake test_units (in /home/brasse/RAILS/login-test) psql:db/development_structure.sql:37: NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for "serial" column "users.id" psql:db/development_structure.sql:46: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "users_pkey" for table "users" /usr/bin/ruby -Ilib:test "/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake/rake_t...

...permission denied for schema public psql:db/development_structure.sql:34: NOTICE: CREATE TABLE will create implicit sequence "pages_id_seq" for "serial" column "pages.id" psql:db/development_structure.sql:46: NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for "serial" column "users.id" psql:db/development_structure.sql:55: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pages_pkey" for table "pages" psql:db/development_structure.sql:64: NOTICE: ALTER TABLE / ADD PRIMARY KEY will creat...

...Table "public.users" Column | Type | Modifiers -----------------+----------------------------- +---------------------------------------------------- id | integer | not null default nextval(''users_id_seq''::regclass) name | character varying(255) | email | character varying(255) | created_at | timestamp without time zone | updated_at | timestamp without time zone | password_digest | character varying(255) | Indexes: "users_pkey&quo...

Hello All, How do I change the heroku database( already existed ) table id to start from say 1000? I tried with a fresh database on local & it works with this:- *execute "ALTER users orders AUTO_INCREMENT = 1000"* Thanks, Avinash -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from