Insert into view

From: Theo Kramer <theo(at)flame(dot)co(dot)za>
To: hackers(at)postgresql(dot)org
Subject: Insert into view
Date: 1999-11-30 10:25:22
Message-ID: 3843A612.FBAE3F1C@flame.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 1999-11-30 10:31:22 Re: [HACKERS] union and LIMIT problem
Previous Message Hannu Krosing 1999-11-30 08:42:25 Re: [HACKERS] sort on huge table