Displaying 2 results from an estimated 2 matches for "facilities_pkey".
2006 Mar 25
1
foreign keys on migration
...d)''
execute ''ALTER TABLE ONLY placements ADD CONSTRAINT placements_pkey
PRIMARY KEY (id)''
execute ''ALTER TABLE ONLY case_managers ADD CONSTRAINT
case_managers_pkey 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 '...
2006 Feb 13
8
postgres and rake
...e
"referral_notes"
psql:db/development_structure.sql:149: NOTICE: ALTER TABLE / ADD
PRIMARY KEY will create implicit index "clients_pkey" for table
"clients"
psql:db/development_structure.sql:158: NOTICE: ALTER TABLE / ADD
PRIMARY KEY will create implicit index "facilities_pkey" for table
"facilities"
psql:db/development_structure.sql:211: ERROR: must be owner of schema
public
Apparently, I can''t set the owner of the schema to the user that I am
using and actually owns the db and the tables in postgresql 7.4
How does one do this?
Craig