Re: Foreign keys

Hi,

On Mon, 22 Apr 2002, Jacob Vennervald Madsen wrote:

> CREATE TABLE "alarm_schedule" (
> "alarm_schedule_id" SERIAL NOT NULL,
> "day_of_week" int2 NOT NULL,
> "user_id" int4 NOT NULL,
> "send_email" bool NOT NULL,
> "send_sms" bool NOT NULL,
> PRIMARY KEY ("alarm_schedule_id"),
> FOREIGN KEY "user_id" REFERENCES smartlight_user ("user_id")
> );

This works:

CREATE TABLE "alarm_schedule" (
"alarm_schedule_id" SERIAL NOT NULL,
"day_of_week" int2 NOT NULL,
"user_id" int4 NOT NULL,
"send_email" bool NOT NULL,
"send_sms" bool NOT NULL,
PRIMARY KEY ("alarm_schedule_id"),
FOREIGN KEY ("user_id") REFERENCES smartlight_user(user_id)
);

Just a parenthesis ;)

Best regards.

--

Devrim GUNDUZ

devrim(at)oper(dot)metu(dot)edu(dot)tr
devrim(dot)gunduz(at)linux(dot)org(dot)tr
devrimg(at)tr(dot)net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------