Robert Treat <[EMAIL PROTECTED]> writes: > I thought this was needed for spec compliance?
BEGIN isn't in the spec at all ... Now you could point to the spec for START TRANSACTION, which saith 1) If a <start transaction statement> statement is executed when an SQL-transaction is currently active, then an exception condition is raised: invalid transaction state - active SQL-transaction. However, seeing that the spec doesn't think that an exception necessarily aborts the transaction, I think the case for saying that ERROR is more spec-compliant here than WARNING is mighty thin. And if you want to hold our feet to the fire about whether errors abort transactions or not, this particular point is not one thousandth part of what would need to change. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq