[HACKERS] PL/PGSQL and drop/create table
# create table foo ( bar int ); CREATE TABLE # create or replace function func (int) returns int as $$ DECLARE IID alias for $1; CNT int; BEGIN select into CNT count(*) from foo where bar = IID; RETURN CNT; END; $$ language plpgsql; CREATE FUNCTION #
Re: [HACKERS] PL/PGSQL and drop/create table
On Wed, Sep 07, 2005 at 03:51:05PM +0400, Teodor Sigaev wrote: ERROR: relation with OID 16628 does not exist CONTEXT: SQL statement SELECT count(*) from foo where bar = $1 http://www.postgresql.org/docs/faqs.FAQ.html#4.19 -- Michael Fuhr ---(end of