Thread: problems with getImportedKeys method

Hello,

When I execute method getImportedKeys:

ResultSet rs =
databaseMetaData.getImportedKeys(null,null,(String)tableName);

An exception occure:

java.sql.SQLException: ERROR: Unable to identify an ordering operator '<'
for type 'bytea'
Use an explicit ordering operator or modify the query

I use org.postgresql.Driver as a driver for PostgreSQL 7.0.1 database
running in HP-UX envirement.

How can I solve this problem ?


----------------------------------------------------------------------
Poczta nowych mozliwosci >>> http://link.interia.pl/f16bc

On Thu, 30 Jan 2003, Luke wrote:
> When I execute method getImportedKeys:
>
> java.sql.SQLException: ERROR: Unable to identify an ordering operator '<'
> for type 'bytea'
> Use an explicit ordering operator or modify the query
>
> I use org.postgresql.Driver as a driver for PostgreSQL 7.0.1 database
> running in HP-UX envirement.

The query being executed is SELECT DISTINCT which includes
pg_trigger.tgargs which is a bytea datatype.  The 7.0 server series does
not have support for ordering this datatype which means SELECT DISTINCT
cannot be done on it.  The DISTINCT part of this query has been removed in
the 7.4devel version of the driver, but unfortunately another problem has
presented itself.  The query used mixes explicit and implicit joins which
the 7.0 parser apparently has problems with.  You've got a couple of
options in order of best to worst:

1) Upgrade.  7.0.1 is quite old.
2) Get the current driver from cvs and change the joins to be implicit.
3) Try and remove the DISTINCT from whatever version of the driver you
have.


Kris Jurka

Luke,

What version of the jdbc driver are you using?  If it is the current 7.3
version, we don't try to maintain backward compatibility that many
releases.  Most things should work but not all.  Since 7.0 is quite an
old server version, I would suggest you upgrade.

thanks,
--Barry

Luke wrote:
> Hello,
>
> When I execute method getImportedKeys:
>
> ResultSet rs =
> databaseMetaData.getImportedKeys(null,null,(String)tableName);
>
> An exception occure:
>
> java.sql.SQLException: ERROR: Unable to identify an ordering operator '<'
> for type 'bytea'
> Use an explicit ordering operator or modify the query
>
> I use org.postgresql.Driver as a driver for PostgreSQL 7.0.1 database
> running in HP-UX envirement.
>
> How can I solve this problem ?
>
>
> ----------------------------------------------------------------------
> Poczta nowych mozliwosci >>> http://link.interia.pl/f16bc
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>