Re: pg_upgrade patches applied

Bruce Momjian <bruce@momjian.us> writes:
> Tom Lane wrote:
>> That isn't going to work.  At least not unless you start trying to force
>> roles to have the same OIDs in the new installation.

> If so I can use the CREATE ROLE ... SYSID clause when doing a binary
> upgrade.

Oh, I had forgotten we still had that wart in the grammar.
It doesn't actually work:
    else if (strcmp(defel->defname, "sysid") == 0)    {        ereport(NOTICE,                (errmsg("SYSID can no
longerbe specified")));    }
 

Not sure if it's better to try to make that work again than to add
another hack in pg_upgrade_support.  On the whole that's a keyword
I'd rather see us drop someday soon.
        regards, tom lane