Re: [ADMIN] Problems with enums after pg_upgrade

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