On Wed, Apr 14, 2010 at 11:04 PM, gvim <gvi...@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 >