Re: database design questions - Mailing list pgsql-general

From Alban Hertroys
Subject Re: database design questions
Date
Msg-id 44314A1B.8040701@magproductions.nl
Whole thread Raw
In response to database design questions  (Ottavio Campana <ottavio@campana.vi.it>)
Responses Re: database design questions  ("Alex Turner" <armtuk@gmail.com>)
Re: database design questions  (Ottavio Campana <ottavio@campana.vi.it>)
List pgsql-general
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).

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //

pgsql-general by date:

Previous
From: Patrick Refondini
Date:
Subject: RAISE function misuse ?
Next
From: "Alex Turner"
Date:
Subject: Re: database design questions