SEO

#1 (**permalink**) 04-15-2008, 11:18 PM

Greetings.

Having a problem with regards DatabaseMetaData retrievals within a
Transaction. I have a large transaction running - within which database
alterations need to occur. However, during this process I need to retrieve
Table metadata (via the DatabaseMetaData.getTables() method). However, this
does not seem possible in POSTGRES? I receive the following error:

ERROR: current transaction is aborted, queries ignored until end of
transaction block.

I trace that directly to a call to the getTables method of the
DatabaseMetaData implementation.

Can anyone provide me with any advice here? Is this correct behaviour, and
is there any way (other than caching table metadata prior to, and
maintaining said cache during the transaction) to allow for meta data
retrieval during a transaction?

Thanks in advance!

Regards,

Carl

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#2 (**permalink**) 04-15-2008, 11:19 PM

Carl,

One of the queries is failing, have a look at the logs in postgres
and report back to
us what is failing.

Dave
On 6-Jun-05, at 9:38 AM, Carl Olivier wrote:

> Greetings.
>
> Having a problem with regards DatabaseMetaData retrievals within a
> Transaction. I have a large transaction running - within which
> database
> alterations need to occur. However, during this process I need to
> retrieve
> Table metadata (via the DatabaseMetaData.getTables() method).
> However, this
> does not seem possible in POSTGRES? I receive the following error:
>
> ERROR: current transaction is aborted, queries ignored until end of
> transaction block.
>
> I trace that directly to a call to the getTables method of the
> DatabaseMetaData implementation.
>
> Can anyone provide me with any advice here? Is this correct
> behaviour, and
> is there any way (other than caching table metadata prior to, and
> maintaining said cache during the transaction) to allow for meta data
> retrieval during a transaction?
>
> Thanks in advance!
>
> Regards,
>
> Carl
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DatabaseMetaData and Transactions