Re: plpgsql temporary table problem

From: Geoff Russell <geoff(at)austrics(dot)com(dot)au>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: plpgsql temporary table problem
Date: 2002-04-15 01:05:32
Message-ID: Pine.LNX.4.44.0204151028320.7545-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 14 Apr 2002, Bruce Momjian wrote:

> Tom Lane wrote:
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)austrics(dot)com(dot)au
Adelaide, AUSTRALIA +618-8364-1543 (Fax-Home) |

In response to

Browse pgsql-general by date

  From Date Subject
Next Message sp8925 2002-04-15 01:58:54 user question about log
Previous Message Bruce Momjian 2002-04-15 00:24:30 Re: [GENERAL] Notify argument?