Skip site navigation (1) Skip section navigation (2)

Re: Data type OIDs

From: Joe Conway <mail(at)joeconway(dot)com>
To: Greg <grigorey(at)yahoo(dot)co(dot)uk>
Cc: Thom Brown <thombrown(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Data type OIDs
Date: 2010-07-07 16:44:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On 07/07/2010 01:15 AM, Greg wrote:
> Hi Thom, well, it relates to reading/writing data using PostgreSQL
> protocol (v3). For example RowDescription message uses type OID to
> identify data type of the field. Same as with Parse message I need to
> specify OID of the parameter data type. As a result I want to declare an
> enum of all used data types and assignd PostgreSQL data type OID to
> appropriate value  - so development could be a little more intuitive.

I don't think there is any promise that type OIDs will never change, but
in practice they have been stable for many releases over 10+ years.

You should, however, use the macros in pg_type.h to refer to them, e.g.



Joe Conway
credativ LLC:
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & Support

In response to


pgsql-novice by date

Next:From: Arvind SharmaDate: 2010-07-07 17:06:17
Subject: Triggers, Stored Procedures to Aggregate table ?
Previous:From: gargoyle60Date: 2010-07-07 12:54:12
Subject: Re: Tablespaces

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group