pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Foreign key constraint 2+ messages / 2 participants [nested] [flat]
* Foreign key constraint @ 2000-12-05 22:11 Sivagami . <sivagami@worlddata.com> 0 siblings, 1 reply; 2+ messages in thread From: Sivagami . @ 2000-12-05 22:11 UTC (permalink / raw) To: pgsql-sql Hi, I have a question. I tried adding a Foreign Key constraint to a table via the ALTER TABLE command. But the records in the table did not match with those in the Parent table. Now my Alter table command, instead of giving me an error of kind - 'records do not match', has gone into a kind of Deadlock between the 2 tables. I am not able to select from the tables, nor delete them, nor drop them. If I try to do any of these, I get the error saying - " Error : RelationBuildTriggers: 2 record(s) not found for rel invoice" How do I overcome this error. Any ideas will be greatly appreciated. Thanks a lot in advance. Shiva. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Foreign key constraint @ 2000-12-12 18:36 Jie Liang <jliang@jliang.ipinc.com> parent: Sivagami . <sivagami@worlddata.com> 0 siblings, 0 replies; 2+ messages in thread From: Jie Liang @ 2000-12-12 18:36 UTC (permalink / raw) To: Sivagami . <sivagami@worlddata.com>; +Cc: pgsql-sql Recovery try use: pg_dump -t tbname -f outfile dbname use vi erase f key from outfile, drop old table, reload them. Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.ipinc.com ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-12-12 18:36 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-12-05 22:11 Foreign key constraint Sivagami . <sivagami@worlddata.com> 2000-12-12 18:36 ` Jie Liang <jliang@jliang.ipinc.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox