Bill MacArthur <webmas...@dhs-club.com> writes:
> Tom, in preparation for a test case I created a new schema (testcase) and
> copied 6 tables to that, including only the columns significant to enable the
> VIEWs to be created. I took the 3 VIEWs involved and tweaked them into the
> new schema (just renamed to testcase.viewname and referencing
> testcase.relation). However, when run from in there, the results are as
> expected rather than erroneous. The live data and VIEWs still produce
> erroneous results. Any clues??
Is the query plan the same according to EXPLAIN?
If not, you may have forgotten to vacuum/analyze the new tables, or
forgotten some relevant index. Or it might be that the total table size
is affecting the plan choice, in which case you need dummy data in the
"irrelevant" columns rather than removing them altogether.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
