[HACKERS] different content of pg_depend after pg_upgrade

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема [HACKERS] different content of pg_depend after pg_upgrade
Дата
Msg-id CAFj8pRC8wc7uHawKyVTOxgSQQGZEAXbVO3-Bzb8DwLqtTL8M4g@mail.gmail.com
обсуждение исходный текст
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: chiru r
Дата:
Сообщение: [HACKERS] OpeSSL - PostgreSQL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Simplify ACL handling for large objects and removal of superuser() checks