Re: Triggers/perform oddity between 7.2 and 7.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: Triggers/perform oddity between 7.2 and 7.3
Date
Msg-id 26218.1064080925@sss.pgh.pa.us
Whole thread Raw
In response to Triggers/perform oddity between 7.2 and 7.3  (Andreas Forsgren <andreas@sparcy.net>)
List 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 by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: This mail list and its policies
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: This mail list and its policies