Re: database design questions - Mailing list pgsql-general

From Ottavio Campana
Subject Re: database design questions
Date
Msg-id 44323512.4000207@campana.vi.it
Whole thread Raw
In response to Re: database design questions  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
Alban Hertroys wrote:
> Ottavio Campana wrote:
>
>>>   CREATE TABLE person (
>>>       id   SERIAL,
>>>       name TEXT
>>>   );
>
>
>> how can I do it with a INT8 instead of a INT4?
>
>
> Do you really expect that sequence to reach over 2 billion? Otherwise
> I'd stick with the SERIAL, nothing wrong with that unless you're selling
> electrons seperately or something like that (hmm... how much are they? I
> sure could use a few extra).

I agree wih you, but I think that in the feature the could be more than
2 billions. I don't want to alter in the future the database

--
Non c'è più forza nella normalità, c'è solo monotonia.


Attachment

pgsql-general by date:

Previous
From: "patrick"
Date:
Subject: recover from base directory?
Next
From: venu gopal
Date:
Subject: How can i import .backup file into the database