Re: pg_dump --where option

The following review has been posted through the commitfest application:
make installcheck-world:  tested, failed
Implements feature:       tested, failed
Spec compliant:           tested, failed
Documentation:            tested, failed

Hi

I had a look at the patch and it cleanly applies to postgres master branch. I tried to do a quick test on the new
"whereclause" functionality and for the most part it does the job as described and I'm sure some people will find this
featureuseful to their database dump needs. However I tried the feature with a case where I have a subquery in the
whereclause, but it seems to be failing to dump the data. I ran the pg_dump like:
 

  $ pg_dump -d cary --where="test1:a3 = ( select max(aa1) from test2 )" > testdump2
  $ pg_dump: error: processing of table "public.test1" failed

both test1 and test2 exist in the database and the same subquery works under psql.
 
I also notice that the regression tests for pg_dump is failing due to the patch, I think it is worth looking into the
failuremessages and also add some test cases on the new "where" clause to ensure that it can cover as many use cases as
possible.

thank you
Best regards

Cary Huang
-------------
HighGo Software Inc. (Canada)
cary.huang@highgo.ca
www.highgo.ca