Re: Use ctid in where clause in update from statement

Поиск
Список
Период
Сортировка
От Dirk Mika
Тема Re: Use ctid in where clause in update from statement
Дата
Msg-id C5E06016-DACB-4EE4-BAF6-D6F6F084867F@mikatiming.de
обсуждение исходный текст
Ответ на Re: Use ctid in where clause in update from statement  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
Hi

    Thinking about it, it _has_ to call any BEFORE trigger function
    as that might change values of the row to be inserted that
    could possibly change the outcome of the test.

Yeah, that was my thought, too. Unfortunately, the affected trigger changes two columns, so I can't change it to an
AFTERROW trigger.
 

Dirk







--
Dirk Mika
Software Developer

mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany

fon +49 2202 2401-1197
dirk.mika@mikatiming.de
www.mikatiming.de

AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika



## How2Use
## the ChampionChip by mika:timing
## https://youtu.be/qfOFXrpSKLQ

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Use ctid in where clause in update from statement
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Use ctid in where clause in update from statement