Re: "ownership" of sequences, pseudo random unique id - Mailing list pgsql-general

From Tom Lane
Subject Re: "ownership" of sequences, pseudo random unique id
Date
Msg-id 2964.1250863012@sss.pgh.pa.us
Whole thread Raw
In response to Re: "ownership" of sequences, pseudo random unique id  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Number of columns exceed limit" on a hierarchy of views
Next
From: Merlin Moncure
Date:
Subject: Re: join from array or cursor