Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EBFC09FB596 for ; Tue, 31 Jul 2007 11:10:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 11182-05 for ; Tue, 31 Jul 2007 11:09:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web38901.mail.mud.yahoo.com (web38901.mail.mud.yahoo.com [209.191.125.107]) by postgresql.org (Postfix) with SMTP id 4539F9FB61C for ; Tue, 31 Jul 2007 11:09:57 -0300 (ADT) Received: (qmail 94053 invoked by uid 60001); 31 Jul 2007 14:09:55 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=DDwwKQiLa3yH4VUp2+ptr5M3Zoo2JqV5cymXydc5TVzqNcmC5jGZ9QVzaPFdPAQGS6asugp97Y7naNM2UO+DXO5XhmkW7oo0UyTOrFMcwWmqE2mdnoduAsbHmxX1kmIL9S0dmgI6sco0Sb180Pwv+Ih455FlzFCNnUWz05gWJFw=; X-YMail-OSG: x4FbxhAVM1moQO8dS_58Zr87T202_iApxPaefxTNoR1UFltJiVHunznWLBOaBssiRI6UmKothji7EWCvXcn3E.zYXfKvXOR7CAsNT.3VEue_FW1w_evQTuweJqZsjVKG_hZ0..q. Received: from [24.16.125.24] by web38901.mail.mud.yahoo.com via HTTP; Tue, 31 Jul 2007 07:09:55 PDT X-Mailer: YahooMailRC/651.41 YahooMailWebService/0.7.119 Date: Tue, 31 Jul 2007 07:09:55 -0700 (PDT) From: Brett Schwarz Subject: Re: postgresql-tcl To: JL Cc: L Bayuk , pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Message-ID: <771940.94025.qm@web38901.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/8 X-Sequence-Number: 6592 =0A=0AIf anyone is interested, there is a p= re-compiled Mac OSX pgtcl at the link below.=0A=0AJohn,=0A=0AThat's not the= pgtcl project that I work on, so I'll let L Bayuk explain further, but it = looks like you are including ssl and crypto libs, but perhaps they aren't o= n the platform or they can't be found. If you don't need those, then you ca= n get rid of the EXTRA_LIBS part (I think). Otherwise, you will need to mak= e sure they are on your platform, and can be found.=0A=0ABTW, the lib I bui= lt, did *not* include these (ssl crypto). I might try to add them though...= =0A=0AThanks,=0A --brett=0A=0A=0A----- Original Message ----=0AFrom: JL = =0ATo: Brett Schwarz =0ASent: Tue= sday, July 31, 2007 5:07:18 AM=0ASubject: Re: [INTERFACES] postgresql-tcl= =0A=0A=0AOn Jul 30, 2007, at 22:40-Jul 30, Brett Schwarz wrote:=0A=0A>=0A>= =0A>=0A> try this...not sure if it will work. I tried to build it universal= , =0A> so hopefully it turned out that way:=0A>=0A> http://pgfoundry.org/f= rs/?group_id=3D1000086=0A>=0A>=0A> I statically built in libpq, so you shou= ldn't need postgresql =0A> installed (I hope). You can just load it using = the load command:=0A>=0A> load /directory/where/lib/is/libpgtcl1.5.dylib= =0A=0ABINGO! Thanks, seems to load fine. I will test the function thru = =0Aout this day.=0AThanks=0AJohn=0A=0AFYI:=0A I tried to build on this mac= hine. this is the output from the =0Aconfigure and make operations. I us= ed the settings from the =0Adocumentation in the 1.6.0 package=0A=0AZaphod= :~/downloads/Tcl_Tk/pgtcl/pgtcl1.6.0 jlt$ EXTRA_LIBS=3D'-lssl - =0Alcrypto'= ./configure --prefix=3D/usr/local --libdir=3D/Library/Tcl -- =0Awith-p= ostgres-include=3D/usr/local/pgsql/include --with-postgres-lib=3D/ =0Ausr= /local/pgsql/lib --with-tcl=3D/System/Library/Frameworks/ =0ATcl.framewor= k --with-tclinclude=3D/System/Library/Frameworks/ =0ATcl.framework/Header= s=0A=0A=0Achecking for correct TEA configuration... ok (TEA 3.5)=0Achecking= for Tcl configuration... found /System/Library/Frameworks/ =0ATcl.framewor= k/tclConfig.sh=0Achecking for existence of /System/Library/Frameworks/Tcl.f= ramework/ =0AtclConfig.sh... loading=0Aconfigure: --exec-prefix defaulting = to TCL_EXEC_PREFIX /usr=0Achecking for gcc... gcc=0Achecking for C compiler= default output file name... a.out=0Achecking whether the C compiler works.= .. yes=0Achecking whether we are cross compiling... no=0Achecking for suffi= x of executables...=0Achecking for suffix of object files... o=0Achecking w= hether we are using the GNU C compiler... yes=0Achecking whether gcc accept= s -g... yes=0Achecking for gcc option to accept ISO C89... none needed=0Ach= ecking how to run the C preprocessor... gcc -E=0Achecking for a BSD-compati= ble install... /usr/bin/install -c=0Achecking whether make sets $(MAKE)... = yes=0Achecking for ranlib... ranlib=0Achecking for grep that handles long l= ines and -e... /usr/bin/grep=0Achecking for egrep... /usr/bin/grep -E=0Ache= cking for ANSI C header files... yes=0Achecking for sys/types.h... yes=0Ach= ecking for sys/stat.h... yes=0Achecking for stdlib.h... yes=0Achecking for = string.h... yes=0Achecking for memory.h... yes=0Achecking for strings.h... = yes=0Achecking for inttypes.h... yes=0Achecking for stdint.h... yes=0Acheck= ing for unistd.h... yes=0Achecking if the compiler understands -pipe... yes= =0Achecking whether byte ordering is bigendian... yes=0Achecking for sin...= yes=0Achecking for main in -lieee... no=0Achecking for main in -linet... n= o=0Achecking net/errno.h usability... no=0Achecking net/errno.h presence...= no=0Achecking for net/errno.h... no=0Achecking for connect... yes=0Achecki= ng for gethostbyname... yes=0Achecking dirent.h... yes=0Achecking errno.h u= sability... yes=0Achecking errno.h presence... yes=0Achecking for errno.h..= . yes=0Achecking float.h usability... yes=0Achecking float.h presence... ye= s=0Achecking for float.h... yes=0Achecking values.h usability... no=0Acheck= ing values.h presence... no=0Achecking for values.h... no=0Achecking limits= .h usability... yes=0Achecking limits.h presence... yes=0Achecking for limi= ts.h... yes=0Achecking for stdlib.h... (cached) yes=0Achecking for string.h= ... (cached) yes=0Achecking sys/wait.h usability... yes=0Achecking sys/wait= .h presence... yes=0Achecking for sys/wait.h... yes=0Achecking dlfcn.h usab= ility... yes=0Achecking dlfcn.h presence... yes=0Achecking for dlfcn.h... y= es=0Achecking sys/param.h usability... yes=0Achecking sys/param.h presence.= .. yes=0Achecking for sys/param.h... yes=0Achecking for Tcl public headers.= .. /System/Library/Frameworks/ =0ATcl.framework/Headers=0Achecking how to b= uild libraries... shared=0Achecking if 64bit support is requested... no=0Ac= hecking if 64bit Sparc VIS support is requested... no=0Achecking system ver= sion... Darwin-8.10.0=0Achecking for dlopen in -ldl... yes=0Achecking for a= r... ar=0Achecking if ld accepts -single_module flag... yes=0Achecking if l= d accepts -search_paths_first flag... yes=0Achecking for required early com= piler flags... none=0Achecking for 64-bit integer type... long long=0Acheck= ing for struct dirent64... no=0Achecking for struct stat64... no=0Achecking= for open64... no=0Achecking for lseek64... no=0Achecking for off64_t... no= =0Achecking for build with symbols... no=0Achecking for tclsh... /usr/bin/t= clsh8.4=0Aconfigure: creating ./config.status=0Aconfig.status: creating Mak= efile=0Aconfig.status: WARNING: Makefile.in seems to ignore the -- =0Adata= rootdir setting=0Aconfig.status: creating pkgIndex.tcl=0A++++++++++++++++++= ++++++++++++++++=0A=0AZaphod:~/downloads/Tcl_Tk/pgtcl/pgtcl1.6.0 jlt$ make= =0Agcc -pipe -DPACKAGE_NAME=3D\"pgtcl\" -DPACKAGE_TARNAME=3D\"pgtcl\" - =0A= DPACKAGE_VERSION=3D\"1.6.0\" -DPACKAGE_STRING=3D\"pgtcl\ 1.6.0\" - =0ADPACK= AGE_BUGREPORT=3D\"\" -DSTDC_HEADERS=3D1 -DHAVE_SYS_TYPES_H=3D1 - =0ADHAVE_S= YS_STAT_H=3D1 -DHAVE_STDLIB_H=3D1 -DHAVE_STRING_H=3D1 - =0ADHAVE_MEMORY_H= =3D1 -DHAVE_STRINGS_H=3D1 -DHAVE_INTTYPES_H=3D1 - =0ADHAVE_STDINT_H=3D1 -DH= AVE_UNISTD_H=3D1 -DWORDS_BIGENDIAN=3D1 - =0ADNO_VALUES_H=3D1 -DHAVE_LIMITS_= H=3D1 -DHAVE_SYS_PARAM_H=3D1 - =0ADTCL_WIDE_INT_TYPE=3Dlong\ long -DUSE_TCL= _STUBS=3D1 -I/usr/local/pgsql/ =0Ainclude -I"/System/Library/Frameworks/Tc= l.framework/Headers" -Os - =0AWall -Wno-implicit-int -fno-common -c `ech= o pgtcl.c` -o pgtcl.o=0A=0Agcc -pipe -DPACKAGE_NAME=3D\"pgtcl\" -DPACKAGE_T= ARNAME=3D\"pgtcl\" - =0ADPACKAGE_VERSION=3D\"1.6.0\" -DPACKAGE_STRING=3D\"p= gtcl\ 1.6.0\" - =0ADPACKAGE_BUGREPORT=3D\"\" -DSTDC_HEADERS=3D1 -DHAVE_SYS_= TYPES_H=3D1 - =0ADHAVE_SYS_STAT_H=3D1 -DHAVE_STDLIB_H=3D1 -DHAVE_STRING_H= =3D1 - =0ADHAVE_MEMORY_H=3D1 -DHAVE_STRINGS_H=3D1 -DHAVE_INTTYPES_H=3D1 - = =0ADHAVE_STDINT_H=3D1 -DHAVE_UNISTD_H=3D1 -DWORDS_BIGENDIAN=3D1 - =0ADNO_VA= LUES_H=3D1 -DHAVE_LIMITS_H=3D1 -DHAVE_SYS_PARAM_H=3D1 - =0ADTCL_WIDE_INT_TY= PE=3Dlong\ long -DUSE_TCL_STUBS=3D1 -I/usr/local/pgsql/ =0Ainclude -I"/Sys= tem/Library/Frameworks/Tcl.framework/Headers" -Os - =0AWall -Wno-implici= t-int -fno-common -c `echo pgtclCmds.c` -o pgtclCmds.o=0A=0ApgtclCmds.c: In= function `execute_put_values':=0ApgtclCmds.c:1932: warning: `varname' migh= t be used uninitialized in =0Athis function=0ApgtclCmds.c:1933: warning: `= indexname' might be used uninitialized in =0Athis function=0ApgtclCmds.c: = In function `Pg_escape_bytea':=0ApgtclCmds.c:3659: warning: passing arg 2 o= f pointer to function from =0Aincompatible pointer type=0A=0Agcc -pipe -DP= ACKAGE_NAME=3D\"pgtcl\" -DPACKAGE_TARNAME=3D\"pgtcl\" - =0ADPACKAGE_VERSION= =3D\"1.6.0\" -DPACKAGE_STRING=3D\"pgtcl\ 1.6.0\" - =0ADPACKAGE_BUGREPORT=3D= \"\" -DSTDC_HEADERS=3D1 -DHAVE_SYS_TYPES_H=3D1 - =0ADHAVE_SYS_STAT_H=3D1 -D= HAVE_STDLIB_H=3D1 -DHAVE_STRING_H=3D1 - =0ADHAVE_MEMORY_H=3D1 -DHAVE_STRING= S_H=3D1 -DHAVE_INTTYPES_H=3D1 - =0ADHAVE_STDINT_H=3D1 -DHAVE_UNISTD_H=3D1 -= DWORDS_BIGENDIAN=3D1 - =0ADNO_VALUES_H=3D1 -DHAVE_LIMITS_H=3D1 -DHAVE_SYS_P= ARAM_H=3D1 - =0ADTCL_WIDE_INT_TYPE=3Dlong\ long -DUSE_TCL_STUBS=3D1 -I/usr= /local/pgsql/ =0Ainclude -I"/System/Library/Frameworks/Tcl.framework/Header= s" -Os - =0AWall -Wno-implicit-int -fno-common -c `echo pgtclId.c` -o pg= tclId.o=0A=0Arm -f libpgtcl1.6.0.dylib=0A=0Agcc -pipe -dynamiclib -Os -Wall= -Wno-implicit-int -fno-common - =0Aprebind -headerpad_max_install_names -W= l,-search_paths_first -Wl,- =0Asingle_module -o libpgtcl1.6.0.dylib pgtcl.= o pgtclCmds.o pgtclId.o - =0AL/System/Library/Frameworks/Tcl.framework/Ver= sions/8.4 -ltclstub8.4 - =0AL/usr/local/pgsql/lib -lpq=0A=0Ald: warning pre= binding disabled because of undefined symbols=0Ald: Undefined symbols:=0A_S= SL_pending=0A_BIO_free=0A_BIO_new_mem_buf=0A_DH_check=0A_DH_generate_parame= ters=0A_DH_size=0A_ERR_get_error=0A_ERR_reason_error_string=0A_EVP_PKEY_fre= e=0A_PEM_read_DHparams=0A_PEM_read_PrivateKey=0A_PEM_read_X509=0A_PEM_read_= bio_DHparams=0A_SSL_CTX_ctrl=0A_SSL_CTX_free=0A_SSL_CTX_load_verify_locatio= ns=0A_SSL_CTX_new=0A_SSL_CTX_set_tmp_dh_callback=0A_SSL_CTX_set_verify=0A_S= SL_CTX_set_verify_depth=0A_SSL_connect=0A_SSL_free=0A_SSL_get_error=0A_SSL_= get_ex_data=0A_SSL_get_peer_certificate=0A_SSL_library_init=0A_SSL_load_err= or_strings=0A_SSL_new=0A_SSL_read=0A_SSL_set_ex_data=0A_SSL_set_fd=0A_SSL_s= hutdown=0A_SSL_write=0A_TLSv1_method=0A_X509_NAME_get_text_by_NID=0A_X509_N= AME_oneline=0A_X509_check_private_key=0A_X509_free=0A_X509_get_subject_name= =0A/usr/bin/libtool: internal link edit command failed=0Amake: *** [libpgtc= l1.6.0.dylib] Error 1=0A=0A=0A=0A=0A=0A=0A=0A =0A____________________= ________________________________________________________________=0APinpoint= customers who are looking for what you sell. =0Ahttp://searchmarketing.yah= oo.com/