Re: pgsql: Support arrays over domains.

Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com> writes:
> We seem to have caused a problem with pg_upgrade :-(

> pg_restore: [archiver (db)] could not execute query: ERROR:  pg_type
> array OID value not set when in binary upgrade mode

> Here we're upgrading from 9.2 to HEAD. Of course, there isn't an array
> oid for the domain in 9.2.

Hmm. That's pretty annoying. We could certainly go ahead and assign
some unused type OID to the new array type, but the receiving backend
can't really do that, since it doesn't know which type OIDs will be
assigned later in the dump file.

Maybe we could put the burden on pg_upgrade (pg_dump --binary-upgrade)
to select an OID that's not in use in the source database.

regards, tom lane