| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "David Olbersen" <DOlbersen(at)stbernard(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Line length in pl/pgsql function |
| Date: | 2004-03-17 05:35:47 |
| Message-ID: | 21150.1079501747@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"David Olbersen" <DOlbersen(at)stbernard(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-03-17 09:27:50 | Re: Line length in pl/pgsql function |
| Previous Message | David Olbersen | 2004-03-17 00:47:34 | Line length in pl/pgsql function |