#255 CREATE OR REPLACE feature

open
nobody
engine (144)
5
2010-11-15
2010-11-15
SadKo
No

Need to have CREATE OR REPLACE instruction support for:
- Functions
- Procedures
- Triggers
- Views
- ???

Now the latest checkout from trunk says only that token 'OR' is unexpected.

Discussion

  • Fred Toussi

    Fred Toussi - 2010-11-19

    This is syntax is not supported.

    The functionality is supported by:
    CREATE FUNCTION / PROCEDURE ...
    ALTER SPECIFIC ROUTINE ..

    CREATE VIEW ... AS
    ALTER VIEW ... AS

    CREATE TRIGGER ...
    -- but currently no ALTER TRIGGER. You can create a new trigger then drop the old one. If you have multiple trigger on the same table, you can specify BEFORE old_trigger_name, to put it in the right place / order.

     
  • SadKo

    SadKo - 2010-11-19

    Sure. But it's not a bug, it's a feature request. It would be good if such syntax could be supported.

     
  • Fred Toussi

    Fred Toussi - 2012-02-27

    In ORA syntax mode, this is now supported when the object does not already exist. This can help with some scripts and existing apps. We may extend it in the future.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks