Re: [BUGS] BUG #14645: Can't use psql from within program used by "copy ... from program" script? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14645: Can't use psql from within program used by "copy ... from program" script?
Date
Msg-id 28102.1494095284@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14645: Can't use psql from within program used by "copy ... fromprogram" script?  (john@7fff.com)
Responses Re: [BUGS] BUG #14645: Can't use psql from within program used by"copy ... from program" script?  (John Norman <john@7fff.com>)
List pgsql-bugs
John Norman <john@7fff.com> writes:
> I'm running this all locally on my laptop.
> I checkout stdout and stderr: Nothing.

Hmph ... how are you starting the server exactly?

I now notice that you're running on OS X ... what version of that?
Do you have SIP enabled?  SIP has been known to break stuff like
this; in particular I'm thinking of its habit of silently suppressing
key environment variables like DYLD_LIBRARY_PATH at inopportune times.
If your setup is such that your psql needs that set to start correctly,
that could be a place to look for an explanation.

A related thought is that maybe PATH in the server is different from
what you have interactively, so that it's not finding psql, or finding
the wrong copy.  Specifying a full path to psql in the invoked script
would help narrow that down.
        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

pgsql-bugs by date:

Previous
From: John Norman
Date:
Subject: Re: [BUGS] BUG #14645: Can't use psql from within program used by"copy ... from program" script?
Next
From: John Norman
Date:
Subject: Re: [BUGS] BUG #14645: Can't use psql from within program used by"copy ... from program" script?