Hi.
Is there any way to make postgres not abort the transaction on failed select?
I have a system that uses ORM to retrieve data; ORM is very slow for some cases, so there's a perf optimization that issues ANSI SQL queries directly thru ORM's built-in passthru, and falls back to ORM if they fail.
All of these queries are select-s, and the retrieval can be a part of an external transaction.
It worked great in MySQL, but Postgres being differently ANSI-non-compliant, the queries do fail. Regardless of whether they can be fixed, in such cases the fall-back should work. What happens in Postgres however is that the transaction is aborted; all further SELECTs are ignored.
Is there some way to get around this and not abort the transaction on failed selects?
This behavior seems extremely counter-intuitive.
Thanks.
