> -----Original Message-----
> From: Leyne, Sean [mailto:[email protected]]
> Sent: Jueves, 20 de Marzo de 2014 18:46
>
> > That's what DDL triggers are for. They can write change
> > log to a user table,
> > no need to touch system ones.
>
> OK, but since DDL Triggers don't yet exist -- what should be
> supported in the meantime?
DDL triggers exist in FB3 and have been mentioned several times in this
list:
trigger_db_type
: CONNECT
| DISCONNECT
| TRANSACTION START
| TRANSACTION COMMIT
| TRANSACTION ROLLBACK
trigger_ddl_type
: trigger_ddl_type_items
| ANY DDL STATEMENT
trigger_ddl_type_items
: CREATE TABLE
| ALTER TABLE
| DROP TABLE
| CREATE PROCEDURE
| ALTER PROCEDURE
| DROP PROCEDURE
| CREATE FUNCTION
| ALTER FUNCTION
| DROP FUNCTION
| CREATE TRIGGER
| ALTER TRIGGER
| DROP TRIGGER
| CREATE EXCEPTION
| ALTER EXCEPTION
| DROP EXCEPTION
| CREATE VIEW
| ALTER VIEW
| DROP VIEW
| CREATE KW_DOMAIN
| ALTER KW_DOMAIN
| DROP KW_DOMAIN
| CREATE ROLE
| ALTER ROLE
| DROP ROLE
| CREATE SEQUENCE
| ALTER SEQUENCE
| DROP SEQUENCE
| CREATE USER
| ALTER USER
| DROP USER
| CREATE INDEX
| ALTER INDEX
| DROP INDEX
| CREATE COLLATION
| DROP COLLATION
| ALTER CHARACTER SET
| CREATE PACKAGE
| ALTER PACKAGE
| DROP PACKAGE
| CREATE PACKAGE BODY
| DROP PACKAGE BODY
| trigger_ddl_type OR
trigger_ddl_type
What is the specific thing that doesn't exist according to you?
C.
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
