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

Reply via email to