From: Jorge Herrera Piñero <jhpinero@ull.es>
To: pgsql-sql@postgresql.org
Subject: RV: A little problem updating data with views
Date: Fri, 4 Jun 1999 14:18:35 +0100
Message-ID: <007401beae8c$c020ebb0$ca7c91c1@mercedes.ccti.ull.es> (raw)
Hello,
We are using PostgreSQL v6.4 and have problems when we want update
data throught views.
When we issue an update statment within a view, always obtain 'UPDATE 0'
and the data is not updated. We have checked write permissions on view
and are right.
Any ideas was going wrong?
thanks in advance.
A complete UPDATE test:
test=> create table ttest (t varchar(20), n int4);
test=> create view vtest as select t from ttest;
test=> insert into ttest values('asd', 0);
test=> select * from vtest;
t
---
asd
(1 row)
test=> grant all on ttest, vtest to postgres;
CHANGE
test=> update vtest set t='asdasd';
UPDATE 0
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: jhpinero@ull.es
Subject: Re: RV: A little problem updating data with views
In-Reply-To: <007401beae8c$c020ebb0$ca7c91c1@mercedes.ccti.ull.es>
References: <007401beae8c$c020ebb0$ca7c91c1@mercedes.ccti.ull.es>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox