Re: jsonb and nested hstore

Bruce Momjian  writes:
> It seems only pg_type.oid is an issue for hstore.  We can easily modify
> pg_dump --binary-upgrade mode to suppress the creation of the hstore
> extension.  That should allow user hstore columns to automatically map
> to the new constant hstore oid.  We can also modify pg_upgrade to scan
> all the user tables for any use of hstore arrays and perhaps composite
> types and tell the user they have to drop and upgrade those table
> separately.

Yeah, and that doesn't seem terribly acceptable.  Unless you think the
field usage of hstore[] is nil; which maybe it is, I'm not sure what
the usage patterns are like.  In general it would not be acceptable
at all to not be able to support migrations of array columns.
		regards, tom lane