Bruce Stewart writes: > Hi Monty and all, > > I believe that you are planning to introduce foreign key support in a future > version of MySQL (I think version 4.0). > > Could you consider offering an option to the definition of a foreign key > which specifies the error message to return if the FK is violated. > something like: > > "ALTER TABLE mytable ADD CONSTRAINT mytable_FK FOREIGN KEY (myfield) > REFERENCES myothertable (myotherfield) MSG 'A friendly totally customizable > message'" > > > Thanks, > Bruce Foreign keys will not be introduced in 4.0. May be in 4.1 ... 4.0 will have cascading deletes and updates , which provides some of the functionality of foreign keys. 4.0 will also save FK info, for use in documentation and in programs that can optimize join queries, like mysqlgui .... -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php