On 2014-04-07 15:46:42 +0530, Atri Sharma wrote: > On Mon, Apr 7, 2014 at 3:41 PM, Pavel Stehule <pavel.steh...@gmail.com>wrote: > I am missing something here, but how does making it a subtransaction break > consistency? Isnt that what should actually be happening so that the > autonomous transaction's changes are actually visible till the parent > transaction commits? > > What am I missing here?
START TRANSACTION; INSERT INTO referenced_to_table ... id = 1; START AUTONOMOUS SUBTRANSACTION; INSERT INTO referencing_table id = 1 ...; COMMIT AUTONOMOUS SUBTRANSACTION; ROLLBACK; Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers