Re: pg_type oid's do they change from version to version

Dave Cramer wrote:
> How much can we count on the type oid's remaining static from version to
> version? It turns out there is a design decision in the jdbc driver that
> could fail if they changed from one version to another and the client
> connected to both versions.

I don't think we have ever changed oids for existing data types, so you
should be OK.

> Also for getUDT, we need to translate type oid's into java type values,
> so if we can rely on the oids not changing then it would make it easier.

Right.  There has never been a reason to change them, and there is a
downside if we were to change them.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073