On Fri, 27 May 2005, Tom Lane wrote:
Same old same old: as soon as you've deleted from offer_mutable, there
is no row in the view with the given offer_id; and since OLD is a macro
for the view, the second delete finds nothing to do.
Oh, now I'm starting to see how this behavior does make sense
Curt Sampson <[EMAIL PROTECTED]> writes:
> CREATE VIEW offer AS
> SELECT * FROM offer_immutable NATURAL JOIN offer_mutable;
> In a transaction, when I try to commit, this does not work:
> CREATE OR REPLACE RULE offer_delete AS
> ON DELETE TO offer DO INSTEAD (
> DE
