insufficient qualification of some objects in dump files

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: insufficient qualification of some objects in dump files
Date: 2016-01-28 16:17:27
Message-ID: 56AA3F17.4060301@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Some dump objects whose names are not unique on a schema level have
insufficient details in the dump TOC. For example, a column default
might have a TOC entry like this:

2153; 2604 39696 DEFAULT public a rolename

Note that this only contains the schema name and the column name, but
not the table name. So this makes it impossible to filter the TOC by
text search in situations like this.

It looks like other object types such as triggers have the same problem.

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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-01-28 16:17:42 Re: Additional role attributes && superuser review
Previous Message Anastasia Lubennikova 2016-01-28 16:12:54 Re: [WIP] Effective storage of duplicates in B-tree index.