[Top][All Lists]

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

Re: [Gnumed-devel] (no subject)

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] (no subject)
Date: Sat, 18 Jun 2005 16:02:21 +0200
User-agent: Mutt/

On Fri, Jun 17, 2005 at 09:03:58PM +0800, Syan Tan wrote:

> >> update clin_root_item set fk_episode = currval('pk_episode_seq') 
> this of course , being contingent on Karsten allowing updates
> to clin_root_item is special circumstances, ? a special group permission 

It's not that I don't feel like allowing that for personal
reasons. It's rather that doing so is inherently unsafe in
PostgreSQL, eg child tables' keys WILL NOT GET UPDATED by it.

Generally: If you update rows in a parent table directly those
updates WILL NOT show up in the corresponding child tables.
This is a severe limitation in PostgreSQL's inheritance

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]