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
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 |