Re: Triggers/perform oddity between 7.2 and 7.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Forsgren <andreas(at)sparcy(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Triggers/perform oddity between 7.2 and 7.3
Date: 2003-09-20 18:02:05
Message-ID: 26218.1064080925@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas Forsgren <andreas(at)sparcy(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-09-20 18:04:11 Re: This mail list and its policies
Previous Message Tom Lane 2003-09-20 17:42:19 Re: 7.3.2 client connecting to 7.2.1 server problem