| From: | Venkataseshareddy(dot)Gotham(at)bwir(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | FW: sql exception problem |
| Date: | 2003-04-08 06:15:39 |
| Message-ID: | 6B58265FDC58D611B9C5000255472E5E64C4E6@bwirmxsusr1.bwir.bwco |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Subject: sql exception problem
Hi ,
As we talked about in the meeting today, when a SQLException occurs, the
database ignores all subsequent queries.
I've attached the catalina.out file which shows the SQLException (on line
11547) and the subsequent errors (such as on line 11733).
I've also attached the pgsql log file, which shows the message "current
transaction is aborted, queries ignored until end of transaction block".
We need to find a way to end the transaction after a SQLException occurs
so that the program can continue and the database will respond instead of
ignoring the queries.
Thanks for you help with this,
SESHA REDDY
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kang Wonseok) <wskang@world.kaist.ac.kr> | 2003-04-08 07:00:41 | When to sort texts data encoded in UTF-8, retrieve as non-ordered data. |
| Previous Message | Tom Lane | 2003-04-08 03:06:30 | Re: Dump and Restore of Database by User |