Received: from loom.online.ee (loom.online.ee [194.106.96.5]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eBV8nfL63105 for ; Sun, 31 Dec 2000 03:49:41 -0500 (EST) (envelope-from peeter.smitt@online.ee) Received: (qmail 13310 invoked from network); 31 Dec 2000 10:49:31 +0200 Received: from miniraket.online.ee (HELO miniraket) (194.106.100.111) by loom.online.ee with SMTP; 31 Dec 2000 10:49:31 +0200 Message-ID: <002d01c04a2a$262f2680$6f646ac2@miniraket> From: "Peeter Smitt" To: Subject: Rules Date: Thu, 9 Nov 2000 10:50:44 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002A_01C04A3A.E91F38F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200012/316 X-Sequence-Number: 656 This is a multi-part message in MIME format. ------=_NextPart_000_002A_01C04A3A.E91F38F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi=20 I'm trying to make updateable view useing rules. CREATE RULE update_rule AS ON UPDATE TO table DO INSTEAD SELECT fun1(new); Thing is that backend gives this error. ERROR: parser: parse error at or near ")" What i'm doing wrong? Are there any other ways to make updatebale multi-tab= le views? thanks and joyfull new year. ----------------------------------------- Peeter Smitt AS Delfi Online P=E4rnu mnt. 158 11317 Tallinn, Estonia Tel +3726501734 GSM +37256647653 peeter.smitt@online.ee www.delfi.ee ------=_NextPart_000_002A_01C04A3A.E91F38F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi
 
I'm trying to make updateable view useing= =20 rules.
 
CREATE RULE update_rule AS ON UPDATE TO ta= ble DO=20 INSTEAD
  SELECT fun1(new);
 
Thing is that backend gives this=20 error.
  ERROR:  parser: parse error at= or near=20 ")"
 
What i'm doing wrong? Are there any other = ways to=20 make updatebale multi-table views?
 
thanks and joyfull new year.
 
-----------------------------------------<= BR>Peeter=20 Smitt
AS Delfi Online
P=E4rnu mnt. 158
11317 Tallinn, Estonia
T= el=20 +3726501734
GSM +37256647653
peeter.smitt@online.ee
www.delfi.ee
------=_NextPart_000_002A_01C04A3A.E91F38F0--