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
psql:test_ratedby_category_lang.plsql:1: ERROR: Relation 'ratedby_return_set' already exists psql:test_ratedby_category_lang.plsql:101: ERROR: parser: parse error at or near "t" at character 3613 psql:test_ratedby_category_lang.plsql:102: ERROR: parser: parse error at or near "LOOP" at character 21 psql:test_ratedby_category_lang.plsql:118: ERROR: parser: parse error at or near "ELSIF" at character 13 psql:test_ratedby_category_lang.plsql:119: ERROR: parser: parse error at or near "LOOP" at character 21 psql:test_ratedby_category_lang.plsql:135: ERROR: parser: parse error at or near "ELSE" at character 13 psql:test_ratedby_category_lang.plsql:136: ERROR: parser: parse error at or near "LOOP" at character 21 psql:test_ratedby_category_lang.plsql:137: ERROR: parser: parse error at or near "IF" at character 17 psql:test_ratedby_category_lang.plsql:156: ERROR: parser: parse error at or near "ELSE" at character 9 psql:test_ratedby_category_lang.plsql:157: ERROR: parser: parse error at or near "LOOP" at character 21 psql:test_ratedby_category_lang.plsql:174: ERROR: parser: parse error at or near "ELSIF" at character 13 psql:test_ratedby_category_lang.plsql:175: ERROR: parser: parse error at or near "LOOP" at character 21 psql:test_ratedby_category_lang.plsql:193: ERROR: parser: parse error at or near "ELSE" at character 13 psql:test_ratedby_category_lang.plsql:194: ERROR: parser: parse error at or near "LOOP" at character 21 psql:test_ratedby_category_lang.plsql:195: ERROR: parser: parse error at or near "IF" at character 17 psql:test_ratedby_category_lang.plsql:196: ERROR: parser: parse error at or near "IF" at character 13 psql:test_ratedby_category_lang.plsql:198: ERROR: parser: parse error at or near "RETURN" at character 9 psql:test_ratedby_category_lang.plsql:199: WARNING: COMMIT: no transaction in progress COMMIT psql:test_ratedby_category_lang.plsql:200: ERROR: parser: parse error at or near "' LANGUAGE '" at character 1
test_ratedby_category_lang.plsql
Description: test_ratedby_category_lang.plsql
postgresql.conf
Description: postgresql.conf
postmaster.opts
Description: postmaster.opts
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
