Re: Triggers/perform oddity between 7.2 and 7.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Triggers/perform oddity between 7.2 and 7.3
Дата
Msg-id 26218.1064080925@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Triggers/perform oddity between 7.2 and 7.3  (Andreas Forsgren <andreas@sparcy.net>)
Список pgsql-general
Andreas Forsgren <andreas@sparcy.net> writes:
> Anyone knows how to solve this? I was playing around with triggers on
> my own machine which runs 7.3 and there it works okey, but when trying
> it on 7.2 I get an error about duplicate keys.

[checks code]  In 7.2, PERFORM didn't set FOUND; in 7.3 it does.
To make your code work with 7.2, the easiest thing would be to change
the PERFORM into a SELECT INTO.

            regards, tom lane

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