Re: Return of INSTEAD rules - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Return of INSTEAD rules
Date
Msg-id 200210041549.g94FnVZ07136@candle.pha.pa.us
Whole thread Raw
In response to Re: Return of INSTEAD rules  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Return of INSTEAD rules  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I am confused how yours differs from mine.  I don't see how the last
> > matching tagged query would not be from an INSTEAD rule.
> 
> You could have both INSTEAD and non-INSTEAD rules firing for the same
> original query.  If the alphabetically-last rule is a non-INSTEAD rule,
> then there's a difference.

How do we get multiple rules on a query?  I thought it was mostly
INSERT/UPDATE/DELETE, and those all operate on a single table.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Greg Copeland
Date:
Subject: Re: Threaded Sorting
Next
From: Bruce Momjian
Date:
Subject: Re: Potential Large Performance Gain in WAL synching