Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> writes: > I've been working in psql a lot recently, and have started to wonder why > statements with syntax errors or other problems that render them > unexecutable terminate the transaction. Well, the obvious reason is that it's hard to tell what the user meant, so bailing is the safest response. > I understand why statements that raise errors during their execution > terminate a transaction, So you're suggesting that "SELECT 1/0;" should terminate a transaction, but "SELECT 1//0;" should not? How about "ROLBACK;"? It gets pretty squishy pretty fast when you try to decide which sorts of errors are more important than others. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
