Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5A0E3475DD7; Sun, 12 Jan 2003 14:06:03 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id B20814759BD; Sun, 12 Jan 2003 14:06:02 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0CJ605u029804; Sun, 12 Jan 2003 14:06:00 -0500 (EST) To: charpent@bacbuc.dyndns.org Cc: pgsql-general@postgresql.org, pgsql-interfaces@postgresql.org Subject: Re: problem with update rules on a view (ODBC) In-reply-to: References: Comments: In-reply-to Emmanuel Charpentier message dated "Sun, 12 Jan 2003 19:45:33 +0100" Date: Sun, 12 Jan 2003 14:06:00 -0500 Message-ID: <29803.1042398360@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/428 X-Sequence-Number: 35549 Emmanuel Charpentier 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 I am not sure there is any good workaround in 7.2. regards, tom lane