[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] cross database queries

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] cross database queries
Date: Sun, 27 Jul 2003 01:47:14 +0200
User-agent: Mutt/

> >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

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.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]