search for: users_pkey

...ey PRIMARY KEY (id)'' execute ''ALTER TABLE ONLY facilities ADD CONSTRAINT facilities_pkey PRIMARY KEY (id)'' execute ''ALTER TABLE ONLY clients ADD CONSTRAINT clients_pkey PRIMARY KEY (id)'' execute ''ALTER TABLE ONLY users ADD CONSTRAINT users_pkey PRIMARY KEY (id)'' # set up foreign key restratints for PostgreSQL execute ''ALTER TABLE ONLY clients ADD CONSTRAINT fk_cp_case_manager FOREIGN KEY (case_manager_id) REFERENCES case_managers(id)'' execute ''ALTER TABLE ONLY placements ADD CONSTRAINT fk_c...

...s. Take as an example my ''users'' table. In Postgres the schema is (generated with pgAdmin III): CREATE TABLE users ( id serial NOT NULL, login varchar(80), "password" varchar(255), created_on timestamp, updated_on timestamp, avatar varchar(255), CONSTRAINT users_pkey PRIMARY KEY (id) ) WITH OIDS; ALTER TABLE users OWNER TO george; Everything works just dandy until we cross over to the SQLite world: CREATE TABLE users ( id serial NOT NULL, login character varying(80), "password" character varying(255), created_on timestamp without time...

...p ** 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" "test/unit/localization_test.rb" "test/unit/user_test.rb" dyld: NSLinkModule() error dyld: Symbol not fo...

...sse/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/ruby -Ilib:test "/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake/rake_test_loader.rb" "test/unit/localization_test.rb" "test/unit/user_test.rb" /u...

...sse/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_test_loader.rb" "test/unit/localization_test.rb" "test/unit/user_test.rb" /usr/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active_support/dependencies....

..." 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 create implicit index "users_pkey" for table "users" psql:db/development_structure.sql:73: NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "pages_title_key" for table "pages" psql:db/development_structure.sql:76: ERROR: permission denied to set session authorization psql:db/developme...

...9;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" PRIMARY KEY, btree (id) "index_users_on_email" UNIQUE, btree (email) The strange thing is that listing most of the fields in the update works (as instructed in the tutorial http://ruby.railstutorial.org/chapters/sign-up?version=4.0#top in the section of adding Gravatar). irb(...