-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/27/06 06:48, Gurjeet Singh wrote: > On 10/27/06, Ron Johnson <ron.l.johnson@xxxxxxx> wrote: >> >> Dueling examples. Attached are two examples of errors. > > > I think you completely missed that I am recommending using '\set > ON_ERROR_ROLLBACK on' in psql. > > Please refer to my previous post and see the effect of the following line: > > postgres=# \set ON_ERROR_ROLLBACK on But I do *not* want my whole transaction to roll back!! - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFQgH8S9HxQb37XmcRAsW+AKCOzz6WidLYlS96oacxCL0qbaxfOACgqz/H /RA16NFFwi82JyibP58tmUI= =jNzL -----END PGP SIGNATURE-----