Re: BUG #2395: Can't get right type oid by PQftype.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
Cc: wangshj <wangshj(at)sduept(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2395: Can't get right type oid by PQftype.
Date: 2006-04-15 16:19:07
Message-ID: 18521.1145117947@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message 姜维 2006-04-16 00:52:53 Re: BUG #2395: Can't get right type oid by PQftype.
Previous Message Tom Lane 2006-04-15 16:17:29 Re: BUG #2394: Multiple TRUNCATE within transaction