Is there any different for foreign key to be serial instead of integer

Поиск
Список
Период
Сортировка
От Yan Cheng Cheok
Тема Is there any different for foreign key to be serial instead of integer
Дата
Msg-id 889238.85056.qm@web65703.mail.ac4.yahoo.com
обсуждение исходный текст
Ответы Re: Is there any different for foreign key to be serial instead of integer  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Is there any different for foreign key to be serial instead of integer  (Richard Broersma <richard.broersma@gmail.com>)
Список pgsql-general
I came across a lot of similar example for foreign key

CREATE TABLE orderinfo
(
orderinfo_id serial ,
customer_id integer NOT NULL,
date_placed date NOT NULL,
date_shipped date ,
shipping numeric(7,2) ,
CONSTRAINT orderinfo_pk PRIMARY KEY(orderinfo_id),
CONSTRAINT orderinfo_customer_id_fk FOREIGN KEY(customer_id) REFERENCES
customer(customer_id)
);

instead of let customer_id being type as integer, can i let it be serial? is there any difference?

if the table referenced by customer_id is having primary key typed big serial, customer_id shall be declared as bigint
?

Thanks





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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: How psql source code can be protected?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Is there any different for foreign key to be serial instead of integer