Re: [SQL] Apparent referential integrity bug in PL/pgSQL

2002-10-18 Thread Stephan Szabo
On Fri, 18 Oct 2002, Brian Blaha wrote: > I have a function that operates on two tables A and B, such that B has a > foreign key on A, as follows: > INSERT INTO A (...) several times > INSERT INTO B (...) several times, with foreign keys pointing to the new > members of A > DELETE FROM A (...), p

[SQL] Apparent referential integrity bug in PL/pgSQL

2002-10-18 Thread Brian Blaha
I have a function that operates on two tables A and B, such that B has a foreign key on A, as follows: INSERT INTO A (...) several times INSERT INTO B (...) several times, with foreign keys pointing to the new members of A DELETE FROM A (...), possibly including some of the newly added members E