Re: Real newbie question. - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Real newbie question.
Date
Msg-id Pine.BSF.4.21.0108200843430.98666-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Real newbie question.  ("William D. Tallman" <wtallman@olypen.com>)
List pgsql-general
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?
>

It probably means you have mismatched single quotes which means it
thinks you're in a string constant.  '; should generally get you an
error and back to a normal prompt I think (close the constant and
statement)



pgsql-general by date:

Previous
From: "Jon Garfunkel"
Date:
Subject: middleware for PostgreSQL: sneak preview
Next
From: s.chava@wcom.com (Srinivasa Rao Chava)
Date:
Subject: insert failed