Re: DELETE not seeing expected rows before COPY on 8.4.1

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: DELETE not seeing expected rows before COPY on 8.4.1
Date: 2009-10-16 10:59:51
Message-ID: 603c8f070910160359t69fc1237r734c90469e355dba@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Oct 15, 2009 at 11:44 PM, Greg Sabino Mullane <greg(at)turnstep(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Sabino Mullane 2009-10-16 11:20:59 Re: DELETE not seeing expected rows before COPY on 8.4.1
Previous Message Peter Eisentraut 2009-10-16 10:38:15 Re: Unicode UTF-8 table formatting for psql text output