To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=81652


User fs changed the following:

                What    |Old value                 |New value
================================================================================
        Target milestone|---                       |OOo 3.x
--------------------------------------------------------------------------------




------- Additional comments from [EMAIL PROTECTED] Mon Sep 17 12:38:35 +0000 
2007 -------
This is what Fred Toussi, maintainer of HSQLDB, suggested in private mail how
this could be implemented in HSQL:
I suggest the following strategy:

1. check the view is not referenced by any other view
2. create the view with a new name in the same schema (perhaps use a name 
that is illegal for users, e.g. a digit, so that there is no name conflict).
3. if the new view is created, then drop the old one and rename the new one 
to the old name
4. When you have developed the above, you can attempt a more ambitious 
strategy to deal with referenced views too, which means skipping (1), 
renaming the old view to another number in (3) The new view should be 
inserted in the view list just after the old one (the order of view creation 
is critical), then recompiling all views, and if it is successful, removing 
the old view (otherwise remove the new one and rename the old one to its 
original name.


---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to