From: | Boszormenyi Zoltan <zb(at)cybertec(dot)at> |
---|---|
To: | gvim <gvimrc(at)googlemail(dot)com> |
Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Inconsistent SQL errors |
Date: | 2010-04-15 09:55:13 |
Message-ID: | 4BC6E281.9070105@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | dipti shah | 2010-04-15 10:46:06 | Re: How to get whether user has ALL permissions on table? |
Previous Message | A. Kretschmer | 2010-04-15 09:50:24 | Re: How to get whether user has ALL permissions on table? |