gvim írta: > 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;
The error is here above. You had a "-#" prompt, saying that you already started another statement in a previous line but you haven't finished it with a ";" > ERROR: syntax error at or near "select" > LINE 2: select * from log_form; > ^ Also, the "LINE 2" message tells that you had something in the first line which was not shown by you. > > Then later the same query will run fine, as it should. I bet that you had a "=#" prompt when it ran fine, not "-#". Best regards, Zoltán Böszörményi -- Bible has answers for everything. Proof: "But let your communication be, Yea, yea; Nay, nay: for whatsoever is more than these cometh of evil." (Matthew 5:37) - basics of digital technology. "May your kingdom come" - superficial description of plate tectonics ---------------------------------- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH http://www.postgresql.at/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
