Any troubleshooting techniques

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Any troubleshooting techniques
Date: 2002-02-15 16:46:21
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB0452DF56@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2002-02-15 16:59:25 Re: Redirecting query's output to a textfile?
Previous Message Kaare Rasmussen 2002-02-15 16:44:24 Re: Report generation