Re: database design questions

Поиск
Список
Период
Сортировка
От Alex Turner
Тема Re: database design questions
Дата
Msg-id 33c6269f0604030926n78edee2ck7f712c82faa80ab5@mail.gmail.com
обсуждение исходный текст
Ответ на Re: database design questions  (Alban Hertroys <alban@magproductions.nl>)
Список 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 по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: database design questions
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: pg 8.1.2 performance issue