Postgres Pro
Downloads
Home   >   mailing lists

in failed sql transaction - Mailing list pgsql-general

From Ralf Wiebicke
Subject in failed sql transaction
Date
Msg-id 200609241203.59292.ralf.wiebicke@exedio.com
Whole thread Raw
Responses Re: in failed sql transaction  (Michael Fuhr <mike@fuhr.org>)
Re: in failed sql transaction  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: in failed sql transaction  (Ralf Wiebicke <ralf.wiebicke@exedio.com>)
Re: in failed sql transaction  (Ralf Wiebicke <ralf.wiebicke@exedio.com>)
List pgsql-general
Tree view 
Hi all!

I just realized the following behaviour in postgresql: when I violate any
constraint (unique constraint in my case) then the transaction is not usable
anymore. Any other sql command returns a "in failed sql transaction" error.
All other databases I used up to now just ignore the statement violating the
constraint, but leave the transaction intact.

Is this intended behaviour or rather a bug? Or is there any way to "switch on"
the behaviour I'd like to see?

Best regards,
Ralf.


--
Ralf Wiebicke
Softwareengineer

exedio GmbH
Am Fiebig 14
01561 Thiendorf
Deutschland

Telefon +49 (35248) 80-118
Fax +49 (35248) 80-199
ralf.wiebicke@exedio.com
www.exedio.com

pgsql-general by date:

Previous
From: viniciusasousa@yahoo.com.br
Date:
Subject: Re: Connecting to PostgreSQL Server
Next
From: "Mike Chiarappa"
Date:
Subject: Re: Sun Java Studio Creator and PostgreSQL