=?ISO-8859-1?Q?H=E5vard_Wahl_Kongsg=E5rd?= <haavard.kongsgaard@xxxxxxxxx> writes: > Hi, I have a problem with newline or tab completing when adding a > generated FUNCTION via the psql interface (have tried pasting and > adding it with -f rule.sql) > parser stack overflow at or near "THEN" > LINE 5002: ELSIF ( NEW.a between 1246566738 and 1247010220 ) THEN That's pretty interesting. Could we see a complete (self-contained) example of this problem, rather than a snippet? And what PG version is this exactly? Given that line number, though, I wonder whether your problem is that you tried to put several thousand nested IFs into one plpgsql function. If so, the answer is probably "refactor your code". You *will* eventually hit this type of error if you nest stuff deeply enough. I don't know exactly where the limit is, and it probably varies a lot depending on platform, PG version, etc etc anyway. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
