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

From: Yan Cheng Cheok <yccheok(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is there any different for foreign key to be serial instead of integer
Date: 2010-01-07 03:51:28
Message-ID: 889238.85056.qm@web65703.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-01-07 04:07:45 Re: Is there any different for foreign key to be serial instead of integer
Previous Message hx.li 2010-01-07 03:44:11 Re: FULL JOIN is only supported with merge-joinable join conditions