Re: Materialized View patch broke pg_dump

Bernd Helmle <mailings(at)oopsware(dot)de> wrote:

> It looks like the recent matview patch broke pg_dump in a way, which make it
> impossible to dump 9.1 and 9.2 databases.
>
> it fails with
>
> pg_dump: [Archivierer (DB)] query failed: ERROR:  function
> pg_relation_is_scannable(oid) does not exist
>
> Looking into this issue, it seems the version check in getTables() of pg_dump.c
> is wrong. Shouldn't the check be
>
> if (fout->remoteVersion >= 90300)
> {
>
> }
>
> since this is where pg_relation_is_scannable() is introduced?

Right.  Will fix.

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company