Matt Doggett wrote:
Whenever I am editing SQL statements in the query window and I either submit erroneous SQL or cancel an SQL transaction, any subsequent attempts to submit the SQL results in the following error message:
ERROR: current transaction is aborted, commands ignored until end of transaction block
The only way to clear it is to close the query window completely and start with a new one. Is this normal behavior or is there some setting that will correct this?
The query window doesn't interpret pgsql's output, so what the backend probably expects from you is a rollback.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly