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

From Tom Lane
Subject Re: [ADMIN] Problems with enums after pg_upgrade
Date
Msg-id 18042.1355937183@sss.pgh.pa.us
Whole thread Raw
In response to Re: [ADMIN] Problems with enums after pg_upgrade  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> what is even worse is that this procedure doesn't take any care at all 
> of the ordering rule for even numbered enum oids.

Good point.  You really should use ALTER TYPE ADD VALUE, on versions
where that's available.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Set visibility map bit after HOT prune
Next
From: Robert Haas
Date:
Subject: Re: Review of Row Level Security