Hi Gulliver,
thanks for you reply. Finally I was able to compile the postgresql
backend following your suggestions, even if I had to modify some paths
in the FindPostgreSQL.cmake file. This was necessary because the "ms"
subdirectory doesn't exist on my machine and all postgresql libs are
located in $ENV{ProgramFiles}/PostgreSQL/*/lib
Thanks again.
Giovanni.
Gulliver ha scritto:
Hi Giovanni,
Am 15.01.2010 um 18:42 schrieb Eng. Giovanni Pennisi:
Hi my name is Giovanni, and I'm a new user of litesql. I was able to compile
and build the litesql library for Windows platform, and I also made a short
example using sqlite3 as DB. Now I have some problems using litesql with
postgresql DB. Even if I changed the connection string I always got an Unknown
backend exception. Probably I need to compile a postgresql backend library, can
you tell me how to build this library?
Actually the precompiled Windows Version contains only support for sqlite3. You
have to build litesql by yourself from the sources.
You can download the sources from here:
http://sourceforge.net/projects/litesql/files/, you have also to install cmake
(cmake.org) to generate to Visual Studio Project Files or cygwin/
mingw-Makefiles.
Have a look at release_it.bat or release_it.sh for calling from Commandline.
Enable the Option WITH_POSTGRES:
cmake -D WITH_DOCS:bool=ON -D WITH_POSTGRES:bool=ON -D WITH_SQLITE:bool=ON -D WITH_TEST:bool=ON
Actually POSTGRES is searched in this Locations:
find_path(POSTGRESQL_INCLUDE_DIR libpq-fe.h
/usr/include/pgsql
/usr/local/include/pgsql
/usr/include/postgresql
$ENV{ProgramFiles}/PostgreSQL/*/include
$ENV{SystemDrive}/PostgreSQL/*/include
)
find_library(POSTGRESQL_LIBRARIES NAMES pq libpq
PATHS
/usr/lib
/usr/local/lib
/usr/lib/postgresql
$ENV{ProgramFiles}/PostgreSQL/*/lib/ms
$ENV{SystemDrive}/PostgreSQL/*/lib/ms
)
for other locations of the postgres-client libs you can set on the Commandline:
set POSTGRESQL_INCLUDE_DIR=C:/SomeDirWithPostgres/include
set POSTGRESQL_LIBRARIES=C:/SomeDirWithPostgres/lib
cmake -D WITH_DOCS:bool=ON -D WITH_POSTGRES:bool=ON -D WITH_SQLITE:bool=ON -D WITH_TEST:bool=ON
Kind regards,
Gulliver
Thanks in advance.
Giovanni.
Nessun virus nel messaggio in uscita.
Controllato da AVG - www.avg.com
Versione: 9.0.725 / Database dei virus: 270.14.143/2624 - Data di rilascio:
01/15/10 13:47:00
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev_______________________________________________
Litesql-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/litesql-users
------------------------------------------------------------------------
Nessun virus nel messaggio in arrivo.
Controllato da AVG - www.avg.com
Versione: 9.0.725 / Database dei virus: 270.14.148/2629 - Data di rilascio: 01/17/10 20:35:00
Nessun virus nel messaggio in uscita.
Controllato da AVG - www.avg.com
Versione: 9.0.725 / Database dei virus: 270.14.148/2629 - Data di rilascio:
01/17/10 20:35:00
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Litesql-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/litesql-users
