Craig Ringer <[email protected]> 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: [email protected] p: 305.321.1144 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
