[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 по дате отправления: