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

From Robert Haas
Subject Re: DELETE not seeing expected rows before COPY on 8.4.1
Date
Msg-id 603c8f070910160359t69fc1237r734c90469e355dba@mail.gmail.com
Whole thread Raw
In response to DELETE not seeing expected rows before COPY on 8.4.1  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: DELETE not seeing expected rows before COPY on 8.4.1
List pgsql-hackers
On Thu, Oct 15, 2009 at 11:44 PM, Greg Sabino Mullane <greg@turnstep.com> 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 the rest of what you're seeing...   still, any
triggers or rules on these tables?

...Robert


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Unicode UTF-8 table formatting for psql text output
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: DELETE not seeing expected rows before COPY on 8.4.1