Re: insufficient qualification of some objects in dump files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: insufficient qualification of some objects in dump files
Date: 2016-01-29 06:51:04
Message-ID: 2310.1454050264@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Paquier <michael(dot)paquier(at)gmail(dot)com> writes:
> On Fri, Jan 29, 2016 at 1:17 AM, Peter Eisentraut <peter_e(at)gmx(dot)net> 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

> +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.

How can we do this without an archive format version bump ... or were
you assuming that that would be an acceptable price? (It's not like
we haven't done those before, so maybe it is.)

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2016-01-29 06:56:50 Re: extend pgbench expressions with functions
Previous Message Fabien COELHO 2016-01-29 06:40:50 Re: extend pgbench expressions with functions