From: | mikeo <mikeo(at)spectrumtelecorp(dot)com> |
---|---|
To: | "Timothy H(dot) Keitt" <keitt(at)nceas(dot)ucsb(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: adding column constraint |
Date: | 2000-07-26 21:46:52 |
Message-ID: | 3.0.1.32.20000726174652.009668e0@pop.spectrumtelecorp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
almost,
ALTER TABLE
cust # the table to be altered yes
ADD CONSTRAINT
fk_cust_bd_id # name of the constraint (see
tgconstrname column in pg_trigger)
FOREIGN KEY
(bd_id) # column in cust to be FK'd to bill_dist
REFERENCES
bill_dist (bd_id); # specifies the column in bill_dist to use? yes
mikeo
At 02:26 PM 7/26/00 -0700, Timothy H. Keitt wrote:
>Hmmm... I got it to work, but using a slightly different syntax. Let me
>see if I understand your example:
>
>ALTER TABLE
> cust # the table to be altered
>ADD CONSTRAINT
> fk_cust_bd_id # the column in cust to add the constraint?
>FOREIGN KEY
> (bd_id) # foreign key in bill_dist?
>REFERENCES
> bill_dist (bd_id); # specifies the column in bill_dist to use?
>
>Oddly, I put the foreign table name in place of fk_cust_bd_id and the
>local column name where you have (bd_id). It seemed to work. Is the
>identifier after ADD CONSTRAINT a noop?
>
>BTW, the problem with the example in the man page is that its impossible
>to tell which identifiers are table names and which are column names and
>which column names go with which table, etc. The format above (with
>comments) would help a lot. (Or use identifiers like
>the_table_to_be_altered and so on.)
>
>Tim
>
>mikeo wrote:
>>
>> alter table cust add constraint fk_cust_bd_id foreign key (bd_id)
>> references bill_dist (bd_id);
>>
>> At 12:57 PM 7/26/00 -0700, Timothy H. Keitt wrote:
>> >Can someone give an example of how to add a foreign key constraint to an
>> >existing table? (Pgsql and the man page differ and neither syntax seems
>> >to work.)
>> >
>> >I've tried:
>> >
>> >alter table mytable add constraint col foreign key references reftable
>> >
>> >with no luck.
>> >
>> >Tim
>> >
>> >--
>> >Timothy H. Keitt
>> >National Center for Ecological Analysis and Synthesis
>> >735 State Street, Suite 300, Santa Barbara, CA 93101
>> >Phone: 805-892-2519, FAX: 805-892-2510
>> >http://www.nceas.ucsb.edu/~keitt/
>> >
>
>--
>Timothy H. Keitt
>National Center for Ecological Analysis and Synthesis
>735 State Street, Suite 300, Santa Barbara, CA 93101
>Phone: 805-892-2519, FAX: 805-892-2510
>http://www.nceas.ucsb.edu/~keitt/
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-07-26 21:50:43 | Re: Some questions on user defined types and functions. |
Previous Message | Tom Lane | 2000-07-26 21:42:09 | Re: performance help |