Re: I remember why I suggested CREATE FUNCTION...AS NULL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: I remember why I suggested CREATE FUNCTION...AS NULL
Date
Msg-id 27642.968464110@sss.pgh.pa.us
Whole thread Raw
In response to Re: I remember why I suggested CREATE FUNCTION...AS NULL  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
>> ALTER FUNCTION numpeople() AS 
>> 'SELECT COUNT(*) FROM managers' LANGUAGE 'plpgsql';

> Actually, I think this would still work, because it
> doesn't check the table name existance until it's 
> used for the first time, not when it's created.

But SQL-language function bodies are checked at entry, not only
at first use.  (I consider it a deficiency of plpgsql that it
doesn't do likewise.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: I remember why I suggested CREATE FUNCTION...AS NULL
Next
From: "Stephan Szabo"
Date:
Subject: Fw: I remember why I suggested CREATE FUNCTION...AS NULL