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@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

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