Thread: [ psqlodbc-Bugs-1010303 ] Incorrect data type with domains
Bugs item #1010303, was opened at 26-02-2008 03:59 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010303&group_id=1000125 Category: None Group: None Status: Open Resolution: None Priority: 3 Submitted By: Luiz Matsumura (luizkm) Assigned to: Nobody (None) Summary: Incorrect data type with domains Initial Comment: Environment psqlODBC 8.03.100 Postgres 8.3 Visual FoxPro 9.0 CREATE DOMAIN test_domain AS numeric(12,4) DEFAULT 0 NOT NULL; CREATE TABLE test_table ( id serial NOT NULL, field2 test_domain ); Then try to retrieve data from test_table: SELECT * FROM test_table; field2 is returned with incorrect size and precision. Mylog e commlog atached P.S.: psqlODBC 8.01.200 return correct result. Thanks in advance ---------------------------------------------------------------------- >Comment By: Luiz Matsumura (luizkm) Date: 26-02-2008 15:33 Message: Hi, I research a little and think that this can help It´s based on information_squema.columns view ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010303&group_id=1000125