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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general