| From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
|---|---|
| To: | mdoggett(at)coas(dot)oregonstate(dot)edu |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: SQL error |
| Date: | 2004-05-19 18:43:59 |
| Message-ID: | 40ABAAEF.5070601@pse-consulting.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Caduto | 2004-05-22 15:22:39 | new win32 build |
| Previous Message | Matt Doggett | 2004-05-19 15:52:39 | SQL error |