Re: pg_constraint
От | Christopher Kings-Lynne |
---|---|
Тема | Re: pg_constraint |
Дата | |
Msg-id | GNELIHDDFBOCMGBFGEFOIEEKCCAA.chriskl@familyhealth.com.au обсуждение исходный текст |
Ответ на | pg_constraint ("Rod Taylor" <rbt@zort.ca>) |
Ответы |
Re: pg_constraint
|
Список | pgsql-hackers |
> For tracking of Foreign Keys, Check constraints, and maybe NULL / NOT > NULL (specific type of check constraint) I intend to create (as per > suggestion) pg_constraint. Hmmm...I don't see the need at all for NOT NULL constraint tracking. The spec doesn't seem to require it and we do not have names for them anyway. Even if they were given names, it'd be pointless, as there's only one per column. Primary keys and unique keys are SQL constraints - are you going to bother tracking them as well or leave them in the current format? Maybe you could do it with a view or something. Why not just create a pg_references table and leave pg_relcheck as is? Chris
В списке pgsql-hackers по дате отправления: