bug in PLPGSQL - Mailing list pgsql-hackers

From Kovacs Zoltan
Subject bug in PLPGSQL
Date
Msg-id Pine.LNX.4.21.0105141032120.941-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
In response to Re: \c connects as another user instead I want in psql  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: bug in PLPGSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
In 7.1.1 the following statement doesn't work (backend closes
immediately):

SELECT INTO var1, var2 col1, col2 FROM table WHERE conditions;

In 7.1 (final) this problem doesn't occur.

Workaround:

var1 := col1 FROM table WHERE conditions;
var2 := col2 FROM table WHERE conditions;

(Of course I'd better not rewrite my 200K code of PLGSQL... :-)

TIA, Zoltan

--                         Kov\'acs, Zolt\'an                        kovacsz@pc10.radnoti-szeged.sulinet.hu
          http://www.math.u-szeged.hu/~kovzol                        ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz
 



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Re: 7.2 items
Next
From: Franck Martin
Date:
Subject: Re: 7.2 items