| From: | Jorge Herrera Piñero <jhpinero(at)ull(dot)es> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | A little problem updating data with views |
| Date: | 1999-06-04 13:07:26 |
| Message-ID: | 005b01beae8b$31abc360$ca7c91c1@mercedes.ccti.ull.es |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jorge Herrera Piñero | 1999-06-04 13:18:35 | RV: A little problem updating data with views |
| Previous Message | José Soares | 1999-06-04 12:51:35 | Re: [SQL] Howto convert floats to text? |