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

Re: [HACKERS] CREATE TEMP TABLE .... ON COMMIT

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org,pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] CREATE TEMP TABLE .... ON COMMIT
Date: 2002-08-27 04:29:35
Message-ID: 200208270429.g7R4TZq14356@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Gavin, how are you doing with this.  As I remember, the only remaining
issue was where to store the 'drop on commit' information in the
backend.  If that is all there is, we can come up with a solution.

---------------------------------------------------------------------------

Gavin Sherry wrote:
> On Fri, 9 Aug 2002, Tom Lane wrote:
> 
> > Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> writes:
> > > template1=# create temp table a (a int) on commit drop;
> > > ERROR:  You must be inside a transaction to use ON COMMIT
> > 
> > Surely that's only for ON COMMIT DROP, if you intend to offer the
> > others?
> 
> I should have provided details of this in the email. SQL99 details the
> baviour as follows:
> 
> If TEMPORARY is specified and ON COMMIT is omitted, then ON COMMIT
> DELETE ROWS is implicit
> 
> This might give users a bit of a surprise so the effective behaviour is ON
> COMMIT PRESERVE ROWS.
> 
> As for your question (and, perhaps, SQL99) I don't seen how it makes any
> sense to specify ON COMMIT outside of a transaction block.
> 
> > 
> > 			regards, tom lane
> > 
> 
> Gavin
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 

-- 
  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-hackers by date

Next:From: Gavin SherryDate: 2002-08-27 05:20:30
Subject: Re: [HACKERS] CREATE TEMP TABLE .... ON COMMIT
Previous:From: Bruce MomjianDate: 2002-08-27 04:22:20
Subject: Re: Default privileges for new databases (was Re: Can't

pgsql-patches by date

Next:From: Gavin SherryDate: 2002-08-27 05:20:30
Subject: Re: [HACKERS] CREATE TEMP TABLE .... ON COMMIT
Previous:From: Bruce MomjianDate: 2002-08-27 04:00:32
Subject: Re: pg_locks cleanup

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