INSERT/UPDATE in views fail silently - Mailing list pgsql-general

From Johann Uhrmann
Subject INSERT/UPDATE in views fail silently
Date
Msg-id 392ECCCF.3A308463@fh-landshut.de
Whole thread Raw
Responses Re: INSERT/UPDATE in views fail silently
List pgsql-general
Hello,

on my linux-systems a write access to views fails without any
error message:

hans=> create table demo (i integer);
CREATE
hans=> create view demoview as select * from demo;
CREATE
hans=> insert into demoview values (5);
INSERT 151142 1
hans=> select * from demo;
i
-
(0 rows)


Does Postgres not support insert/update on views?
Why do I get a 'INSERT' answer from postgres when no data
is inserted?

I'm using Postgres 7.0 and 6.5.3 on two different Linux systems.

Thanks,
Hans

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: SPI & file locations
Next
From: "Bryan White"
Date:
Subject: Update Performance from 6.5.0 to 6.5.3 to 7.0