Re: [?big5?] - Mailing list pgsql-general

=?big5?B?bmd0ZXJyeQ==?= wrote:
>
> I am sorry what I am trying is:
>
> >CREATE TABLE purchase (id int, po int, date date, PRIMARY KEY (id));
> >
> >CREATE TABLE lcopen (lc numeric, po int, PRIMARY KEY (lc));
>
> replace with:
> CREATE TABLE lcopen (lc numeric, po int REFERENCES purchase (po), PRIMARY KEY (lc));
> but there is an error and I do not how to correct that.

    You  should get an error saying that "po" is missing a UNIQUE
    constraint.  So go ahead and make it unique.


Jan

>
> >
> >CREATE TABLE lcreceive (
> >   id int,
> >   lc numeric REFERENCES lcopen(lc),
> >   purid int REFERENCES purchase(id)
> >)
> >;
> >
> >I think this is what you are asking this will effectively make lc and
> >purid in lcreceive foreign keys of the other tables
> >
> >Darren Ferguson
> >
> >On Sun, 10 Mar 2002, [big5] ngterry wrote:
> >
> >>
> >> Hi!
> >>
> >> I am just a newbie in postgresql.  What if:
> >>
> >> CREATE TABLE purchase (id int, po int, date date, PRIMARY KEY (id));
> >>
> >> CREATE TABLE lcopen (lc numeric, po int, PRIMARY KEY (lc));
> >>
> >> CREATE TABLE lcreceive (id int, lc numeric REFERENCES lcopen, purid int REFERENCES purchase);
> >>
> >> How do I refer the keywords po in table lcopen to table purchase the po keywords?  I am quite confuse, since I
haveannounce id in table purchase as PRIMARY KEY.  I do not know how to key another keywords. 
> >>
> >> Best regards,
> >>
> >> Terence
> >> ==================================================================
> >> ·s®öSMSµu°T¡Ghttp://sms.sina.com.hk
> >> µ¹»·¤è¿Ë¤Í¶Ç¤WµL­­Åå³ß
> >> 50MB ¹q¤l¶l¥ó ¡Ghttp://sinamail.sina.com.hk
> >>
> >>
> >>
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 4: Don't 'kill -9' the postmaster
> >>
> >
> >
> ==================================================================
> ·s®öSMSµu°T¡Ghttp://sms.sina.com.hk
> µ¹»·¤è¿Ë¤Í¶Ç¤WµL­­Åå³ß
> 50MB ¹q¤l¶l¥ó ¡Ghttp://sinamail.sina.com.hk
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com