From: Gerhard Hintermayer <g.hintermayer@inode.at>
Subject: Re: pgtcl has no coresponding function to PQcmdTuples
Date: Tue, 26 Nov 2002 20:43:03 +0100
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 45
Message-ID: <as0krf$s8n$1@news.hub.org>
References: <200211231642.58326.artur2@xdobry.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2b) Gecko/20021016
In-Reply-To: <200211231642.58326.artur2@xdobry.de>
To: pgsql-interfaces@postgresql.org

Artur Trzewik wrote:

> Hi!
>
> I have noticed that
> pg_result $handle -numTuples
> result always 0 after DELETE and UPDATE command
>
> I have taken a look in the source code of pgtcl
> and I see

pg_execute is your friend, see below ...

>
> [...]
>
> (better were to use Tcl_GetIndexFromObj an not strcmp,
>  sprintf(interp->result,...) is also unsafe and very historical
> It should be Tcl_SetObjResult(interp, Tcl_NewIntObj(PQcmdTuples(result)));
> It do not look good
>
> By the way.
> pgtcl uses very old tcl interface (up to version 7)
> using new interface would increase speed about 30-40%.
> It also do not carry about UTF in new Tcl (new means about 2 years).
> It hurts me to see that old tcl interfaces slow up tcl (and another say it is
> slow).
>
> I can upgrade it (I have done it for mysqltcl) if there are need for it.
> I need conntact to pgtcl maintainer/autor.
>
> best regards,
> Artur Trzewik

Already done, see
http://gborg.postgresql.org/project/pgtcl/

and also the announcement at c.l.t:
http://groups.google.com/groups?q=pgtcl+group:comp.lang.tcl.*&hl=en&lr=&ie=UTF-8&safe=off&selm=1037426192.509154%40nntp1.bsj.jax.superconnect.net&rnum=1


-- 
Gerhard Hintermayer
http://www.inode.at/g.hintermayer