Re: create temp table .. on commit delete rows - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: create temp table .. on commit delete rows
Date
Msg-id 452E2A8C.6060601@enterprisedb.com
Whole thread Raw
In response to create temp table .. on commit delete rows  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: create temp table .. on commit delete rows
List pgsql-hackers
Teodor Sigaev wrote:
> 2)
> # insert into a values(1);

You're running in auto-commit, mode. An implicit commit happens after 
this statement. Which clears the table.

> # begin;
> # insert into a values(2);
> # rollback;
> # select * from a;
>  a
> ---
> (0 rows)
> 
> It seems to me that 1) is good, but 2) makes some strange, unpredictable 
> result...

Looks right to me.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: create temp table .. on commit delete rows
Next
From: Teodor Sigaev
Date:
Subject: Re: create temp table .. on commit delete rows