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/
>
