Materialized View patch broke pg_dump

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Materialized View patch broke pg_dump
Date: 2013-03-06 11:00:33
Message-ID: B53DFB696FE48AE98BFAAE3B@apophis.credativ.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

--
Thanks

Bernd

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2013-03-06 11:10:35 Re: Performance Improvement by reducing WAL for Update Operation
Previous Message Shigeru Hanada 2013-03-06 10:42:23 Re: Writable foreign tables: how to identify rows