Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them
Date
Msg-id 13773.1350317896@sss.pgh.pa.us
Whole thread Raw
In response to BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them  (webmaster@dhs-club.com)
Responses Re: BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them  (Bill MacArthur <webmaster@dhs-club.com>)
List pgsql-bugs
Tree view 
webmaster@dhs-club.com writes:
> vip_declines_mailers_base is another VIEW that merely adds some criteria to
> limit the result set of the 'base' VIEW. In versions 9.0 and back it did
> just that. After upgrading to 9.2, the criteria actually expand the result
> set.

This doesn't seem to match any of the known bugs in 9.2, so I'm afraid
there's no help for it: you need to create a self-contained test case.

            regards, tom lane

pgsql-bugs by date:

Previous
From: webmaster@dhs-club.com
Date:
Subject: BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them
Next
From: Fujii Masao
Date:
Subject: Re: BUG #7534: walreceiver takes long time to detect n/w breakdown