Any troubleshooting techniques

Поиск
Список
Период
Сортировка
От Johnson, Shaunn
Тема Any troubleshooting techniques
Дата
Msg-id 73309C2FDD95D11192E60008C7B1D5BB0452DF56@snt452.corp.bcbsm.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Solaris and effective_cache_size
Следующее
От: "Thalis A. Kalfigopoulos"
Дата:
Сообщение: Re: Redirecting query's output to a textfile?