Re: [SQL] RV: A little problem updating data with views

I don't believe views are updatable in postgresql.

Jorge Herrera Piñero wrote:
>
> 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

--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris(dot)bitmead(at)bigfoot(dot)com