dbTalk Databases Forums  

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: [BUGS] BUG #2395: Can't get right type oid by PQftype. in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] BUG #2395: Can't get right type oid by PQftype. - 04-15-2006 , 11:19 AM






Volkan YAZICI <yazicivo (AT) ttnet (DOT) net.tr> writes:
Quote:
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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.