Re: plpgsql temporary table problem - Mailing list pgsql-general

From Geoff Russell
Subject Re: plpgsql temporary table problem
Date
Msg-id Pine.LNX.4.44.0204151028320.7545-100000@localhost.localdomain
Whole thread Raw
In response to Re: plpgsql temporary table problem  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
On Sun, 14 Apr 2002, Bruce Momjian wrote:

> Tom Lane wrote:
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > ... I believe every reference to the TEMP table has
> > > to be an EXECUTE.  I think this will be fixed in 7.3 because the temp
> > > tables will exist in a separate schema.

Yes, if I make EVERY reference to the TEMP table an execute, then it
works. I don't understand the rest of your discussion, but thanks for
the work around.

I'm having trouble with posting to the news group at the moment (and
I can't seem to get back on the digest subscription list, despite
numerous attempts to subscribe after being mysteriously dropped), so
email will have to do.

Many thanks,
Geoff Russell

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Fifth Ave           +618-8332-5069 (Home)          |
St Morris SA 5068     +618-8207-2029 (Work)          | geoff@austrics.com.au
Adelaide, AUSTRALIA   +618-8364-1543 (Fax-Home)      |


pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: OT: Re: Scaling postgres
Next
From:
Date:
Subject: user question about log