Re: adding column constraint

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