Using perl DBI, I would like to catch a backend error and, if the
pgsql error string matches a particular regex (/ExecInitIndexScan:
both left and right op's are rel-vars/), vacuum on the fly and
immediately resubmit the query within the same transaction.
[Vacuuming has sometimes worked as a temporary fix to the problem.]
The immediate problem seems to be that once the backend fails on a
query within a transaction, the client is not permitted to do any more
queries within that transaction, giving this msg:
NOTICE: (transaction aborted): queries ignored until END
Any suggestions on how I might handle this?
pgsql-hackers by date
|Next:||From: Patrick Welche||Date: 2000-03-08 18:58:28|
|Subject: Re: [HACKERS] alter_table.sql|
|Previous:||From: Keith Parks||Date: 2000-03-08 16:52:25|
|Subject: Regression test failure (runcheck)|