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

From Volkan YAZICI
Subject Re: BUG #2395: Can't get right type oid by PQftype.
Date
Msg-id 20060415153258.GA175@alamut
Whole thread Raw
In response to BUG #2395: Can't get right type oid by PQftype.  ("wangshj" <wangshj@sduept.com>)
Responses Re: BUG #2395: Can't get right type oid by PQftype.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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.

> How could I get the testdomainoid's type oid.

Simply by querying pg_type catalog:

SELECT oid FROM pg_catalog.pg_type WHERE typname = 'testdomainoid';


Regards.

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #2393: update fails with unique constraint violation
Next
From: Tom Lane
Date:
Subject: Re: BUG #2394: Multiple TRUNCATE within transaction