Re: Materialized View patch broke pg_dump - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Materialized View patch broke pg_dump
Date
Msg-id 1362581833.88172.YahooMailNeo@web162903.mail.bf1.yahoo.com
Whole thread Raw
In response to Materialized View patch broke pg_dump  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
Bernd Helmle <mailings@oopsware.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



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Materialized views WIP patch
Next
From: Merlin Moncure
Date:
Subject: Re: Optimizing pglz compressor