Re: BUG #1883: Renaming a schema leaves inconsistent sequence

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1883: Renaming a schema leaves inconsistent sequence
Дата
Msg-id 29758.1127450102@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #1883: Renaming a schema leaves inconsistent sequence  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
I wrote:
> If I recall the previous discussions correctly there were still some
> gotchas :-(

One point that comes to mind after more thought is that you'd really
like "create table ... default nextval('foo') ..." to understand that
there is a dependency from the column's default expression to sequence
foo.  Currently we hack this to sort-of-work for SERIAL columns, but
I'd like to have a cleaner mechanism.

Is it sane for a literal like 'foo'::regclass to, in itself, create a
dependency?  Not sure.

            regards, tom lane

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

Предыдущее
От: SriKumar Kareti
Дата:
Сообщение: Re: possible bug...
Следующее
От: "Trevor Tingey"
Дата:
Сообщение: BUG #1905: When a column with the chkpass datatype is used in a where clause it returns invalid results