Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> writes: > On 03/14/2011 10:55 PM, Vogt, Michael wrote: > >> Hey all >> >> I have a question, using the autocommit off option in postgres. >> >> As starting position I use a table called xxx.configuration using a >> unique id constraint. >> >> Why does postgres rollback the whole transaction after an error? > > It's a PostgreSQL limitation (or, arguably, optimization). When a Well, any transactional RDBMS whatsoever should behave that way. Hardly a PostgreSQL exclusive feature :-) -- Jerry Sievers e: gsievers19@xxxxxxxxxxx p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
