diff's between creations of tables

Поиск
Список
Период
Сортировка
От G.L. Grobe
Тема diff's between creations of tables
Дата
Msg-id 000b01c11595$70c05d90$0200a8c0@trinity
обсуждение исходный текст
Ответы Re: diff's between creations of tables  ("Dr. Evil" <drevil@sidereal.kz>)
Re: diff's between creations of tables  (Joel Burton <jburton@scw.org>)
Список pgsql-general
When creating an incremental and unique id, what are the benefits of using:

CREATE TABLE tablename (colname SERIAL);

instead of :

CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename
    (colname integer DEFAULT nextval('tablename_colname_seq');
CREATE UNIQUE INDEX tablename_colname_key on tablename (colname);

One is easier do delete as a dropdb dbname would do it, but anything else I
should know. Or which one is the general practice, any rules of thumb to
use, etc...



В списке pgsql-general по дате отправления:

Предыдущее
От: "Dr. Evil"
Дата:
Сообщение: Good random numbers in PG? And crypto-wishlist
Следующее
От: "Dr. Evil"
Дата:
Сообщение: Re: diff's between creations of tables