Okay, I just completed a successful build of Postgresql 7.1.3 with TCL,Python and ODBC support which was more work than I expected but here is what I did:
I have a lot of stuff in /sw which I think is where Developer tools dumped things
1. apply patch to base 7.1 3 distribution. This fixes the flat_namespace link and adds posix fixes
http://members.blackbox.net/a/files/postgresql-7.1.3-posix.patch
(see http://www.entropy.ch/software/macosx/postgresql/ for more info)
2. copy tcl and tk header files from /sw/include into postgres-7.1.3/src/include
3. fix link options Makefile src/interface/python to include -flat_namespace
LDSHARED= $(CC) $(LDFLAGS) -bundle -flat_namespace -undefined suppress
I think this is all the fixes it took. Unfortunately pgaccess (which was one point of this exercise) compiles but doesnt run .
Error in startup script: couldn't load file "/usr/local/pgsql/lib/libpgtcl": dynamic loading is not currently available on this system
The bright side is that there are several PostgreSQL clients for MacOSX (MacSQL,ProSQL,pgMac). So far ProSQL seems the best and $89 is not too steep even if it cant do what pgaccess does
cheers
Jamie
