| 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: | Whole Thread | Raw Message | 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) #
| 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 |