Re: ask for help !!! (emergency case) - Mailing list pgsql-sql

From jdassen@cistron.nl (J.H.M. Dassen (Ray))
Subject Re: ask for help !!! (emergency case)
Date
Msg-id slrn99icks.ubd.jdassen@odin.cistron-office.nl
Whole thread Raw
In response to ask for help !!! (emergency case)  ("Jaruwan Laongmal" <jaruwan@gits.net.th>)
List pgsql-sql
Jaruwan Laongmal <jaruwan@gits.net.th> 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"



pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Passing a table to PL/pgSQL
Next
From: "J.Fernando Moyano"
Date:
Subject: Fwd: Re: sum(bool)?