Had one committed lunch ticket, id 7. In a test transaction I added 8 then tried 7 again. Unique violation. Fine. Then my perfectly well-behaved SELECT replied "current transaction is aborted, commands ignored until end of transaction block". The night porter in this story is me and I would like my lunch back from both lawyers.