Skip site navigation (1) Skip section navigation (2)

Bug report

From: Giuseppe Tanzilli <giuseppe(at)pc(dot)eurolink(dot)it>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug report
Date: 1999-03-01 15:28:08
Message-ID: 199903011528.QAA10022@king.eurolink.it (view raw or flat)
Thread:
Lists: pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		:	Giuseppe Tanzilli
Your email address	: g(dot)tanzilli(at)eurolink(dot)it


System Configuration
---------------------
  Architecture (example: Intel Pentium)  	: Intel Pentium II

  Operating System (example: Linux 2.0.26 ELF) 	: Linux 2.2.1 ELF libc6

  PostgreSQL version (example: PostgreSQL-6.4.2)  :   PostgreSQL-6.4.2

  Compiler used (example:  gcc 2.8.0)		: gcc 2.7.2.3


Please enter a FULL description of your problem:
------------------------------------------------
INSERT is allowed over VIEWs, the row are not visible in the tables,
but in the tables file the row is present.    




Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
----------------------------------------------------------------------
CREATE TABLE t1 (i1 int4, i2 int4);
CREATE TABLE t2 (i3 int4, i4 int4);
INSERT INTO t1 (i1,i2) values(1, 1);
INSERT INTO t1 (i1,i2) values(2, 1);
INSERT INTO t1 (i1,i2) values(3, 1);
INSERT INTO t1 (i1,i2) values(4, 1);
INSERT INTO t1 (i1,i2) values(5, 1);
INSERT INTO t2 (i3,i4) values(1, 100);
INSERT INTO t2 (i3,i4) values(2, 100);
INSERT INTO t2 (i3,i4) values(3, 100);
INSERT INTO t2 (i3,i4) values(4, 100);
CREATE VIEW v1 as SELECT i1,i2,i4 from t1,t2 where i1=i3;
SELECT * from v1;
INSERT INTO v1 (i1,i2,i4) values (10,10,200);
SELECT * from v1;
SELECT * from t1;
SELECT * from t2;

DROP VIEW v1;
DROP TABLE t1;
DROP TABLE t2;





If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------



pgsql-bugs by date

Next:From: secretDate: 1999-03-02 14:33:49
Subject: Backend Deadlock
Previous:From: John SummerfieldDate: 1999-03-01 05:02:35
Subject: Problem storing dates with JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group