Are OIDs for pg_types constant? - Mailing list pgsql-hackers

From Tyler Brock
Subject Are OIDs for pg_types constant?
Date
Msg-id CACr_h8R8qKexQ8p4kJRQDDb+XhPG+WoB4TkMr8NjQOz=dWb84g@mail.gmail.com
Whole thread Raw
Responses Re: Are OIDs for pg_types constant?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi everyone,

I am writing a program that behaves like a Postgres backend and can see that if I select oid from pg_type that the type old’s could be returned in the Row Description message for the field’s data type and that seems to work.

However, I didn’t read anywhere that these are guaranteed to be constant/stable so I’d like to know if this is the case. For example: is the old for pg_type bool = 16 on every instance of Postgres?

Also does there exist any documentation decoding what the pg_type fields all mean?

Please let me know, thanks!

-Tyler

pgsql-hackers by date:

Previous
From: Gilles Darold
Date:
Subject: Re: [Proposal] vacuumdb --schema only
Next
From: Tom Lane
Date:
Subject: Re: Are OIDs for pg_types constant?