Re: insufficient qualification of some objects in dump files - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: insufficient qualification of some objects in dump files
Date
Msg-id 56CFA0B6.2050704@gmx.net
Whole thread Raw
In response to Re: insufficient qualification of some objects in dump files  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: insufficient qualification of some objects in dump files
List pgsql-hackers
On 1/29/16 1:24 AM, Michael Paquier wrote:
>> I think we should amend the archive tag for these kinds of objects to
>> > include the table name, so it might look like:
>> >
>> > 2153; 2604 39696 DEFAULT public test a rolename
>> >
>> > Comments?
> +1. I noticed that this limitation is present for triggers (as you
> mentioned), constraints, fk constraints and RLS policies which should
> be completed with a table name.

Thank you for collecting this list.  Attached is a patch for this.

Tom thought this might require an archive version dump, but I'm not
sure.  The tags are more of an informational string for human
consumption, not strictly part of the archive format.


Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Writing new unit tests with PostgresNode
Next
From: Tomas Vondra
Date:
Subject: Re: improving GROUP BY estimation