Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 24 Mar 1998 21:16:07 -0800
From:      Amancio Hasty <hasty@rah.star-gate.com>
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 
Message-ID:  <199803250516.VAA27684@rah.star-gate.com>
In-Reply-To: Your message of "Tue, 24 Mar 1998 21:08:56 PST." <XFMail.980324210856.shimon@simon-shapiro.org> 

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?199803250516.VAA27684>