Re: Type OIDs - Mailing list pgsql-interfaces

From Joe Conway
Subject Re: Type OIDs
Date
Msg-id 4A2720DE.6070003@joeconway.com
Whole thread Raw
In response to Re: Type OIDs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
Tom Lane wrote:
> Florian Weimer <fw@deneb.enyo.de> writes:
>> Can I embed the types I'm interested in into my program, or should I
>> query the server at least once per connection to get the mapping?  I'm
>> interested in types such as INTEGER, TEXT, BYTEA, etc.  No user
>> defined types, and nothing fancy.  Ultra-long-term portability isn't
>> required, either.
> 
> Well, the type OIDs of the standard built-in types haven't changed in
> at least ten years, but that doesn't mean we won't change 'em in the
> future.  I'd advise at least using the #define's from pg_type.h rather
> than writing actual numeric constants.

I'll second that. It's exactly what I've been doing in PL/R for several 
years now.

Joe


pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: Type OIDs
Next
From: Florian Weimer
Date:
Subject: Re: Type OIDs