On 09/30/2017 03:32 PM, Tom Lane wrote:
> Andrew Dunstan 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
Andrew Dunstan 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 th
On 09/30/2017 01:41 PM, Tom Lane wrote:
> Support arrays over domains.
We seem to have caused a problem with pg_upgrade :-(
The failing log file is:
command: "/home/bf/bfr/root/upgrade/HEAD/inst/bin/pg_restore" --host
/home/bf/bfr/root/upgrade/HEAD/inst --port 5648 --username buildfar
Support arrays over domains.
Allowing arrays with a domain type as their element type was left un-done
in the original domain patch, but not for any very good reason. This
omission leads to such surprising results as array_agg() not working on
a domain column, because the parser can't identify a
