Materialized View patch broke pg_dump - Mailing list pgsql-hackers

From Bernd Helmle
Subject Materialized View patch broke pg_dump
Date
Msg-id B53DFB696FE48AE98BFAAE3B@apophis.credativ.lan
Whole thread Raw
Responses Re: Materialized View patch broke pg_dump  (Kevin Grittner <kgrittn@ymail.com>)
Re: Materialized View patch broke pg_dump  (Kevin Grittner <kgrittn@ymail.com>)
List 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



pgsql-hackers by date:

Previous
From: Shigeru Hanada
Date:
Subject: Re: Writable foreign tables: how to identify rows
Next
From: Amit Kapila
Date:
Subject: Re: Performance Improvement by reducing WAL for Update Operation