Received: from ncc1701.cistron.net (ncc1701.cistron.net [195.64.68.38]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1PGSGx14289 for ; Sun, 25 Feb 2001 11:28:17 -0500 (EST) (envelope-from news@uucp.cistron.nl) Received: from news by ncc1701.cistron.net with local (Exim 3.20 #1 (Debian)) id 14X43D-0005rs-00 for ; Sun, 25 Feb 2001 17:29:35 +0100 From: jdassen@cistron.nl (J.H.M. Dassen (Ray)) Subject: Re: ask for help !!! (emergency case) Date: Sun, 25 Feb 2001 16:29:35 +0000 (UTC) Organization: Cistron Internet Services B.V. Lines: 15 Message-ID: References: <002c01c09d89$ce591980$6d9a96cb@ntl> X-Trace: ncc1701.cistron.net 983118575 22551 195.64.65.236 (25 Feb 2001 16:29:35 GMT) X-Complaints-To: abuse@cistron.nl To: pgsql-sql@postgresql.org Errors-To: news@news.cistron.nl X-Archive-Number: 200102/390 X-Sequence-Number: 1595 Jaruwan Laongmal wrote: >create view v1 as select * from t1,t2; >insert into v1 values(1,'wan1'); Quoting http://www.postgresql.org/docs/aw_pgsql_book/node149.html: : Because views are not ordinary tables, INSERTs , UPDATEs , and DELETEs on : views have no effect. The next section shows how rules can correct this : problem. HTH, Ray -- Pinky, Are You Pondering What I'm Pondering? Ewww, I think so Brain, but I think I'd rather eat the Macarena. Pinky and the Brain in "Plan Brain From Outer Space"