Re: database design questions - Mailing list pgsql-general

From Alex Turner
Subject Re: database design questions
Date
Msg-id 33c6269f0604030926n78edee2ck7f712c82faa80ab5@mail.gmail.com
Whole thread Raw
In response to Re: database design questions  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
create table person (
id serial8,
name text
);

Alex

On 4/3/06, Alban Hertroys <alban@magproductions.nl > 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).

--
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 //

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: database design questions
Next
From: Vivek Khera
Date:
Subject: Re: pg 8.1.2 performance issue