> Pgs... like a warning that you can't do this; > > begin > insert 1 --works > insert 2 --fails > commit > > row 1 will exist in db (yes, no kidding). This will not work in pg, > which I now see is obviously correct.
This should either a FAQ for MS-SQL or Spring, but since PG does it canonically it doesn't actually get asked very frequently ... Sounds like a nightmare specifically designed for vendor lock-in. My condolences. I am not sure how you can insert into a log even with savepoints, unless you put the logging statement first and then follow it with the insert. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
