From owner-freebsd-current Tue Mar 24 21:05:43 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA06109 for freebsd-current-outgoing; Tue, 24 Mar 1998 21:05:43 -0800 (PST) (envelope-from owner-freebsd-current@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 VAA06081 for ; Tue, 24 Mar 1998 21:05:20 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 5892 invoked from network); 25 Mar 1998 05:08:57 -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:08:57 -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: <199803250358.TAA27161@rah.star-gate.com> Date: Tue, 24 Mar 1998 21:08:56 -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, current@FreeBSD.ORG, scrappy@hub.org, Bruce Momjian Sender: owner-freebsd-current@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On 25-Mar-98 Amancio Hasty wrote: > Hi Guys, > > You have to be a little bit more specific as to what is failing. > > Had not problems creating a table and adding fields with the > pgaccess script found in postgress 6.3.1. Oh, sorry. Go to the Query tab in the main menu, select it, press New, then enter a non-SELECT query. Execute it. It will fail with a syntax error near the first word (create/insert/update/delete/etc. I think the API used to send queries to the database uses different execution paths for SELECT and all others (SELECT is the only one returning instances, etc.). The problem may be that pgaccess call the SELECT type routine for all queries. The ``syntax error'' message is probably misleading. Let's wait to hear from the author. Simon To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-current" in the body of the message