Is there any different for foreign key to be serial instead of integer - Mailing list pgsql-general

From Yan Cheng Cheok
Subject Is there any different for foreign key to be serial instead of integer
Date
Msg-id 889238.85056.qm@web65703.mail.ac4.yahoo.com
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: How psql source code can be protected?
Next
From: Scott Marlowe
Date:
Subject: Re: Is there any different for foreign key to be serial instead of integer