Re: BUG #2395: Can't get right type oid by PQftype. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2395: Can't get right type oid by PQftype.
Date
Msg-id 18521.1145117947@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #2395: Can't get right type oid by PQftype.  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
Responses Re: BUG #2395: Can't get right type oid by PQftype.  (姜维 <jw@sduept.com>)
List pgsql-bugs
Volkan YAZICI <yazicivo@ttnet.net.tr> writes:
> On Apr 14 06:30, wangshj wrote:
>> In my database,the type oid of testdomainoid is 16385. But PQftype return 23
>> for testdomainoid's type oid.

> PQftype() returns the OID of the actual _type_ used in the domain.
> Therefore, you get 23, OID of the int4/int type, in the above query.

Yeah, this is considered a feature not a bug.  In fact the original
implementation just returned the domain's OID, and that was objected
to because most client programs wouldn't recognize it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2394: Multiple TRUNCATE within transaction
Next
From: "Majo George Cheruvathur"
Date:
Subject: connection problem in postgresql