Re: Finding exact column type via java.sql.ResultSetMetaData

Hello,

I'm scratching my head over ResultSetMetaData yet again, this time related to figuring out the correct type of a column.

Am I right in understanding that given a SQL command whose resultset contains a field of a user defined type not originating from a table, you cannot look up the exact type for that field via the result set meta data if multiple types of the same name are defined in different schemas? AFAICT ResultSetMetaData only gives the name the type is defined with in the database, via getColumnTypeName, but not the schema of that type. Should the result for getColumnTypeName have been prefixed with schema-plus-dot, or is that not possible or not according to the spec? Unless I'm missing something the code I'm writing will basically have to throw an exception and apologize that different types with the same name in different schemas is not supported when it runs into that.


I'm testing with:

CREATE SCHEMA test_schema;
CREATE SCHEMA another_test_schema;

CREATE TYPE test_schema.test_type AS ( intfield int, textfield varchar );
CREATE TYPE another_test_schema.test_type AS ( other_textfield varchar, other_intfield int );

And given the query:
SELECT (1,'adsf')::test_schema.test_type, ('zxcv',2)::another_test_schema.test_type;

Then java.sql.ResultSetMetaData gives the exact same information for each column, with getColumnTypeName giving "test_type" for both. Simple test-case with this and a bit of runnable Java included.

Thanks,
Thor Michael Støre






--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc