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"