Re: SET CONSTRAINTS not schema-aware

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: SET CONSTRAINTS not schema-aware
Дата
Msg-id Pine.LNX.4.44.0305121203280.6441-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: SET CONSTRAINTS not schema-aware  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SET CONSTRAINTS not schema-aware  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane writes:

> Yeah.  We had that discussion at some point during the 7.3 development
> cycle, and concluded we liked table-local naming for constraints better
> than the SQL spec's global constraint names.

Then why does pg_constraint store a schema OID?  The comments say it's for
SQL compatibility, so where else does it need to be compatible besides
this case?

-- 
Peter Eisentraut   peter_e@gmx.net



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

Предыдущее
От: Sailesh Krishnamurthy
Дата:
Сообщение: Re: compliling postgresql
Следующее
От: "geekmalda"
Дата:
Сообщение: unsubscribe-pattern-allmatching greenback frog