Re: [SQL] Uniqueness of rule, constraint, and trigger names

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: [SQL] Uniqueness of rule, constraint, and trigger names
Дата
Msg-id 20020304145040.R81357-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Re: [SQL] Uniqueness of rule, constraint, and trigger names  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, 4 Mar 2002, Tom Lane wrote:

> Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> > On Mon, 4 Mar 2002, Tom Lane wrote:
> >> For constraints, we'd need to change the code to be more careful to
> >> generate unique names for unnamed constraints.  That doesn't seem
>
> > Another question would be what to do with inherited constraints that
> > conflict in multiple inheritance cases.  It'd probably be safe to rename
> > those on the child table to be unique,
>
> I'd just raise an error, I think, unless perhaps the constraints are
> identical (for some definition of identical).  We don't allow
> conflicting column definitions to be inherited, so why constraints?

Good point.  That's probably better than autorenaming them.




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Uniqueness of rule, constraint, and trigger names
Следующее
От: Tom Lane
Дата:
Сообщение: Planned cleanups in attribute parsing