Date: Tue, 24 Mar 1998 21:08:56 -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, current@FreeBSD.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.980324210856.shimon@simon-shapiro.org> In-Reply-To: <199803250358.TAA27161@rah.star-gate.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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-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.980324210856.shimon>