Received: from vilaflor.ccti.ull.es (ull.es [193.145.124.5]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA80522 for ; Fri, 4 Jun 1999 09:06:31 -0400 (EDT) (envelope-from jhpinero@ull.es) Received: from mercedes (mercedes.ccti.ull.es [193.145.124.202]) by vilaflor.ccti.ull.es (8.8.5/8.8.5) with SMTP id OAA19899 for ; Fri, 4 Jun 1999 14:07:59 GMT Message-ID: <005b01beae8b$31abc360$ca7c91c1@mercedes.ccti.ull.es> From: "=?iso-8859-1?Q?Jorge_Herrera_Pi=F1ero?=" To: Subject: A little problem updating data with views Date: Fri, 4 Jun 1999 14:07:26 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 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