Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group