Re: database design questions

create table person (
id serial8,
name text
);

Alex

On 4/3/06, Alban Hertroys <alban(at)magproductions(dot)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(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 //
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>