There is something wrong with using libpq5 with -FdUMP-ada-spec-C ?

There is something wrong with using libpq5 with -FdUMP-ada-spec-C ?

[Multiplayer1080]

Hello,
I am very very new to Ada. I have dedicated to learn ada for several months and i like this language so much. But now, I need to use a database and i have a question. I hope someone can help me.

There is something wrong with using the driver debian libpq5 importing the header with $ gcc-c-FdUMP-ada-spec-C / usr / include / postgresql / libpq-fe.h?

I have seen that there is a possibility using Gnade, however it seems more difficult to use for me, since I have to build and install these tools, instead of using libraries and add them to my project. I'm in Debian 7. Sorry for my english.

M Trujillo

Re: There is something wrong with using libpq5 with -FdUMP-ada-spec-C ?

[Dirk Heinrichs]

Multiplayer1080 wrote:

> I have seen that there is a possibility using Gnade, however it seems more
> difficult to use for me, since I have to build and install these tools,
> instead of using libraries and add them to my project. I'm in Debian 7.

On Debian, you can use APQ (libapq-postgresql3.2.0-dev) to access databases 
from Ada programs.

HTH...

	Dirk
-- 
Dirk Heinrichs <dirk.heinrichs@altum.de>
Tel: +49 (0)2471 209385 | Mobil: +49 (0)176 34473913
GPG Public Key C2E467BB | Jabber: dirk.heinrichs@altum.de

Re: There is something wrong with using libpq5 with -FdUMP-ada-spec-C ?

[Multiplayer1080]

El jueves, 14 de marzo de 2013 17:51:08 UTC-4:30, Dirk Heinrichs  escribió:
> Multiplayer1080 wrote:
> 
> 
> 
> > I have seen that there is a possibility using Gnade, however it seems more
> 
> > difficult to use for me, since I have to build and install these tools,
> 
> > instead of using libraries and add them to my project. I'm in Debian 7.
> 
> 
> 
> On Debian, you can use APQ (libapq-postgresql3.2.0-dev) to access databases 
> 
> from Ada programs.
> 
> 
> 
> HTH...
> 
> 
> 
> 	Dirk
> 
> -- 
> 
> Dirk Heinrichs <dirk.heinrichs@altum.de>
> 
> Tel: +49 (0)2471 209385 | Mobil: +49 (0)176 34473913
> 
> GPG Public Key C2E467BB | Jabber: dirk.heinrichs@altum.de


Thank you so much, Im trying to use that, but when i build my project with:
"for Source_Dirs use ("src", "../../../../usr/share/ada/adainclude/**");"

i have this answer:
/home/Ada-Project/testing/obj/apq-postgresql-client.o: In function `apq__postgresql__client__connect':
apq-postgresql-client.adb:(.text+0x2ce3): undefined reference to `notice_install'
/home/Ada-Project/testing/obj/apq-postgresql-client.o: In function `apq__postgresql__client__disconnect':
apq-postgresql-client.adb:(.text+0x39fe): undefined reference to `notice_uninstall'
collect2: ld returned 1 exit status
gprbuild: link of nucleo.adb failed

Do you know why i got this error? is this the correct form to include the library lapq? Im using the GPS with no switches... 

Thanks again..

Re: There is something wrong with using libpq5 with -FdUMP-ada-spec-C ?

[Multiplayer1080]

I found the problem. 

1) I have not configured the project properties > languages to C. 

2) The source /usr/share/ada/adainclude/notices.c has:
#include "libpq-fe.h"
And i change it for:
#include "postgresql/libpq-fe.h"

and with this, the building is complete normally.

Re: There is something wrong with using libpq5 with -FdUMP-ada-spec-C ?

[Multiplayer1080]

however, i dont think that this is the best method to use a library that is in debian repository and i installed. i mean, why i have to extract the apq directory (the .ads and .adb) and rebuild it instead use a "with and use" directly?
(i guess that my novice mind dont let me use the debian advantages)

Re: There is something wrong with using libpq5 with -FdUMP-ada-spec-C ?

[Simon Wright]

Multiplayer1080 <marlontrujillo1080@gmail.com> writes:

> however, i dont think that this is the best method to use a library
> that is in debian repository and i installed. i mean, why i have to
> extract the apq directory (the .ads and .adb) and rebuild it instead
> use a "with and use" directly?
> (i guess that my novice mind dont let me use the debian advantages)

You need to be using the GNAT Project facility.

I wrote a little bit about it at [1] (there must be a beginner-oriented
tutorial somewhere?)

The installed APQ library contains an "apq.gpr", in the place where GNAT
expects to find it, which tells GNAT how to compile against and link
with the software.

Write your own .gpr and include the line
   with "apq";
at the beginning.

[1] http://stackoverflow.com/questions/12582796/get-ada-compiled-with-gnat-to-import-files-from-outside-current-directory/12587981#12587981

Re: There is something wrong with using libpq5 with -FdUMP-ada-spec-C ?

[Multiplayer1080]

I had not installed ada, i had the GNAT GPL version (thats was the problem). 
Also, there is full information about that in the Gnat User Guide (my fault)... so : SOLVED

I was confused :( 
thank you so much for your time!

Re: There is something wrong with using libpq5 with -FdUMP-ada-spec-C ?

[Dmitry A. Kazakov]

On Thu, 14 Mar 2013 11:58:15 -0700 (PDT), Multiplayer1080 wrote:

> I have seen that there is a possibility using Gnade, however it seems more
> difficult to use for me, since I have to build and install these tools,
> instead of using libraries and add them to my project. I'm in Debian

You can use ODBC to access a PostgreSQL DB. PostgreSQL fully supports ODBC.
For Ada ODBC bindings see

http://www.dmitry-kazakov.de/ada/components.htm#ODBC_Bindings

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de