| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Magnus Naeslund\(f\)" <mag(at)fbab(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: PQftype() |
| Date: | 2001-04-30 22:11:54 |
| Message-ID: | 361.988668714@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Magnus Naeslund\(f\)" <mag(at)fbab(dot)net> writes:
> Where do get a listing of what PQftype() can return to me?
>>
>> select oid, typname from pg_type
> Does these change often?
The system type OIDs are stable. User-defined types would probably have
a new OID after a dump and reload.
> Or could i do like the ODBC driver, autogenerate a .h out of that table.
I would not recommend relying on compiled-in OID knowledge for any types
other than the system-defined datatypes. If you expect to have to deal
with user-defined types, it's best to cache the results of pg_type
lookups at the client end. You need not worry about OIDs changing
during a single client connection.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Naeslund(f) | 2001-04-30 22:13:49 | Re: PQftype() |
| Previous Message | Magnus Naeslund(f) | 2001-04-30 22:06:03 | Re: PQftype() |