Re: [ADMIN] Problems with enums after pg_upgrade - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: [ADMIN] Problems with enums after pg_upgrade
Date
Msg-id 50D0CFF7.5030606@dunslane.net
Whole thread Raw
In response to Re: [ADMIN] Problems with enums after pg_upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [ADMIN] Problems with enums after pg_upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 12/18/2012 02:58 PM, Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> He's upgrading from 9.0, which didn't have enum extension at all, and
>> where odd enums didn't mean anything special.
> Really?  The noncontiguous pg_enum OIDs shown in
> http://archives.postgresql.org/pgsql-hackers/2012-12/msg01089.php
> suggest strongly that *something's* been done to that type since
> it was created.


That's what he said.

People have been known to hack pg_enum on their own, especially before 
we added enum extension.

Of course, if they do that they get to keep both pieces.

cheers

andrew




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] Problems with enums after pg_upgrade
Next
From: Robert Haas
Date:
Subject: Re: logical decoding - GetOldestXmin