[HACKERS] PL/PGSQL and drop/create table

2005-09-07 Thread Teodor Sigaev
# 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

2005-09-07 Thread Michael Fuhr
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