RV: A little problem updating data with views

Поиск
Список
Период
Сортировка
От Jorge Herrera Piñero
Тема RV: A little problem updating data with views
Дата
Msg-id 007401beae8c$c020ebb0$ca7c91c1@mercedes.ccti.ull.es
обсуждение исходный текст
Ответы Re: [SQL] RV: A little problem updating data with views  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hello,
   We are using PostgreSQL v6.4 and have problems when we want update   data throught views.   When we issue an update
statmentwithin 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






В списке pgsql-sql по дате отправления:

Предыдущее
От: "Jorge Herrera Piñero"
Дата:
Сообщение: A little problem updating data with views
Следующее
От: Chris Bitmead
Дата:
Сообщение: Re: [SQL] RV: A little problem updating data with views