search for: facilities_pkey

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