From: | jdassen(at)cistron(dot)nl (J(dot)H(dot)M(dot) Dassen (Ray)) |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: ask for help !!! (emergency case) |
Date: | 2001-02-25 16:29:35 |
Message-ID: | slrn99icks.ubd.jdassen@odin.cistron-office.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
Jaruwan Laongmal <jaruwan(at)gits(dot)net(dot)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"
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-02-25 17:35:26 | Re: CommitDelay performance improvement |
Previous Message | Dominique Quatravaux | 2001-02-25 16:27:06 | Re: CommitDelay performance improvement |
From | Date | Subject | |
---|---|---|---|
Next Message | Lotus118 | 2001-02-25 21:02:18 | distinct date problem |
Previous Message | Roberto Mello | 2001-02-25 01:17:16 | Passing a table to PL/pgSQL |