Re: Uncommitted Data - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Uncommitted Data
Date
Msg-id 1291773210.31995.117.camel@jd-desktop
Whole thread Raw
In response to Uncommitted Data  (Jonathan Tripathy <jonnyt@abpni.co.uk>)
List pgsql-general
On Wed, 2010-12-08 at 00:56 +0000, Jonathan Tripathy wrote:
> Hi Everyone,
>
> What does PG do with data that has been inserted into a table, but was
> never committed? Does the data get discarded once the connection dies?

Yes, the transaction will rollback.

>
> Thanks
>

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt


pgsql-general by date:

Previous
From: Ray Stell
Date:
Subject: Re: PG84 and SSL on CentOS-5.5 was PG84 and SELinux
Next
From: bubba postgres
Date:
Subject: Abusing Postgres in fun ways.