[Pyqt-mac-list] Problem compiling the Postgresql database adaptor (solved)

[Brian M. <bri...@gm...>]

Hi Kevin,

Thanks for the reply - so I finally got it working and all is well in 
the Aqua environment. I thought I would write up my experience in case 
anyone else has a similar problem getting the database adaptors to show 
up in Qt Designer.

My main problem was a combination of the Fink QT installation crossing 
with your binary installation. Somehow it was pulling some pieces from 
the Fink install and including them with the /Developer/qt install.

Two things needed to be done for me to successfully compile the 
postgresql adaptor for Aqua. First, I removed all things Qt from the 
Fink environment (except qt3-shlibs, because kde depends on them). 
Secondly, I needed to set an environment variable called QMAKESPEC in 
my ~/.profile. I set it to QMAKESPEC=darwin-g++. I just added it to the 
other Qt environment variables that you mentioned in the instructions. 
Don't forget to add it to the export line.

Then I followed the directions in the Qt Users Manual about compiling 
the SQL drivers.

My postgresql installation (just configured - not installed - in order 
to supply the necessary header files) was installed in /Users/Shared/. 
My regular postgresql installation was in /usr/local/pgsql/ (I 
typically install from source). After navigating to the source files 
for the sql drivers (/Developer/qt/plugins/src/sqldrivers/psql) I was 
ready for the qmake command.

qmake -o Makefile 
"INCLUDEPATH+=/Users/Shared/postgresql-7.4.6/src/include 
/Users/Shared/postgresql-7.4.6/src/interfaces/libpq" 
"LIBS+=-L/usr/local/pgsql/lib -lpq" psql.pro

Then use 'make' to install it (automatically) in the plugins directory. 
Open Qt Designer > Database Connections and with any luck, you should 
see the postgresql adaptor in the drop down menu.

Phew !! I am happy to say I have all the pieces to make PyQt database 
applications...finally.

Thanks again for putting together all the pieces to make this happen.

Brian





On Dec 10, 2004, at 3:36 PM, Kevin Walzer wrote:

> Hi Brian,
>
> I built Qt-Mac with dynamic rather than static libraries--you should 
> probably try building the Qt SQL modules as a dynamic library. (I 
> don't think plug-ins work with static library.) You may want to 
> consult TrollTech's documentation for more info--there's a large 
> section there on the Qt SQL modules. (I'm not an expert, alas.)
>
>
> -- 
> Cheers,
>
> Kevin Walzer, PhD
> WordTech Software--Open Source Applications and Packages for OS X
> http://www.wordtech-software.com
> http://www.smallbizmac.com
> http://www.kevin-walzer.com
> mailto:sw...@wo...
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real 
> users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Pyqt-mac-list mailing list
> Pyq...@li...
> https://lists.sourceforge.net/lists/listinfo/pyqt-mac-list
>