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

Re: Line length in pl/pgsql function

From: "David Olbersen" <DOlbersen(at)stbernard(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Line length in pl/pgsql function
Date: 2004-03-17 19:50:44
Message-ID: E7E213858379814A9AE48CA6754F5ECB0D74A4@mail01.stbernard.com (view raw or flat)
Thread:
Lists: pgsql-sql
Tom Lane wrote:

> 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?

Sure. I didn't want to dump a huge email to have somebody say "Addressed in 7.3.5" :)

PostgreSQL version...: 7.3.4
Compiled with........: gcc 2.95.3
Architecture.........: Intel Pentium III
Operating System.....: FreeBSD 4.5-STABLE

 Reproduction
--------------
1) Connect to the database using psql
2) Attempt to create a return type and function using:
	\i test_ratedby_category_lang.plsql

The errors from psql are attached as psql-errors.txt
The file with the function is attached as test_ratedby_category_lang.plsql
The postgresql.conf and current postmaster.opts are attached as well.

I can send syslog output as well, if desired, at any debug level (I don't know what's appropriate).

I tried reproducing the bug before I composed this message and it didn't break in the same way as yesterday. That's not very helpful -- but it did still break with the same error message (as seen in psql-errors.txt) but my syslog output was different. I can attach both if that's helpful.

Any more info needed?

-- 
David Olbersen
iGuard Engineer
St. Bernard Software
15015 Avenue of Sciences
San Diego, CA 92127
x2152

Attachment: postmaster.opts
Description: application/octet-stream (47 bytes)
Attachment: postgresql.conf
Description: application/octet-stream (5.0 KB)
Attachment: test_ratedby_category_lang.plsql
Description: application/octet-stream (7.7 KB)
Attachment: psql-errors.txt
Description: text/plain (1.9 KB)

Responses

pgsql-sql by date

Next:From: David OlbersenDate: 2004-03-17 19:52:05
Subject: Re: Line length in pl/pgsql function
Previous:From: Gary StainburnDate: 2004-03-17 11:17:16
Subject: Re: working with unix timestamp

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