Re: DELETE not seeing expected rows before COPY on 8.4.1

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: DELETE not seeing expected rows before COPY on 8.4.1
Дата
Msg-id 603c8f070910160359t69fc1237r734c90469e355dba@mail.gmail.com
обсуждение исходный текст
Ответ на DELETE not seeing expected rows before COPY on 8.4.1  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: DELETE not seeing expected rows before COPY on 8.4.1  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Unicode UTF-8 table formatting for psql text output
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: DELETE not seeing expected rows before COPY on 8.4.1