Re: Error with temporary tables

Read the FAQ.

---------------------------------------------------------------------------

Claire McLister wrote:
> 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(at)zeesource(dot)net
> 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
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073