Re: Information Schema and constraint names not unique

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: Information Schema and constraint names not unique
Дата
Msg-id
Pine.LNX.4.44.0311061732450.29650-100000@peter.localdomain
Ответ на
Список
Дерево обсуждения
Information Schema and constraint names not unique Philip Warner <pjw@rhyme.com.au>
Re: Information Schema and constraint names not unique Tom Lane <tgl@sss.pgh.pa.us>
Re: Information Schema and constraint names not unique Andrew Dunstan <andrew@dunslane.net>
Re: Information Schema and constraint names not unique Tom Lane <tgl@sss.pgh.pa.us>
Re: Information Schema and constraint names not unique Peter Eisentraut <peter_e@gmx.net>
Re: Information Schema and constraint names not unique Tom Lane <tgl@sss.pgh.pa.us>
Re: Information Schema and constraint names not unique Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Information Schema and constraint names not unique Tom Lane <tgl@sss.pgh.pa.us>
Re: Information Schema and constraint names not unique Bruce Momjian <pgman@candle.pha.pa.us>
Re: Information Schema and constraint names not unique Tom Lane <tgl@sss.pgh.pa.us>
Re: Information Schema and constraint names not unique Bruce Momjian <pgman@candle.pha.pa.us>
Re: Information Schema and constraint names not unique Andrew Dunstan <andrew@dunslane.net>
Re: Information Schema and constraint names not unique Tom Lane <tgl@sss.pgh.pa.us>
Re: Information Schema and constraint names not unique Andrew Dunstan <andrew@dunslane.net>
Re: Information Schema and constraint names not unique Barry Lind <blind@xythos.com>
Re: Information Schema and constraint names not unique Bruce Momjian <pgman@candle.pha.pa.us>
Re: Information Schema and constraint names not Philip Warner <pjw@rhyme.com.au>
Re: Information Schema and constraint names not unique Andrew Dunstan <andrew@dunslane.net>
Tom Lane writes:

> > Would a good halfway house be to ensure that generated names were unique
> > within a schema (e.g. instead of generating "$1" generate
> > "tablename$1")?
>
> No, because that buys into all of the serialization and deadlocking
> problems that doing it the spec's way entail

I don't think we really need a method to guarantee unique names.  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.

-- 
Peter Eisentraut   peter_e@gmx.net


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ