[GENERAL] Error with temporary tables

[Claire McLister]

Hi,

 I'm using a pgsql function  that begins by creating a temporary  
table, does some processing, and then drops the temporary table just  
before exiting. It has been working fine for a while now, but  
suddenly complains for some calls that "Relation with OID" does not  
exist, at the point when it is executing the DROP table command.

 The general scheme is as follows:

 CREATE FUNCTION Foo(Integer) AS
 '
   BEGIN
      CREATE Temporary Table Bar AS (a left outer join of two tables)
          Do processing
      DROP Table Bar;
      RETURN 1;
   END
 '

 This is for Postgresql version 7.4.8

 Can someone tell me what I'm doing wrong? Should I try to use 'ON  
COMMIT DROP' instead?

 Thanks

Claire

 --
 Claire McLister                        [EMAIL PROTECTED]
 1684 Nightingale Avenue     Suite 201
 Sunnyvale, CA 94087            408-733-2737(fax)

                     http://www.zeemaps.com



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match