Ultimate++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ TheIDE » U++ TheIDE: Compiling, Linking, Debugging of your packages » PostgreSQL under Windows (PostgreSQL Windows Skylark)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

PostgreSQL under Windows [message #50410]

Mon, 22 October 2018 10:24

lovmy
Messages: 40
Registered: November 2015

Member

Hello

i try to use PostgreSQL under Windows in a Skylark application.

I added include postgreSQL directory and lib PostgreSQL directory containing libpq.lib file in Build method.

I have changed "library(WIN32 !NOPOSTGRESQL GCC) pq;" to "library(WIN32 !NOPOSTGRESQL GCC) libpq;" in PostgreSQL.upp because i had the error "cannot find -lpq"

I'm using PostgreSQL 9.6.10 and TheIDE version 11873

Now i have error "undefined reference to 'PQerrorMessage'" and other error message for PQconnectdb, PQstatus...

Can you help me ?

Thank you !

Report message to a moderator

Re: PostgreSQL under Windows [message #50417 is a reply to message #50410]

Wed, 24 October 2018 14:36

BioBytes
Messages: 285
Registered: October 2008
Location: France

Experienced Member

Hi,

Did you try to include the postgreSql package in your project ? Rolling Eyes

Cheers

Biobytes

Report message to a moderator

Re: PostgreSQL under Windows [message #50434 is a reply to message #50410]

Tue, 30 October 2018 14:51

lovmy
Messages: 40
Registered: November 2015

Member

Hello,

Yes, of course !

I send you the error, my test project and picture of the error.

Thank you for your help !

Attachment: Problem.7z
(Size: 227.37KB, Downloaded 69 times)

Report message to a moderator

Re: PostgreSQL under Windows [message #50435 is a reply to message #50410]

Tue, 30 October 2018 14:54

lovmy
Messages: 40
Registered: November 2015

Member

This if first part of include and library i used.

Attachment: PostgreSQL-9.6.10.7z.001
(Size: 2.00MB, Downloaded 59 times)

Report message to a moderator

Re: PostgreSQL under Windows [message #50436 is a reply to message #50410]

Tue, 30 October 2018 14:57

lovmy
Messages: 40
Registered: November 2015

Member

And this is the second part of include and library i used.

Attachment: PostgreSQL-9.6.10.7z.002
(Size: 1.26MB, Downloaded 58 times)

Report message to a moderator

Re: PostgreSQL under Windows [message #50437 is a reply to message #50436]

Tue, 30 October 2018 20:48

BioBytes
Messages: 285
Registered: October 2008
Location: France

Experienced Member

Hi Lovmy,

After exploring your files and Pgsql include and libray files you use in your project, I realized that you compile your project using MingW. If I am right you should have a libpq.a file in your PostgreSQL lib directory.

I prefer to use MySql and MSC15 in my projects. You will find attached a libpq.a file I got from psgsql 9.1 version I guess. Maybe it could help on your side.

Good luck Razz

Biobytes

Attachment: libpq.a
(Size: 109.37KB, Downloaded 61 times)

Report message to a moderator

Re: PostgreSQL under Windows [message #52971 is a reply to message #50410]

Thu, 23 January 2020 16:17

lovmy
Messages: 40
Registered: November 2015

Member

Hello,

Finally I found a solution for linking in this thread:

https:// www.ultimatepp.org/forums/index.php?t=msg&th=10680&g oto=51770&

Now i can generate a exe under Windows 10 x64 (i have no problem under FreeBSD or Linux).

But when i run this program, i have a error (under Windows only, see picture).

<--- Finished in (0:43.31), exitcode: 3 --->

I have trying to compile with MINGW and MINGWx64 but same error.

Can you help me ?