Re: create temp table .. on commit delete rows

From: David Fetter <david(at)fetter(dot)org>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: 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:01:12
Message-ID: 20061012190112.GD24237@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-10-12 19:03:43 Re: SQL functions, INSERT/UPDATE/DELETE RETURNING, and triggers
Previous Message Tom Lane 2006-10-12 19:00:13 Re: SQL functions, INSERT/UPDATE/DELETE RETURNING, and triggers