Subject AW: [firebird-support] Re: System tables affected by DML operations over regular tables
Author Steffen Heil
Hi

You might be able to write a triggers for the system tables that manage the
data tables layout.
Upon field creation, that trigger might execute code to add logging triggers
to the new table or update logging triggers to existing tables..

But that would be hard to code and I am not sure, how such triggers would
effect efficiency and locking on the respective system tables.
I am also unsure, if you can add triggers to system tables at all, but I
suspect so.

Regards,
Steffen


-----Urspr√ľngliche Nachricht-----
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Im Auftrag von sosingus
Gesendet: Samstag, 7. November 2009 14:06
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Re: System tables affected by DML operations
over regular tables



--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...> wrote:
>
> > I would like to be able to make an general procedure that would log
every (or only configured) DML operations over all or over configured tables
in my database. Beside the operations, I would like to log the data of
affected table after DML operation, except for delete.
>
> No way. But you can use IBLogManager.
>
> SY, SD.
>

Thanks for the answers, I guess I'll have to think of something else, as I
would like to have it as an application functionality that can be turned on
and off at anytime.



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links




[Non-text portions of this message have been removed]