Re: Odd pg dump error: cache lookup failure - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Odd pg dump error: cache lookup failure
Date
Msg-id 20201021200659.GA32358@alvherre.pgsql
Whole thread Raw
In response to Re: Odd pg dump error: cache lookup failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Odd pg dump error: cache lookup failure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On 2020-Aug-25, Tom Lane wrote:

> Oh wait a second.  Matviews can have indexes, and getTables doesn't
> lock them (because we don't allow LOCK TABLE on views).

Here's a quick patchset that makes pg_dump do LOCK TABLE on all
relations it dumps; patch 0001 allows server-side LOCK TABLE to run on
any relkind, and then 0002 makes pg_dump test for that capability at
connection start, and if it exists, then it's used for all relations to
dump.

Attachment

pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Regarding query on the postgresql upgrade
Next
From: Tom Lane
Date:
Subject: Re: Odd pg dump error: cache lookup failure