Re: Information Schema and constraint names not

Поиск
Список
Период
Сортировка
От Philip Warner
Тема Re: Information Schema and constraint names not
Дата
Msg-id 6.0.0.22.0.20031107105014.04689af8@203.8.195.10
обсуждение исходный текст
Ответ на Re: Information Schema and constraint names not unique  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Information Schema and constraint names not
Re: Information Schema and constraint names not
Список pgsql-hackers
At 03:37 AM 7/11/2003, Peter Eisentraut wrote:
>It would
>already help a lot if we just added the table name, or something that was
>until a short time before the action believed to be the table name, or
>even only the table OID, before (or after) the $1.

Can we allow/bypass the pg_* restriction, and call it pg_<table-oid>_<n>, 
and for pedants like me, add a DB setting that says 'enforce unique 
constraints' ala the spec to avoid manually created constraints being 
non-unique?

Alternatively, I would be happy *not* to enforce constraint name uniqueness 
(and break the spec) so long as we also break the spec and add table OID 
(or something else) to the information schema (table name would be OK so 
long as renaming the table won't break anything).







----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 03 5330 3172          |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/ 



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: stats collector causes shared-memory-block leakage
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Information Schema and constraint names not