Re: Queries using rules show no rows modified? - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: Queries using rules show no rows modified?
Date
Msg-id 3CDB1F82.BFE2CC5C@tpf.co.jp
Whole thread Raw
In response to Queries using rules show no rows modified?  (Michael Alan Dorman <mdorman@debian.org>)
Responses Re: Queries using rules show no rows modified?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> Michael Alan Dorman <mdorman@debian.org> writes:
> > So, If I understood the proposals correctly, I think that means that
> > this implementation argues for, or at least would work well with,
> > Hiroshi's solution, since yours, Tom, would return a false zero in
> > certain (perhaps rare) situations,
> 
> IMHO Hiroshi's solution would return false information in more cases
> than mine.


My solution never returns false information as to
patched cases though the returned result may be
different from the one clients expect.
Probably your solution doesn't return false
information either if 'UPDATE 0' means UPDATE 0
but unknown INSERT/DELETEs. But few(maybe no ?)
clients seem to think of it and what could clients
do with such infos in the first place ? 
Of cource it is nice to have a complete solution
immediately but it doesn't seem easy. My patch is
only a makeshift solution but fixes the most
siginificant case(typical updatable views). 

regards, 
Hiroshi Inouehttp://w2422.nsk.ne.jp/~inoue/


pgsql-hackers by date:

Previous
From: "Ernesto Gutierrez"
Date:
Subject: Re: How much work is a native Windows application?
Next
From: Tom Lane
Date:
Subject: Re: Queries using rules show no rows modified?