Re: create temp table .. on commit delete rows

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: David Fetter <david(at)fetter(dot)org>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: create temp table .. on commit delete rows
Date: 2006-10-12 19:07:28
Message-ID: 20061012190728.GS28647@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Oct 12, 2006 at 12:01:12PM -0700, David Fetter wrote:
> On Thu, Oct 12, 2006 at 03:51:39PM +0400, Teodor Sigaev wrote:
> > >You're running in auto-commit, mode. An implicit commit happens
> > >after this statement. Which clears the table. Looks right to me.
> >
> > Oops, I see
>
> Should something notice and raise a warning when people create a TEMP
> table and have AUTOCOMMIT on?

Maybe if ON COMMIT is set to DELETE ROWS or DROP...
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2006-10-12 19:07:45 Re: On status data and summaries
Previous Message Jeff Davis 2006-10-12 19:07:11 Re: Hints proposal