Re: Inconsistent SQL errors

On Wed, Apr 14, 2010 at 11:04 PM, gvim <gvimrc(at)googlemail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>