Re: TCL updates - Mailing list pgsql-sql

From JanWieck@t-online.de (Jan Wieck)
Subject Re: TCL updates
Date
Msg-id 200007242247.AAA17144@hot.jw.home
Whole thread Raw
In response to TCL updates  (Kyle <kyle@actarg.com>)
List pgsql-sql
Kyle wrote:
> Jan wrote:
> >   Beginning  with Tcl 8.0, dual ported objects got used to deal
> >    with values. These have (amongst performance issues) alot  of
> >    benefits.  Changing  all  the  call  interfaces would make it
> >    impossible to use PL/Tcl with a  pre  8.0  Tcl  installation.
> >    Since  we're  now  at Tcl 8.3 (the last I've seen), ISTM it's
> >    not a bad decision to force the upgrade.
> >
> >    Comments?
>
> Jan, I would support this upgrade.  I think TCL runs much faster with
> the dual ported calls, right?
   After  writing  the  above  (and looking at the code again) I   realized that most of the  Tcl  calls  into  the  PL
handler   provided  C  functions go through strings anyway. Each single   attribute value must do so, because in the
worstcase someone   might  have replaced the output function for int4, and PL/Tcl   has to be consistent with that.
 
   So I left that one as is for now.

> I would also like to see proper support for nulls in TCL functions as
> this has caused us some problems in the past.
   In CURRENT  sources,  there  are  two  new  PL/Tcl  commands.   "argisnull  n"  determines  if  one specific call
argumentis   NULL. "return_null" will do exactly that.
 

> BTW, any news on this:  Is there a plan for a way to allow a FK
> reference to a table without giving the user select,update privilege on
> the referenced table?  This is currently causing us some grief in our
> design.
   I'm writing on a proposal to replace  the  entire  permission   system  to  a more normalized and generalized
approach. Stay   tuned.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #




pgsql-sql by date:

Previous
From: Thomas SMETS
Date:
Subject: [Fwd: inserting integer in Table]
Next
From: Pablo Niklas
Date:
Subject: RE: primary key question