| From: | pgsql-bugs(at)postgresql(dot)org | 
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org | 
| Subject: | Silent insert lack | 
| Date: | 2001-01-15 11:31:38 | 
| Message-ID: | 200101151131.f0FBVcY67421@hub.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
Luca Saccarola (l(dot)saccarola(at)bigfoot(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Silent insert lack
Long Description
'insert' statement using a view seems to be accepted with no error message:
  MyDB=> insert into test_u (col1, col2) values ('1', '1');
  INSERT 50371 1
but any following 'select' statements reports an empty table:
  MyDB=> select * from test_pt;
   col1 | col2
  ------+------
  {0 rows)
My environment is PostgreSQL v7.0.3 on Linux 2.2.16 (Red Hat 7.0).
Sample Code
*** using psql:
create table test_pt (col1 varchar(20), col2 varchar(20));
create view test_u as select t1.col1, t1.col2 from test_pt t1;
insert into test_u (col1, col2) values ('1', '1');
select * from test_pt;
No file was uploaded with this report
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gena Gurchonok | 2001-01-15 14:18:52 | table creation | 
| Previous Message | Antonio Da Silva | 2001-01-15 10:51:25 | Problem |