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

From: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
To: wangshj <wangshj(at)sduept(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2395: Can't get right type oid by PQftype.
Date: 2006-04-15 15:32:58
Message-ID: 20060415153258.GA175@alamut
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-04-15 16:17:29 Re: BUG #2394: Multiple TRUNCATE within transaction
Previous Message Bruce Momjian 2006-04-15 14:04:56 Re: BUG #2393: update fails with unique constraint violation