Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 24 Mar 1998 21:37:02 -0800 (PST)
From:      Simon Shapiro <shimon@simon-shapiro.org>
To:        Amancio Hasty <hasty@rah.star-gate.com>
Cc:        teo@flex.ro, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, scrappy@hub.org, Bruce Momjian <maillist@candle.pha.pa.us>
Subject:   Re: [PORTS] Pgaccess doesn't run on -current anymore, Update
Message-ID:  <XFMail.980324213702.shimon@simon-shapiro.org>
In-Reply-To: <199803250516.VAA27684@rah.star-gate.com>

next in thread | previous in thread | raw e-mail | index | archive | help

On 25-Mar-98 Amancio Hasty wrote:

> We can wait,  if you like,
> 
> wish8.0 -f pgaccess.tcl
> 
> Selected Object->New
> 
> Then I entered:
> Table: Simon
> Field: User
> Field type : text
> Default : FreeBSD
> 
> Click on : "Add Field"
> 
>       Voila, I have a table entry!!
> 
> Again, this is with the pgaccess that came with postgres 6.3.1 and I am
> using
> tcl8.0 and tk8.0

Oh, this works.  We database nerds overloaded the word query.  In English
it means to ask, search for an answer, etc.  In SQL it means ``any request
made to the database''.  What the English speaking person means by query,
we call SELECT.  You need to select (not SELECT :-) the Queries tab, press
the New button above, click in the large window (to get focus), type
``insert into junk values(1);'' and click the Execute query button.
You will get a Table Browser window, and an Error (popup) window.
The Error popup will say:  Error executing SQL command insert into junk
values(1); Error message:ERROR: parser: parse errorat or near "insert"

As I said before, it could be intentional for that window to fail on all
non-SELECT queries, but I am not the only one who makes the mistake of
assuming it to be a bug.

Simon


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?XFMail.980324213702.shimon>