Skip site navigation (1) Skip section navigation (2)

Re: lifetime of temp schema versus compiled image of plpgsql proc

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Dennis <pg-user(at)calico-consulting(dot)com>
Cc: postgres SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: lifetime of temp schema versus compiled image of plpgsql proc
Date: 2004-04-22 23:54:42
Message-ID: 200404222354.i3MNsgF26021@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
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(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

In response to

Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2004-04-23 02:06:09
Subject: Re: lifetime of temp schema versus compiled image of plpgsql proc
Previous:From: Bruce MomjianDate: 2004-04-22 23:46:00
Subject: Re: lifetime of temp schema versus compiled image of plpgsql proc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group