Re: Rules (was: Re: [SQL] How can I optimize...)

From: jwieck(at)debis(dot)com (Jan Wieck)
To: elangog(at)wipinfo(dot)soft(dot)net (G(dot)Elangovan)
Cc: jwieck(at)debis(dot)com, mwm(at)phone(dot)net, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: Rules (was: Re: [SQL] How can I optimize...)
Date: 1998-11-05 12:08:25
Message-ID: m0zbODB-000EBYC@orion.SAPserv.Hamburg.dsh.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> I tried Creating RULE with both the example
> In first example both the rule failed with error "old table not found"
> In case of second example
> i managed to create
>
> [...]
>
> ERROR: old: Table does not exist.
> Please giveme some more info on the KEY word (NEW and OLD).attribute
> Note : iam using postgresql 6.3.2
>
> Thanku , for ur kind help

DON'T TRY TO USE THE RULE SYSTEM IN A v6.3.2 DATABASE. IT'S
BUGGY AND DOES NOT WORK AT ALL.

All I wrote depends on the major changes I've done in the
rule system for v6.4.

In v6.4 CURRENT is aliased with OLD and in v6.5 CURRENT will
disappear completely.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Barracuda 1998-11-05 14:06:14 Updating database
Previous Message rony khoury 1998-11-05 06:32:40 select b[1] from foo