Skip site navigation (1) Skip section navigation (2)

Re: problem with update rules on a view (ODBC)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: charpent(at)bacbuc(dot)dyndns(dot)org
Cc: pgsql-general(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: problem with update rules on a view (ODBC)
Date: 2003-01-12 19:06:00
Message-ID: 29803.1042398360@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)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

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

			regards, tom lane

In response to

Responses

pgsql-interfaces by date

Next:From: Juddy GómezDate: 2003-01-12 19:11:54
Subject: XML and PHP??
Previous:From: Emmanuel CharpentierDate: 2003-01-12 18:45:33
Subject: problem with update rules on a view (ODBC)

pgsql-general by date

Next:From: Emmanuel CharpentierDate: 2003-01-12 21:37:53
Subject: Re: [GENERAL] problem with update rules on a view (ODBC)
Previous:From: Emmanuel CharpentierDate: 2003-01-12 18:45:33
Subject: problem with update rules on a view (ODBC)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group