Re: postgresql-tcl

<bringing this back to the list>

If anyone is interested, there is a pre-compiled Mac OSX pgtcl at the link below.

John,

That'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 on the platform or they can't be found. If you don't need those, then you can get rid of the EXTRA_LIBS part (I think). Otherwise, you will need to make sure they are on your platform, and can be found.

BTW, the lib I built, did *not* include these (ssl crypto). I might try to add them though...

Thanks,
--brett

----- Original Message ----
From: JL <jlt2425(at)mac(dot)com>
To: Brett Schwarz <brett_schwarz(at)yahoo(dot)com>
Sent: Tuesday, July 31, 2007 5:07:18 AM
Subject: Re: [INTERFACES] postgresql-tcl

On Jul 30, 2007, at 22:40-Jul 30, Brett Schwarz wrote:

>
>
>
> try this...not sure if it will work. I tried to build it universal,
> so hopefully it turned out that way:
>
> http://pgfoundry.org/frs/?group_id=1000086
>
>
> I statically built in libpq, so you shouldn't need postgresql
> installed (I hope). You can just load it using the load command:
>
> load /directory/where/lib/is/libpgtcl1.5.dylib

BINGO! Thanks, seems to load fine. I will test the function thru
out this day.
Thanks
John

FYI:
I tried to build on this machine. this is the output from the
configure and make operations. I used the settings from the
documentation in the 1.6.0 package

Zaphod:~/downloads/Tcl_Tk/pgtcl/pgtcl1.6.0 jlt$ EXTRA_LIBS='-lssl -
lcrypto' ./configure --prefix=/usr/local --libdir=/Library/Tcl --
with-postgres-include=/usr/local/pgsql/include --with-postgres-lib=/
usr/local/pgsql/lib --with-tcl=/System/Library/Frameworks/
Tcl.framework --with-tclinclude=/System/Library/Frameworks/
Tcl.framework/Headers

checking for correct TEA configuration... ok (TEA 3.5)
checking for Tcl configuration... found /System/Library/Frameworks/
Tcl.framework/tclConfig.sh
checking for existence of /System/Library/Frameworks/Tcl.framework/
tclConfig.sh... loading
configure: --exec-prefix defaulting to TCL_EXEC_PREFIX /usr
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking how to run the C preprocessor... gcc -E
checking for a BSD-compatible install... /usr/bin/install -c
checking whether make sets $(MAKE)... yes
checking for ranlib... ranlib
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking if the compiler understands -pipe... yes
checking whether byte ordering is bigendian... yes
checking for sin... yes
checking for main in -lieee... no
checking for main in -linet... no
checking net/errno.h usability... no
checking net/errno.h presence... no
checking for net/errno.h... no
checking for connect... yes
checking for gethostbyname... yes
checking dirent.h... yes
checking errno.h usability... yes
checking errno.h presence... yes
checking for errno.h... yes
checking float.h usability... yes
checking float.h presence... yes
checking for float.h... yes
checking values.h usability... no
checking values.h presence... no
checking for values.h... no
checking limits.h usability... yes
checking limits.h presence... yes
checking for limits.h... yes
checking for stdlib.h... (cached) yes
checking for string.h... (cached) yes
checking sys/wait.h usability... yes
checking sys/wait.h presence... yes
checking for sys/wait.h... yes
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking sys/param.h usability... yes
checking sys/param.h presence... yes
checking for sys/param.h... yes
checking for Tcl public headers... /System/Library/Frameworks/
Tcl.framework/Headers
checking how to build libraries... shared
checking if 64bit support is requested... no
checking if 64bit Sparc VIS support is requested... no
checking system version... Darwin-8.10.0
checking for dlopen in -ldl... yes
checking for ar... ar
checking if ld accepts -single_module flag... yes
checking if ld accepts -search_paths_first flag... yes
checking for required early compiler flags... none
checking for 64-bit integer type... long long
checking for struct dirent64... no
checking for struct stat64... no
checking for open64... no
checking for lseek64... no
checking for off64_t... no
checking for build with symbols... no
checking for tclsh... /usr/bin/tclsh8.4
configure: creating ./config.status
config.status: creating Makefile
config.status: WARNING: Makefile.in seems to ignore the --
datarootdir setting
config.status: creating pkgIndex.tcl
++++++++++++++++++++++++++++++++++

Zaphod:~/downloads/Tcl_Tk/pgtcl/pgtcl1.6.0 jlt$ make
gcc -pipe -DPACKAGE_NAME=\"pgtcl\" -DPACKAGE_TARNAME=\"pgtcl\" -
DPACKAGE_VERSION=\"1.6.0\" -DPACKAGE_STRING=\"pgtcl\ 1.6.0\" -
DPACKAGE_BUGREPORT=\"\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -
DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -
DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -
DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DWORDS_BIGENDIAN=1 -
DNO_VALUES_H=1 -DHAVE_LIMITS_H=1 -DHAVE_SYS_PARAM_H=1 -
DTCL_WIDE_INT_TYPE=long\ long -DUSE_TCL_STUBS=1 -I/usr/local/pgsql/
include -I"/System/Library/Frameworks/Tcl.framework/Headers" -Os -
Wall -Wno-implicit-int -fno-common -c `echo pgtcl.c` -o pgtcl.o

gcc -pipe -DPACKAGE_NAME=\"pgtcl\" -DPACKAGE_TARNAME=\"pgtcl\" -
DPACKAGE_VERSION=\"1.6.0\" -DPACKAGE_STRING=\"pgtcl\ 1.6.0\" -
DPACKAGE_BUGREPORT=\"\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -
DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -
DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -
DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DWORDS_BIGENDIAN=1 -
DNO_VALUES_H=1 -DHAVE_LIMITS_H=1 -DHAVE_SYS_PARAM_H=1 -
DTCL_WIDE_INT_TYPE=long\ long -DUSE_TCL_STUBS=1 -I/usr/local/pgsql/
include -I"/System/Library/Frameworks/Tcl.framework/Headers" -Os -
Wall -Wno-implicit-int -fno-common -c `echo pgtclCmds.c` -o pgtclCmds.o

pgtclCmds.c: In function `execute_put_values':
pgtclCmds.c:1932: warning: `varname' might be used uninitialized in
this function
pgtclCmds.c:1933: warning: `indexname' might be used uninitialized in
this function
pgtclCmds.c: In function `Pg_escape_bytea':
pgtclCmds.c:3659: warning: passing arg 2 of pointer to function from
incompatible pointer type

gcc -pipe -DPACKAGE_NAME=\"pgtcl\" -DPACKAGE_TARNAME=\"pgtcl\" -
DPACKAGE_VERSION=\"1.6.0\" -DPACKAGE_STRING=\"pgtcl\ 1.6.0\" -
DPACKAGE_BUGREPORT=\"\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -
DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -
DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -
DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DWORDS_BIGENDIAN=1 -
DNO_VALUES_H=1 -DHAVE_LIMITS_H=1 -DHAVE_SYS_PARAM_H=1 -
DTCL_WIDE_INT_TYPE=long\ long -DUSE_TCL_STUBS=1 -I/usr/local/pgsql/
include -I"/System/Library/Frameworks/Tcl.framework/Headers" -Os -
Wall -Wno-implicit-int -fno-common -c `echo pgtclId.c` -o pgtclId.o

rm -f libpgtcl1.6.0.dylib

gcc -pipe -dynamiclib -Os -Wall -Wno-implicit-int -fno-common -
prebind -headerpad_max_install_names -Wl,-search_paths_first -Wl,-
single_module -o libpgtcl1.6.0.dylib pgtcl.o pgtclCmds.o pgtclId.o -
L/System/Library/Frameworks/Tcl.framework/Versions/8.4 -ltclstub8.4 -
L/usr/local/pgsql/lib -lpq

ld: warning prebinding disabled because of undefined symbols
ld: Undefined symbols:
_SSL_pending
_BIO_free
_BIO_new_mem_buf
_DH_check
_DH_generate_parameters
_DH_size
_ERR_get_error
_ERR_reason_error_string
_EVP_PKEY_free
_PEM_read_DHparams
_PEM_read_PrivateKey
_PEM_read_X509
_PEM_read_bio_DHparams
_SSL_CTX_ctrl
_SSL_CTX_free
_SSL_CTX_load_verify_locations
_SSL_CTX_new
_SSL_CTX_set_tmp_dh_callback
_SSL_CTX_set_verify
_SSL_CTX_set_verify_depth
_SSL_connect
_SSL_free
_SSL_get_error
_SSL_get_ex_data
_SSL_get_peer_certificate
_SSL_library_init
_SSL_load_error_strings
_SSL_new
_SSL_read
_SSL_set_ex_data
_SSL_set_fd
_SSL_shutdown
_SSL_write
_TLSv1_method
_X509_NAME_get_text_by_NID
_X509_NAME_oneline
_X509_check_private_key
_X509_free
_X509_get_subject_name
/usr/bin/libtool: internal link edit command failed
make: *** [libpgtcl1.6.0.dylib] Error 1

____________________________________________________________________________________
Pinpoint customers who are looking for what you sell.
http://searchmarketing.yahoo.com/