Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce Momjian
Subject Re: lifetime of temp schema versus compiled image of plpgsql proc
Date
Msg-id 200404222354.i3MNsgF26021@candle.pha.pa.us
Whole thread Raw
In response to Re: lifetime of temp schema versus compiled image of plpgsql proc  ("Dennis" <pg-user@calico-consulting.com>)
Responses Re: lifetime of temp schema versus compiled image of plpgsql proc  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
Dennis wrote:
> Bruce Momjian writes: 
> 
> > 
> > There is an FAQ item on this --- use EXECUTE.
> 
> So I should be using EXECUTE for all access to the temp tables? ie inserts, 
> and selects (in this case). Should I use execute for the table creation? 

All access from plpgsql functions for temp tables should use EXECUTE,
yea.

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

pgsql-sql by date:

Previous
From: Janning Vygen
Date:
Subject: Is there an easy way to normalize-space with given string functions
Next
From: Tom Lane
Date:
Subject: Re: lifetime of temp schema versus compiled image of plpgsql proc