Error with temporary tables

[Claire McLister <mclister@xxxxxxxxxxxxx>]

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                        mclister@xxxxxxxxxxxxx
 1684 Nightingale Avenue     Suite 201
 Sunnyvale, CA 94087            408-733-2737(fax)

                     http://www.zeemaps.com