Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | App - Visual Editing |
| Version | 13.0 |
Create or Replace Cluase in skelton code for Views, Procedures, Functions and Rules for Greenplum
1. We include Create or Replace in the Alter View, Procedure, Function or Rule
2. Shouldnt we include in the Create Visual Editing as well ?
|
|
24 KB
In visual editor, I think we only use 'CREATE or REPLACE' on altering an existing object but not on creating a new object; in the Create Dialog, DDL is always scripted as 'CREATE Object...'.
I checked Oracle, MySQL, nCluster and ParAccel servers, these servers all support 'CREATE or REPLACE' syntax and all of them follow the pattern described above. I guess we don't want to accidentally replaced an existing object on CREATE. Netezza and Vertica also support 'CREATE or REPLACE' syntax, you might want to double check.
Issue #8111 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
In visual editor, I think we only use 'CREATE or REPLACE' on altering an existing object but not on creating a new object; in the Create Dialog, DDL is always scripted as 'CREATE Object...'.
I checked Oracle, MySQL, nCluster and ParAccel servers, these servers all support 'CREATE or REPLACE' syntax and all of them follow the pattern described above. I guess we don't want to accidentally replaced an existing object on CREATE. Netezza and Vertica also support 'CREATE or REPLACE' syntax, you might want to double check.