Re: database design questions

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: Ottavio Campana <ottavio(at)campana(dot)vi(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: database design questions
Date: 2006-04-03 16:15:23
Message-ID: 44314A1B.8040701@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)magproductions(dot)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 //

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Turner 2006-04-03 16:26:35 Re: database design questions
Previous Message Patrick Refondini 2006-04-03 15:44:18 RAISE function misuse ?