Обсуждение: Problem with newline/tab completing with psql

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

Have also tried using the -n option with psql and set
disable-completion on in .inputrc

Is there any other method to solve this problem?

--
Håvard Wahl Kongsgård

=?ISO-8859-1?Q?H=E5vard_Wahl_Kongsg=E5rd?= <haavard.kongsgaard@gmail.com> 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