> -----Original Message----- > From: Claudio Valderrama C. [mailto:[email protected]] > Sent: Thursday, March 20, 2014 9:19 PM > To: 'For discussion among Firebird Developers' > Subject: Re: [Firebird-devel] RFC: stop fiddling with sys tables > > > -----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 So, I can find out which object (Trigger, Procedure, View and Table) has changed, great! How do I find out column/field has changed for ALTER TABLE ADD XXXX? (I didn't find anyway based on the link that Carlos cited) Sean ------------------------------------------------------------------------------ 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
