This content has been marked as final. Show 4 replies
This behaviour is still present in the latest version, 3.2.10
On the Edit View dialog, click on the DDL tree page.
Set the SQL Statement radio control to 'CREATE'
It will use CREATE OR REPLACE at this point, as you desire.
This behavior is still present in version 3.2.20.
Selecting the DDL tree page and setting the SQL Statement radio control to "Create" does change the code in the SQL statement to "CREATE OR REPLACE VIEW", but selecting OK on the Edit View dialog DOES NOT run this code. It still drops the table and recreates it - which causes all privileges to be lost.
The default for editing a view should be to "CREATE OR REPLACE VIEW".
Please consider fixing the Edit View dialog to:
- Default to the "CREATE OR REPLACE VIEW" logic
- When DDL tree page is selected, the code that is displayed in the SQL Statement should be executed when the "OK" button is selected.
I agree with the original posting that using the "Edit..." action from the popup menu on a view is dangerous. It has bitten us quite a few times.
This is a bug and it's been logged. If you want an update, refer to BudID: 15851553