From: Emmanuel Charpentier <charpent@bacbuc.dyndns.org>
Subject: Re: [GENERAL] problem with update rules on a view (ODBC)
Date: Sun, 12 Jan 2003 22:37:53 +0100
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 35
Message-ID: <3E21E031.7060406@bacbuc.dyndns.org>
References: <29803.1042398360@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Cc: Oliver Elphick <olly@lfix.co.uk>
To: Tom Lane <tgl@sss.pgh.pa.us>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.2.1) Gecko/20021226 Debian/1.2.1-9
In-Reply-To: <29803.1042398360@sss.pgh.pa.us>
To: pgsql-interfaces@postgresql.org

Tom Lane wrote:
> Emmanuel Charpentier <charpent@bacbuc.dyndns.org> writes:
> 
>>I am trying to create a small applications using a PostgreSQL 7.2 database, 
>>updated through ODBC from an OpenOffice form.
>>...
>>I tried my  rules "by hand" in psql : the update works as advertised in the 
>>docs. However, I noticed that updating the *real" table gives a message :
>>UPDATE 1
>>after updating the table, while updating the view gives the message
>>UPDATE 0
>>after "updating" the view (i. e. updating the underlying table).
> 
> 
> You can control this in 7.3 by adjusting the rule firing order (which
> you do by choosing the names you give to the rules); see
> http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/rules-status.html

Thanks a lot ! I will give it a shot. However, I'm a bit reluctant : my 
test machine is Debian stable but with some unstable packages : it may 
accept the (unstable) Postgres 7.3 package. My production machine, however 
is Debian stable and has to remain so (therefore, no "official" 7.3 
packages) ... Word going around is that the new libc6 (2.3.x) has some 
nasty problems (I've encountered some of them myself : some software 
suddenly broken by unmet dynamic linking dependencies ...).

> I am not sure there is any good workaround in 7.2.

Aaaahhhh ... Now, I'll just have to nag Oliver Elphick into making his 
Debian-stable-Woody PostgreSQL repository apt-get-able ... :-).

Anyway, a big "Thank you" ! The "Open source" software, and especially the 
Postgres team, proves abgain itself much more usable than commercial 
solutions when it comes to support.