Re: DELETE not seeing expected rows before COPY on 8.4.1 - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: DELETE not seeing expected rows before COPY on 8.4.1
Date
Msg-id 8cfcc06a9489aad0038c4567cc2248ae@biglumber.com
Whole thread Raw
In response to Re: DELETE not seeing expected rows before COPY on 8.4.1  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> The DELETE returns 0 rows (and thus is the problem) according to the script.

> I've had this problem before when there is a BEFORE DELETE trigger
> that is inadvertently preventing the deletion, though this seems hard
> to rationalize with the rest of what you're seeing...   still, any
> triggers or rules on these tables?

There is a trigger on both sides that does an insert to another table,
but it should not prevent the deletion. Further, this session is
running 'replica' mode. Going to do some more debugging this morning...

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200910160720
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkrYVxYACgkQvJuQZxSWSsh8pgCdGtYA1tzFxeaq+Uwdij/BEsKf
recAmweTdVFQsZc19qqu8wJNfSjvTU2+
=eLya
-----END PGP SIGNATURE-----




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: DELETE not seeing expected rows before COPY on 8.4.1
Next
From: Peter Eisentraut
Date:
Subject: Re: Trigger with WHEN clause (WIP)