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

Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: >> I don't think we have ever changed oids for existing data types, so you >> should be OK. > Are you sure? If we remove a type, then its oid becomes up for grabs by > the unused_oids script. But if we remove a type then it's a bit moot whethe

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

Christopher Kings-Lynne wrote: > > True, but have we ever removed types? I can't think of one. > > Hmmm...perhaps. > > >>We have removed a few functions in 7.4 (oidsrand, etc.) and I wouldn't > >>be surprised if we haven't _already_ reused those oids... > > > > Yes, for functions that is very

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

Christopher Kings-Lynne wrote: > > I don't think we have ever changed oids for existing data types, so you > > should be OK. > > Are you sure? If we remove a type, then its oid becomes up for grabs by > the unused_oids script. True, but have we ever removed types? I can't think of one. > We h

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

True, but have we ever removed types? I can't think of one. Hmmm...perhaps. We have removed a few functions in 7.4 (oidsrand, etc.) and I wouldn't be surprised if we haven't _already_ reused those oids... Yes, for functions that is very true. I wonder if that has any implications for future binar

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

I don't think we have ever changed oids for existing data types, so you should be OK. Are you sure? If we remove a type, then its oid becomes up for grabs by the unused_oids script. We have removed a few functions in 7.4 (oidsrand, etc.) and I wouldn't be surprised if we haven't _already_ reuse

Re: [HACKERS] 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

[HACKERS] pg_type oid's do they change from version to version

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. Also for getUDT, we need to translate type oid's into