Re: SQL error

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