Re: Inconsistent SQL errors
| От | Scott Mead |
|---|---|
| Тема | Re: Inconsistent SQL errors |
| Дата | |
| Msg-id | w2vd3ab2ec81004142008s7bedae3bm6fbbea626fa44b84@mail.gmail.com обсуждение исходный текст |
| Ответ на | Inconsistent SQL errors (gvim <gvimrc@googlemail.com>) |
| Список | pgsql-general |
On Wed, Apr 14, 2010 at 11:04 PM, gvim <gvimrc@googlemail.com> wrote:
I'm running PostgreSQL 8.4.3 on OS X Snow Leopard via MacPorts and I'm getting strange inconsistent errors such as:
dbuser-# select * from log_form;
ERROR: syntax error at or near "select"
LINE 2: select * from log_form;
^
Then later the same query will run fine, as it should.
Yup, it's because you previously entered something into psql without a ';'
Normally, the psql prompt shows:
dbuser=#
You are showing:
dbuser-#
(Notice the '-' instead of '=' )
This means that you entered a command and didn't put a semi-colon somewhere along the way. If you see that, just enter a semi-colon and you'll get back to a top-level (=#) prompt.
--Scott
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: