Re: [HACKERS] v10beta pg_catalog diagrams

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [HACKERS] v10beta pg_catalog diagrams
Дата
Msg-id CAFj8pRCHTBBsW+0xE6bvSyLW4wg5nG-S46Eg-XbMm9rOPUudcA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] v10beta pg_catalog diagrams  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: [HACKERS] v10beta pg_catalog diagrams  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Дерево обсуждения


2017-06-14 5:53 GMT+02:00 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>:
On 6/13/17 17:08, Andres Freund wrote:
> I wondered before if we shouldn't introduce "information only"
> unenforced foreign key constraints for the catalogs.  We kind of
> manually do that via oidjoins, it'd be nicer if we'd a function
> rechecking fkeys, and the fkeys were in the catalog...

I don't see why we couldn't just add a full complement of primary and
foreign key constraints (and unique constraints and perhaps some check
constraints).  The argument is that they wouldn't normally do anything,
but they would help with documentation and browsing tools, and they
wouldn't hurt anything.


These constraints can slowdown creating/dropping database objects - mainly temp tables.

Regards

Pavel
 
--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] pg_receivewal and messages printed in non-verbose mode
Следующее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [HACKERS] Dropping partitioned table drops a previously detached partition