Subject Re: [ib-support] keeping current "standby" data
Author Helen Borrie
At 01:09 PM 01-08-02 +0200, _/\/ando wrote:
> > Shadowing can occur only to a local disk. Shadowing to a NFS
> > filesystem or mapped drive is not supported.
> >
> > Is this information correct?
>It is, shadowing is a local mechanism.

Confirmed by RTFM...making it even less useful than I already thought it was.

>And, while we're at it, it is
>technically possible to have a UDF connect to a *different* db to
>execute replica SQL statements.

"technically possible" only insofar as the database engine won't prevent
you from implementing a UDF that can do *anything*, including completely
trash your database. It's an exposure that makes your server vulnerable to
malicious interference, by the way. (Even on a good day, an authorised UDF
can blow up the server and corrupt data if it hasn't been well-tested and
bomb-proofed...) The UDF concept was never intended to perform DML operations.

>I wouldn't do it that way, though.

I'm glad to know it, Nando. <g>


All for Open and Open for All
Firebird Open SQL Database · ·