Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAL3Kvs56382 for ; Mon, 20 Nov 2000 22:20:57 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from sectorbase2.sectorbase.com ([208.48.122.131]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAFJQFs24755 for ; Wed, 15 Nov 2000 14:26:15 -0500 (EST) (envelope-from vmikheev@SECTORBASE.COM) Received: by sectorbase2.sectorbase.com with Internet Mail Service (5.5.2650.21) id ; Wed, 15 Nov 2000 11:07:22 -0800 Message-ID: <8F4C99C66D04D4118F580090272A7A234D3181@sectorbase1.sectorbase.com> From: "Mikheev, Vadim" To: "'Cristi Petrescu-Prahova'" , pgsql-sql@postgresql.org Subject: RE: how to continue a transaction after an error? Date: Wed, 15 Nov 2000 11:11:27 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200011/165 X-Sequence-Number: 196 > I would like to insert a bunch of rows in a table in a > transaction. Some of > the insertions will fail due to constraints violation. When > this happens, > Postgres automatically ends the transaction and rolls back > all the previous > inserts. I would like to continue the transaction and issue the > commit/rollback command myself. > > How to do it? > Is there any setting I am missing? > Is it possible at all? Hopefully, we'll have savepoints in 7.2 Vadim