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