Search Postgresql Archives

in failed sql transaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx
www.exedio.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux