Re: "ownership" of sequences, pseudo random unique id

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "ownership" of sequences, pseudo random unique id
Дата
Msg-id 2964.1250863012@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "ownership" of sequences, pseudo random unique id  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> I was mainly concerned about assigning ownership of a sequence to a
> column that is not an int.

I think you can get away with that.  It's already the case within the
standard usage that the owning column could be either int or bigint.

FWIW, I agree with the idea of adding a default expression so that it
behaves even more like a regular serial column.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "Number of columns exceed limit" on a hierarchy of views
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: join from array or cursor