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
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
Nat
tricts organizations from
making
closed source modifications for internal use.
T.
--
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/
http://linuxtoday.com/
--
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/
Fatal error: Call to unsupported or undefined function mysql_errno
nding keys.)
Here's some output:
select levenshtein_distance('test', 'texts');
levenshtein_distance
2
(1 row)
Enjoy.
Tim
--
Timothy H. Keitt
National Center for Ecological Analysis and Synthesis
735 State Street, Suite 300, San
uld have index both for tenstop.route_id and
> history.route_id . From the index name, it not clear if you have
> or not. No matter what, add indeces!!!
>
> >From: "Timothy H. Keitt" <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: [GENERAL] quer
