From owner-freebsd-database Tue Mar 24 21:33:39 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA10190 for freebsd-database-outgoing; Tue, 24 Mar 1998 21:33:39 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id VAA10159 for ; Tue, 24 Mar 1998 21:33:17 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 29514 invoked from network); 25 Mar 1998 05:37:02 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 25 Mar 1998 05:37:02 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-032398 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <199803250516.VAA27684@rah.star-gate.com> Date: Tue, 24 Mar 1998 21:37:02 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: Amancio Hasty Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update Cc: teo@flex.ro, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, scrappy@hub.org, Bruce Momjian Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk 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