Skip site navigation (1) Skip section navigation (2)

Re: [PG95-DEV] Rule system

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: wieck(at)sapserv(dot)debis(dot)de
Cc: hackers(at)postgreSQL(dot)org (PostgreSQL-development)
Subject: Re: [PG95-DEV] Rule system
Date: 1998-07-04 23:57:11
Message-ID: 199807042357.TAA06028@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> >     The  simple way is to reduce the capabilities of the Postgres
> >     rule system. Changing the syntax of the CREATE RULE to
> > 
> >         CREATE RULE rule AS { BEFORE | AFTER } event TO table
> >             DO [ INSTEAD ] { action | NOTHING }
> > 
> >     would tell the rewrite handler, if the rule actions  have  to
> >     be  applied  before or after the query. Respectively only NEW
> >     or CURRENT could be referenced in the rules qualification and
> >     actions.  I  don't like this simple way, but I think it's the
> >     only possibility that would work  without  reincarnating  the
> >     instance rule system.
> 
> Good description of the problem.  If adding BEFORE/AFTER makes it easier
> to program, do it.  I don't think we are losing any functionality by
> doing this, and the rule system is advertized as being broken, so there
> is probably not a huge installed base.
> 
> We now have something that doesn't work.  If you can get it working, do
> it.  The change makes it clearer to the user exactly how the rule is
> going to behave, too.

Jan, I remember you steering away from rewrite cleanups because we were
so close to 6.3.  Any chance you can make those changes for 6.4, or are
you already working on them?   We really need cleanup in the rewrite
area, and I understand you can do it.


-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-07-05 00:05:25
Subject: Re: [HACKERS] Revised proposal for libpq and FE/BE protocol changes
Previous:From: Bruce MomjianDate: 1998-07-03 20:09:27
Subject: MySQL and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group