Silent insert lack

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-bugs by date

  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