From: | Evan Zane Macosko <macosko(at)fas(dot)harvard(dot)edu> |
---|---|
To: | "William D(dot) Tallman" <wtallman(at)olypen(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Real newbie question. |
Date: | 2001-08-20 15:35:28 |
Message-ID: | Pine.OSF.4.33.0108201133260.26126-100000@is08.fas.harvard.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
When the prompt changes from an equals sign to a single dash, it means
you have not finished an SQL statement, pgsql is waiting for a semicolon.
A single quote can mean that you didn't close your single quotation, for
example:
UPDATE foo SET column = 'Thursday
If you press return here, psql will be waiting for you to close the
quotation.
Hope this helps.
On Thu, 16 Aug 2001, William D. Tallman wrote:
> Just started fiddling with PostgreSQL, and know nothing of databases.
>
> I have the documentation that came with the Mandrake-8.0 installation
> written by Thomas Lockhard, and I've perused Bruce Momjian's book online,
> and I cannot find the answer to this problem:
>
> When I am entering values into a table, and make a mistake, sometimes
> there is an error message, and sometimes the equal sign in the prompt
> becomes a single quote. Error messages I can puzzle out, but I have not
> discovered how to recover from the single quote in the prompt. I wind up
> having to kill the terminal and start all over
>
> Can someone point me to the explanation of this?
>
> Thanks, and I hope this question isn't too rudimentary for this NG.
>
> Bill Tallman
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2001-08-20 15:38:29 | Re: Real newbie question. |
Previous Message | Brent R. Matzelle | 2001-08-20 15:26:48 | PostgreSQL Diagram creation tool |