Re: DELETE not seeing expected rows before COPY on 8.4.1

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: DELETE not seeing expected rows before COPY on 8.4.1
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Trigger with WHEN clause (WIP)