Re: [SQL] Problems with temp table and PL

2007-02-21 Thread A. Kretschmer
am Wed, dem 21.02.2007, um 18:17:50 -0300 mailte Martin Marques folgendes: > I create a temp table inside a plpgsql function, which is drop just before > ending (the function). > > My problem is that if I execute the same function again (in the same > session) I get an error when trying to inse

Re: [SQL] Problems with temp table and PL

2007-02-21 Thread Andrew Sullivan
On Wed, Feb 21, 2007 at 06:17:50PM -0300, Martin Marques wrote: > My problem is that if I execute the same function again (in the same > session) I get an error when trying to insert data into it (looks like the > session has an old reference of the table): You have to use EXECUTE for this. See

[SQL] Problems with temp table and PL

2007-02-21 Thread Martin Marques
I create a temp table inside a plpgsql function, which is drop just before ending (the function). My problem is that if I execute the same function again (in the same session) I get an error when trying to insert data into it (looks like the session has an old reference of the table): => SEL