From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Carl Olivier <carl(at)zero-one(dot)co(dot)za> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: DatabaseMetaData and Transactions |
Date: | 2005-06-06 14:23:12 |
Message-ID: | F76A1422-9F37-4A26-9430-51071837CF3C@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sylvain Boily | 2005-06-07 09:34:27 | Probleme with jdbc driver an openxhange. |
Previous Message | Carl Olivier | 2005-06-06 13:38:16 | DatabaseMetaData and Transactions |