Re: ask for help !!! (emergency case)

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"

In response to

Browse pgsql-hackers by date

  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

Browse pgsql-sql by date

  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