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

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pg(at)fastcrypt(dot)com, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_type oid's do they change from version to version
Date: 2004-05-20 01:29:52
Message-ID: 40AC0A10.8020102@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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_ reused those oids...

I think the core should mandate it as policy never to reuse oids and
perhaps make the unused_oids script "remember" what has been used...

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2004-05-20 01:32:28 Re: Table Spaces
Previous Message Christopher Kings-Lynne 2004-05-20 01:26:34 Re: Table Spaces