Skip site navigation (1) Skip section navigation (2)

Re: Line length in pl/pgsql function

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: (view raw, whole thread or download thread mbox)
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

In response to

pgsql-sql by date

Next:From: Richard HuxtonDate: 2004-03-17 09:27:50
Subject: Re: Line length in pl/pgsql function
Previous:From: David OlbersenDate: 2004-03-17 00:47:34
Subject: Line length in pl/pgsql function

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group