[Top][All Lists]

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

Re: [Gnumed-devel] Fwd: postgresql cross-database query

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Fwd: postgresql cross-database query
Date: Sun, 4 Aug 2002 14:20:22 +0200
User-agent: Mutt/


if you just need to copy data from one db to another your best
bet would be to run the data through a frontend. There may be
several issues with getting this done in a decent amount of

Our problem is mainly concerned with keeping referential
integrity. Currently we solve it client-side by keeping track
of cross-referenced things explicitely in the two databases

I have recently hit upon the idea to use LISTEN/NOTIFY with
triggers/rules, proxy tables and a dedicated referential
integrity process to solve this semi-automatically.

OTOH, one could use the approach to mimimize cross references,
declare certain databases authoritative on certain data items
and running regular housekeeping scripts that clean up broken

Karsten Hilbert
i18n coordinator
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]