Re: Line length in pl/pgsql function - Mailing list pgsql-sql

From Tom Lane
Subject Re: Line length in pl/pgsql function
Date
Msg-id 21150.1079501747@sss.pgh.pa.us
Whole thread Raw
In response to Line length in pl/pgsql function  ("David Olbersen" <DOlbersen@stbernard.com>)
List pgsql-sql
"David Olbersen" <DOlbersen@stbernard.com> writes:
> I was minding my business, writing a nice long pl/pgsql function and all was well. I tried creating the function
(using\i <file-with-definition>) and started getting funny errors.
 

> I figured out eventually that the problem seems due to line length in a construct of: FOR result IN <SELECT ...>
LOOP

Hmm ... plpgsql had some string-length issues as recently as 7.2.2, but
I don't know of any problems since then.  Could you submit a *complete*
test case, rather than making us guess the details?
        regards, tom lane


pgsql-sql by date:

Previous
From: "David Olbersen"
Date:
Subject: Line length in pl/pgsql function
Next
From: Richard Huxton
Date:
Subject: Re: Line length in pl/pgsql function