From owner-freebsd-database Tue Mar 24 21:50:10 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA12262 for freebsd-database-outgoing; Tue, 24 Mar 1998 21:50:10 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from rah.star-gate.com (rah.star-gate.com [209.133.7.234]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id VAA12240 for ; Tue, 24 Mar 1998 21:50:06 -0800 (PST) (envelope-from hasty@rah.star-gate.com) Received: from rah.star-gate.com (localhost.star-gate.com [127.0.0.1]) by rah.star-gate.com (8.8.8/8.8.8) with ESMTP id VAA27868; Tue, 24 Mar 1998 21:48:56 -0800 (PST) (envelope-from hasty@rah.star-gate.com) Message-Id: <199803250548.VAA27868@rah.star-gate.com> X-Mailer: exmh version 2.0.2 2/24/98 To: shimon@simon-shapiro.org cc: teo@flex.ro, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, scrappy@hub.org, Bruce Momjian Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update In-reply-to: Your message of "Tue, 24 Mar 1998 21:37:02 PST." Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Tue, 24 Mar 1998 21:48:55 -0800 From: Amancio Hasty Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Cool, now it is clear what you are having problems with and I don't know how the window or in this case the functionality for the tab "Query" is supposed so work so you are right it is best left to the author to answer the question. "Me thinks " that you are having too much fun! Amancio > > 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