MySQL Forums
Forum List  »  Triggers

Re: Triggers now work (it's official)
Posted by: Roland Bouman
Date: July 29, 2005 05:38AM

Ok, i did not see it mentioned, but i scanned the list of change only briefly, so i probably missed it.

I think that views, procedures and triggers are all major leaps ahead. The information schema too is a major improvement but it still needs some crucial elements in my opinion: PARAMETERS for ROUTINES (already recognized as necessary), REFERENTIAL_CONSTRAINTS (also recognized) would be nice, but when you really need that data, you can work around it using just TABLE_CONSTRAINTS.
What i think really is indispensible, is some equivalent of oracle's DBA_DEPEDENCIES view. ISO 9075 also provides such functionality, dispersed over (sorry no ref at my fingers now, mybe wrong names) VIEW_TABLE_USAGE and PROCEDURE_COLUMNS and maybe some others.
Well i could go on and on about it, and I will, but not here ;-).


Options: ReplyQuote

Written By
Re: Triggers now work (it's official)
July 29, 2005 05:38AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.