Insert into view
Theo Kramer <theo@flame.co.za>
From: Theo Kramer <theo@flame.co.za>
To: hackers@postgresql.org
Date: 1999-11-30T10:25:22Z
Lists: pgsql-hackers
Any thoughts on the following
------------------------------ testview.sql
-------------------------------------
drop table testhead; /* If it exists */
drop table testline; /* If it exists */
drop view testview; /* If it exists */
create table testhead (
part text
);
create table testline (
part text,
colour text,
adate datetime default 'now'
);
create view testview as
select testhead.part, testline.colour, testline.adate from testhead, testline
where testhead.part = testline.part;
insert into testview values ('pen', 'green');
insert into testview values ('pen', 'blue');
insert into testview values ('pen', 'black');
select * from testview;
-----------------------------------------------------------------------------------
The inserts report no errors, and when looking into $PGDATA/base/mydb/testview
with a hex editor I can see the values inserted.
The select on view returns nothing...
Should the insert not fail seeing that views are read only ?
--
--------
Regards
Theo