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

[Karsten Hilbert]

Pascal,

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

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

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

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