Re: using domain types with ODBC, esp. lo - Mailing list pgsql-odbc

From Tom Lane
Subject Re: using domain types with ODBC, esp. lo
Date
Msg-id 13532.1048264312@sss.pgh.pa.us
Whole thread Raw
In response to using domain types with ODBC, esp. lo  (Andreas Pflug <Andreas.Pflug@web.de>)
Responses Re: using domain types with ODBC, esp. lo
List pgsql-odbc
Andreas Pflug <Andreas.Pflug@web.de> writes:
> The well-known data types PG_TYPE_DATETIME, PG_TYPE_TIMESTAMP_NO_TMZONE,
> PG_TYPE_TIME, PT_TYPE_TIME_WITH_TMZONE are handled in a special way
> concerning the atttypmod field. This will fail for domain types of that
> base type.

This is correct, since the domain won't expose the atttypmod it assigns
to the underlying type.

> Actually, best thing for this problems would be if the backend would
> deliver the base type oid, not the user type oid.

There was some discussion of that idea in pgsql-hackers last week, but
we didn't come to a definite conclusion.  How do others feel about it?

            regards, tom lane

pgsql-odbc by date:

Previous
From: Andreas Pflug
Date:
Subject: using domain types with ODBC, esp. lo
Next
From: Andreas Pflug
Date:
Subject: ODBC driver settings for BLOBs