pgAdmin 4 commit: Add classid filter to queries on pg_depend. Fixes #17 - Mailing list pgadmin-hackers

From Dave Page
Subject pgAdmin 4 commit: Add classid filter to queries on pg_depend. Fixes #17
Date
Msg-id E1bkqKH-0004kP-EO@gothos.postgresql.org
Whole thread Raw
Responses Re: pgAdmin 4 commit: Add classid filter to queries on pg_depend. Fixes #17  (Magnus Hagander <magnus@hagander.net>)
List pgadmin-hackers
Add classid filter to queries on pg_depend. Fixes #1705

There are a number of cases where queries in both pgadmin4 and pgadmin3 are done against pg_depend but falis to
constrainthe query on classid. 

In particular, if for example a constraint and a sequence exists with the same oid (which is perfectly valid, as they
arein different tables), a column will suddenly refer sequences that are completely incorrect. When we look up
sequences,we have to make sure we only match dependencies against pg_class. 

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=ce20dbc25a393004c5249d946f9a85a691cacd48
Author: Magnus Hagander <magnus@hagander.net>

Modified Files
--------------
.../columns/templates/catalog_object_column/sql/9.1_plus/properties.sql | 2 +-
.../schemas/tables/templates/column/sql/9.1_plus/is_referenced.sql      | 1 +
.../databases/schemas/tables/templates/column/sql/9.1_plus/nodes.sql    | 2 +-
.../schemas/tables/templates/column/sql/9.1_plus/properties.sql         | 2 +-
.../schemas/tables/templates/column/sql/9.2_plus/is_referenced.sql      | 1 +
.../databases/schemas/tables/templates/column/sql/9.2_plus/nodes.sql    | 2 +-
.../schemas/tables/templates/column/sql/9.2_plus/properties.sql         | 2 +-
7 files changed, 7 insertions(+), 5 deletions(-)


pgadmin-hackers by date:

Previous
From: Surinder Kumar
Date:
Subject: [pgAdmin4][Patch]: RM1595 - "no results to fetch error" displayed if modify definition with other table
Next
From: Dave Page
Date:
Subject: Re: Sequence queries on pg_depend lacking classid filter