Bug report
От | Giuseppe Tanzilli |
---|---|
Тема | Bug report |
Дата | |
Msg-id | 199903011523.QAA09444@king.eurolink.it обсуждение исходный текст |
Список | pgsql-hackers |
============================================================================ POSTGRESQL BUG REPORTTEMPLATE ============================================================================ Your name : Giuseppe Tanzilli Your email address : g.tanzilli@eurolink.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-hackers по дате отправления: