To: Andreas Pflug <Andreas.Pflug@web.de>
Cc: pgsql-odbc@postgresql.org
Subject: Re: using domain types with ODBC, esp. lo 
In-reply-to: <3E7B3BA7.20709@web.de> 
References: <3E7B3BA7.20709@web.de>
Comments: In-reply-to Andreas Pflug <Andreas.Pflug@web.de>
	message dated "Fri, 21 Mar 2003 17:19:51 +0100"
Date: Fri, 21 Mar 2003 11:31:52 -0500
Message-ID: <13532.1048264312@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

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