From: | Giuseppe Tanzilli <giuseppe(at)pc(dot)eurolink(dot)it> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | INSERT on VIEWs bug report |
Date: | 1999-02-19 08:39:04 |
Message-ID: | Pine.LNX.4.10.9902190937370.27408-100000@king.eurolink.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
-----BEGIN PGP SIGNED MESSAGE-----
============================================================================
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:
- ---------------------------------------------------------------------
- -----------------------------------------------------------------
Giuseppe Tanzilli Flashnet S.p.A. Telecomunicazioni
mailto: g(dot)tanzilli(at)flashnet(dot)it Sede di Frosinone
Eurolink S.r.l. mailto: info(dot)frosinone(at)flashnet(dot)it
Tel: +39-0775-830012 http://www.flashnet.it
Fax: +39-0775-201321 EUnet Business Partner
http://www.eurolink.it AIIP and ANFOV associated
PGP Key: finger giuseppe(at)king(dot)fr(dot)flashnet(dot)it
- -----------------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: 2.6.3ia
Charset: noconv
iQCVAwUBNs0jMBCcAYrPxVF9AQFbTgP8CWeMCTAqa53hIfg87w3ZaZ1pyBGiFaek
MDUvZzghRmOw+QT35MhDJjWthaVMvKYW0tUSEdcxhAl1qyURhjTtXKPZpcbVZxvJ
eM5DWvs90xFGflgwtNklE3z/E7AUjCcAUVchlwlr0kRCDH3MB5AQuKE5Gg/K2agI
+8/mC5D9DTY=
=Wvvz
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Richards | 1999-02-22 02:03:04 | Bug with a join and group by query. |
Previous Message | user2 | 1999-02-17 18:25:38 | ADV: Treat a Friend with a Gift above the Ordinary |