Re: BASH script for collecting analyze-related info - Mailing list pgsql-performance

From Craig James
Subject Re: BASH script for collecting analyze-related info
Date
Msg-id CAFwQ8reQnO+3e+b8fuiMc9nTo1bXXZ6xZcyd_QD558Ja4CGGNQ@mail.gmail.com
Whole thread Raw
In response to Re: BASH script for collecting analyze-related info  (Ken Tanzer <ken.tanzer@gmail.com>)
List pgsql-performance
On Sun, Sep 29, 2013 at 2:24 PM, Ken Tanzer <ken.tanzer@gmail.com> wrote:
p.s.,  This script runs fine on my computer (Ubuntu 13.04), but on a Fedora 11 machine it dies with 

pg_analyze_info.sh: line 18: unexpected EOF while looking for matching `)'
pg_analyze_info.sh: line 57: syntax error: unexpected end of file

If anyone knows why, or encounters a similar error and fixes it, please let me know!

It's the blank line on line 26.  Put a backslash on that line or delete it entirely.

Craig


Well that made perfect sense, but after making that change I'm still getting the same error.

Try putting the entire TABLE= on one big line and see if that works.  If it does, work backwards from there, inserting backslash-newlines.  It may be something simple like an extra space after a backslash.

Craig

pgsql-performance by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: BASH script for collecting analyze-related info
Next
From: didier
Date:
Subject: Re: Slow plan for MAX/MIN or LIMIT 1?