Re: [GENERAL] Valid query times out when run from bash script

2012-03-27 Thread W. David Jarvis
No prompt, seems to be using .pgpass without a problem. On Tue, Mar 27, 2012 at 1:59 PM, Raymond O'Donnell wrote: > On 27/03/2012 19:37, W. David Jarvis wrote: >> Hello all - >> >> I've been trying to get a bash script set-up that creates a DB, does a >> jo

Re: [GENERAL] Valid query times out when run from bash script

2012-03-27 Thread W. David Jarvis
query out itself into an independent Bash script it executes appropriately). Since this is primarily a Bash issue rather than a psql issue I may take my search elsewhere. - D On Tue, Mar 27, 2012 at 1:20 PM, Steve Crawford wrote: > On 03/27/2012 11:37 AM, W. David Jarvis wrote: >>

[GENERAL] Valid query times out when run from bash script

2012-03-27 Thread W. David Jarvis
Hello all - I've been trying to get a bash script set-up that creates a DB, does a join, writes the join to file, and then cleans itself up afterwards. Everything within the script runs fine when entered at an actual prompt, but when I run the script the SELECT query runs indefinitely. I'm not sur