Thread: SQL error

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?

Thanks,

Matt

Pgadmin3 1.1.0 Dev (11 Feb 04) on Win2k

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