Re: [BUGS] Referential Integrity corrupted sometimes by Rules

2001-07-10 Thread José María Fernández González
Tom Lane wrote: > > [EMAIL PROTECTED] writes: > > -- Rule over the referenced table > > -- which breaks referential integrity > > create rule nodelrel > > as on delete to rel > > where old.ref > 3 and user = 'prueba' > > do instead nothing; > Hi Tom, first of all, my congratulations to

Re: [BUGS] Referential Integrity corrupted sometimes by Rules

2001-07-06 Thread Stephan Szabo
On Fri, 6 Jul 2001 [EMAIL PROTECTED] wrote: > José María Fernández González ([EMAIL PROTECTED]) reports a bug with a severity >of 1 > The lower the number the more severe it is. > > Short Description > Referential Integrity corrupted sometimes by Rules > > Long Description If you define an em

Re: [BUGS] Referential Integrity corrupted sometimes by Rules

2001-07-06 Thread Tom Lane
[EMAIL PROTECTED] writes: > -- Rule over the referenced table > -- which breaks referential integrity > create rule nodelrel > as on delete to rel > where old.ref > 3 and user = 'prueba' > do instead nothing; This rule is preventing the foreign key triggers from performing the DELETEs implied by

[BUGS] Referential Integrity corrupted sometimes by Rules

2001-07-06 Thread pgsql-bugs
José María Fernández González ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Referential Integrity corrupted sometimes by Rules Long Description If you define an empty rule with a condition over a table which references to an