> Ah, you had not even mentioned that the trigger was in pltcl. > spi_exec runs everything in subtransactions as of 8.0, so that > it can catch errors and propagate them back as Tcl errors. Okay, so are there any possible options? Would GetTopTransactionId() work, as Michael suggested further up? Thanks, Steve ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings