From owner-freebsd-database  Tue Mar 24 21:16:59 1998
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Received: (from majordom@localhost)
          by hub.freebsd.org (8.8.8/8.8.8) id VAA08283
          for freebsd-database-outgoing; Tue, 24 Mar 1998 21:16:59 -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 VAA08278
          for <freebsd-database@freebsd.org>; Tue, 24 Mar 1998 21:16:57 -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 VAA27684;
          Tue, 24 Mar 1998 21:16:07 -0800 (PST)
          (envelope-from hasty@rah.star-gate.com)
Message-Id: <199803250516.VAA27684@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 <maillist@candle.pha.pa.us>
Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update 
In-reply-to: Your message of "Tue, 24 Mar 1998 21:08:56 PST."
             <XFMail.980324210856.shimon@simon-shapiro.org> 
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Tue, 24 Mar 1998 21:16:07 -0800
From: Amancio Hasty <hasty@rah.star-gate.com>
Sender: owner-freebsd-database@FreeBSD.ORG
Precedence: bulk

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

	Cheers,
	Amancio



> 
> 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