Postgres Pro
Downloads
Home   >   mailing lists

Re: lifetime of temp schema versus compiled image of plpgsql proc - Mailing list pgsql-sql

From Tom Lane
Subject Re: lifetime of temp schema versus compiled image of plpgsql proc
Date
Msg-id 14493.1082685969@sss.pgh.pa.us
Whole thread Raw
In response to lifetime of temp schema versus compiled image of plpgsql proc  ("Dennis" <pg-user@calico-consulting.com>)
List pgsql-sql
Tree view 
"Dennis" <pg-user@calico-consulting.com> writes:
> then on the same connection, I open a transaction, execute a plpgsql 
> function that populates the temp tables and the function bombs with this 
> error message: 

> ERROR: schema "pg_temp_8" does not exist 

That's a bit hard to believe.  Could we see a complete test case?
        regards, tom lane

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: lifetime of temp schema versus compiled image of plpgsql proc
Next
From: Tom Lane
Date:
Subject: Re: lifetime of temp schema versus compiled image of plpgsql proc