Re: [GENERAL] orphaned RI constraints

2001-07-09 Thread Stephan Szabo
On Mon, 9 Jul 2001, Jan Wieck wrote: > Somazx Interesting wrote: > > At 01:30 PM 7/6/2001 -0700, you wrote: > > >To fix it, you should be able to use DROP TRIGGER on the appropriate > > >triggers that were created (you can find these through a select on > > >pg_trigger, using the tgargs to find

Re: [GENERAL] orphaned RI constraints

2001-07-06 Thread Somazx Interesting
At 01:30 PM 7/6/2001 -0700, you wrote: >On Fri, 6 Jul 2001, Somazx Interesting wrote: > > > > > I'm working with two different postgres installations - they're both > > v7.1.2. On one I can drop a table and the related constraint info seems to > > go away with the table, on the other the restraint

Re: [GENERAL] orphaned RI constraints

2001-07-06 Thread Stephan Szabo
On Fri, 6 Jul 2001, Somazx Interesting wrote: > > I'm working with two different postgres installations - they're both > v7.1.2. On one I can drop a table and the related constraint info seems to > go away with the table, on the other the restraint trigger seems to remain > in the system tabl

Re: [GENERAL] orphaned RI constraints

2001-07-06 Thread Tom Lane
Somazx Interesting <[EMAIL PROTECTED]> writes: > I'm working with two different postgres installations - they're both > v7.1.2. On one I can drop a table and the related constraint info seems to > go away with the table, on the other the restraint trigger seems to remain > in the system tables

[GENERAL] orphaned RI constraints

2001-07-06 Thread Somazx Interesting
I'm working with two different postgres installations - they're both v7.1.2. On one I can drop a table and the related constraint info seems to go away with the table, on the other the restraint trigger seems to remain in the system tables and then when I try to delete rows from tables once r