Re: [HACKERS] DELETE not seeing expected rows before COPY on 8.4.1

2009-10-16 Thread Greg Sabino Mullane
-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

Re: [HACKERS] DELETE not seeing expected rows before COPY on 8.4.1

2009-10-16 Thread Robert Haas
On Thu, Oct 15, 2009 at 11:44 PM, Greg Sabino Mullane wrote: > 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

[HACKERS] DELETE not seeing expected rows before COPY on 8.4.1

2009-10-15 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 I'm trying to figure out why I keep getting an error when trying to COPY data into a table. The basic process is to get