Are these two creation commands functionally identical?

Поиск
Список
Период
Сортировка
От dterrors@hotmail.com
Тема Are these two creation commands functionally identical?
Дата
Msg-id 1186692906.701407.154540@z24g2000prh.googlegroups.com
обсуждение исходный текст
Ответы Re: Are these two creation commands functionally identical?
Список pgsql-general
I want to to know if these two are functionally equivalent.  Is this:

Create table "users"
(
    "userid" BigSerial NOT NULL,
    "name" Varchar(20),
 primary key ("userid")
) Without Oids;
Create table "sales"
(
    "saleid" BigSerial NOT NULL,
    "userid" Bigint NOT NULL,
    "parent_saleid" Bigint NOT NULL,
 primary key ("saleid")
) Without Oids;
Alter table "sales" add  foreign key ("userid") references
"users" ("userid") on update restrict on delete restrict;
Alter table "sales" add  foreign key ("parent_saleid") references
"sales" ("saleid") on update restrict on delete restrict;

Is the above functionally identical to:

Create table "users"
(
    "userid" BigSerial NOT NULL,
    "name" Varchar(20),
 primary key ("userid")
) Without Oids;
Create table "sales"
(
    "saleid" BigSerial NOT NULL,
    "userid" bigint references users(userid),
    "parent_saleid" bigint references sales(saleid),
 primary key ("saleid")
) Without Oids;

Using postgreSQL 8.1 if it matters, thanks.


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

Предыдущее
От: Johan Runnedahl
Дата:
Сообщение: Installing Postgresql 8.2 on Windows Vista
Следующее
От: Adam Endicott
Дата:
Сообщение: Confusing performance of specific query