On Wed, 2010-12-08 at 00:56 +, Jonathan Tripathy wrote:
> 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?
The data is there, but is not visible. You can run an explicit VACUUM to
remove the "dead
On Wed, 2010-12-08 at 00:56 +, 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
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?
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.o
