Error prone compilation of stored procedure

From: pinker <pinker(at)onet(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Subject: Error prone compilation of stored procedure
Date: 2015-07-06 10:08:19
Message-ID: 1436177299736-5856699.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What's the reason behind very "tolerant" error checking during stored
procedure compilation?
Why PostgreSQL allows using variable (j_var) that doesn't exists? It isn't
column name or isn't declared anywhere. Like in example below:

CREATE OR REPLACE FUNCTION test()
RETURNS int AS
$BODY$
BEGIN

select 1 WHERE 1 > j_var;
RETURN 2;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;

--
View this message in context: http://postgresql.nabble.com/Error-prone-compilation-of-stored-procedure-tp5856699.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2015-07-06 10:39:07 Re: Error prone compilation of stored procedure
Previous Message Fabio Pardi 2015-07-06 10:07:45 Re: max number of locks