> 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.