Subject | Re: [ib-support] EXTERNAL tables for logging |
---|---|
Author | Anderson Farias |
Post date | 2003-03-05T14:19:29Z |
Hi,
don't really need blob or array suport and so on...
really concern with -- toggether with "search" capabilities for some kind of
"audit" tool. :)
Regards,
Anderson
> External tables do have some restrictions you should be aware of:well, for my logging system thats all I need (select and insert). And, I
>
> - Only INSERT and SELECT is supported
> - No BLOB and array support
> - DML operations are outside transaction control
> ...
don't really need blob or array suport and so on...
> You'd better keep the logs inside the database and pump themThanks for the idea -- backup and maintenance is some of the issues I'm
> regularly to another database by using the two-phase-commit
> protocol.
really concern with -- toggether with "search" capabilities for some kind of
"audit" tool. :)
Regards,
Anderson