Any troubleshooting techniques - Mailing list pgsql-general

From Johnson, Shaunn
Subject Any troubleshooting techniques
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB0452DF56@snt452.corp.bcbsm.com
Whole thread Raw
List pgsql-general

Howdy:

I'm running Postgres 7.1.3 on RedHat Linux
version 7.2, kernel 2.4.7-10.

I've created a script to build a table
and will run it through a command line
option ( psql -U user -d database -f ./test.sql).
At the top of the script, I put explain,
so I can at least try to figure out what
the script is doing. 

But the only errors I get is:

[snip error]

psql:./test.sql:68: ERROR:  parser: parse error
at or near "create"

[/snip error]

In the script, line 68 is the bottom of
the page (a semi colon) which tells me
that somewhere between the top and
bottom of the script, there is an error.

Is there an easier way to debug SQL?

Thanks!

-X

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Solaris and effective_cache_size
Next
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: Redirecting query's output to a textfile?