Re: pg_dump and search_path

[Ryan Lambert <ryan@xxxxxxxxxxxxxxxxx>]

My exact situation was a deployment via sqitch,  It appears that uses psql under the hood based on the error message I get.

Running just "sqitch deploy" I  get an error due to a non-fully qualified name and a missing search path (my mistakes).  The error I get:

 + 004 .. psql:deploy/004.sql:72: ERROR:  relation "vobservations" does not exist

LINE 11:                FROM vobservations

                             ^

not ok

"psql" unexpectedly returned exit value 3

Reverting all changes

Running the following works for me in this case and allows it to find the view in the proper schema.

PGOPTIONS='-c search_path=piws,public' sqitch deploy

Ryan