INSERT/UPDATE in views fail silently

From: Johann Uhrmann <juhrman(at)fh-landshut(dot)de>
To: postgres <pgsql-general(at)postgresql(dot)org>
Subject: INSERT/UPDATE in views fail silently
Date: 2000-05-26 19:13:19
Message-ID: 392ECCCF.3A308463@fh-landshut.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Peterson 2000-05-26 19:30:22 Re: SPI & file locations
Previous Message Bryan White 2000-05-26 19:12:09 Update Performance from 6.5.0 to 6.5.3 to 7.0