Re: [Gnumed-devel] cross database queries

[Karsten Hilbert]

> >I wonder if a clever combination of LISTEN/NOTIFY, triggers
> >and an inter-database process on the backend would work as a
> >replacement for that functionality ?
Yes it will but it is too slow for use. Same for FKs via
dblink.

I am working on "deferred" remote FKs: the FK values being
checked by a cron script at convenient times and violations
reported back in a standard table.

The lot implemented in a schema file (gmCrossDB_FKs.sql) to
be imported into GnuMed service databases when needed much
like gmAudit, gmSchemaRevision and gmI8n.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346