different content of pg_depend after pg_upgrade

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: different content of pg_depend after pg_upgrade
Date: 2017-11-09 22:02:13
Message-ID: CAFj8pRC8wc7uHawKyVTOxgSQQGZEAXbVO3-Bzb8DwLqtTL8M4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

We checked some check query based on some operations on pg_depend table.
This query did different result when database was migrated with pg_dump or
with pg_upgrade. I found so this query was broken, but I found interesting
thing.

The count is 1 for any objid

select distinct count(distinct classid), objid from pg_depend group by
objid;

when system was loaded from dump

but when we used pg_upgrade, then previous rule was invalid.

Is it expected behave?

Regards

Pavel

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-11-09 22:05:05 Re: Simplify ACL handling for large objects and removal of superuser() checks
Previous Message chiru r 2017-11-09 21:59:10 OpeSSL - PostgreSQL