pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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>
  2000-12-12 18:36 ` Re: Foreign key constraint Jie Liang <jliang@jliang.ipinc.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-05 22:11 Foreign key constraint Sivagami . <sivagami@worlddata.com>
@ 2000-12-12 18:36 ` Jie Liang <jliang@jliang.ipinc.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