I am getting Undefined symbols in build ecpg


gmake -C compatlib all
gmake[4]: Entering directory `/usr/local/postgres/pgsql/src/interfaces/ecpg/compatlib'
../../../../src/backend/port/aix/mkldexport.sh libecpg_compat.a > libecpg_compat.exp
gcc -O2 -pipe -Wall -Wmissing-prototypes -Wmissing-declarations  -Wl,-bnoentry -Wl,-H512 -Wl,-bM:SRE -o libecpg_compat.so libecpg_compat.a -L../../../../src/port -L/usr/local/ssl/lib -lm -lssl -lcrypto  -L/usr/local/ssl/lib  -L../../../../src/port -L/usr/local/ssl/lib -L/usr/local/ssl/lib -L../pgtypeslib -lpgtypes -L../ecpglib -lecpg   -Wl,-bI:../../../../src/backend/postgres.imp -Wl,-bE:libecpg_compat.exp
ld: 0711-224 WARNING: Duplicate symbol: .ParseDateTime
ld: 0711-224 WARNING: Duplicate symbol: .DecodeUnits
ld: 0711-224 WARNING: Duplicate symbol: .date2j
ld: 0711-224 WARNING: Duplicate symbol: .j2date
ld: 0711-224 WARNING: Duplicate symbol: .j2day
ld: 0711-224 WARNING: Duplicate symbol: .EncodeDateOnly
ld: 0711-224 WARNING: Duplicate symbol: .EncodeDateTime
ld: 0711-224 WARNING: Duplicate symbol: .GetEpochTime
ld: 0711-224 WARNING: Duplicate symbol: .GetCurrentDateTime
ld: 0711-224 WARNING: Duplicate symbol: .DecodeDateTime
ld: 0711-224 WARNING: Duplicate symbol: months
ld: 0711-224 WARNING: Duplicate symbol: days
ld: 0711-224 WARNING: Duplicate symbol: .tm2timestamp
ld: 0711-224 WARNING: Duplicate symbol: .DecodeInterval
ld: 0711-224 WARNING: Duplicate symbol: .EncodeInterval
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
ld: 0711-317 ERROR: Undefined symbol: .PQfinish
ld: 0711-317 ERROR: Undefined symbol: .PQexec
ld: 0711-317 ERROR: Undefined symbol: .PQclear
ld: 0711-317 ERROR: Undefined symbol: .PQresultErrorField
ld: 0711-317 ERROR: Undefined symbol: .PQsetdbLogin
ld: 0711-317 ERROR: Undefined symbol: .PQstatus
ld: 0711-317 ERROR: Undefined symbol: .PQsetNoticeReceiver
ld: 0711-317 ERROR: Undefined symbol: .PQerrorMessage
ld: 0711-317 ERROR: Undefined symbol: .last_path_separator
collect2: ld returned 8 exit status
gmake[4]: *** [libecpg_compat.so] Error 1
gmake[4]: Leaving directory `/usr/local/postgres/pgsql/src/interfaces/ecpg/compatlib'


horwitz@argoscomp.com (Samuel A Horwitz)



Tue, 23 Sep 2003 16:21:10 -0400 (EDT)
Samuel A Horwitz <horwitz@argoscomp.com>
ecpg build on AIX 4.2.1
On Tue, Sep 23, 2003 at 04:21:10PM -0400, Samuel A Horwitz wrote:
> I am getting Undefined symbols in build ecpg
>...
> ld: 0711-317 ERROR: Undefined symbol: .PQfinish
> ld: 0711-317 ERROR: Undefined symbol: .PQexec
> ld: 0711-317 ERROR: Undefined symbol: .PQclear
> ld: 0711-317 ERROR: Undefined symbol: .PQresultErrorField
> ld: 0711-317 ERROR: Undefined symbol: .PQsetdbLogin
> ld: 0711-317 ERROR: Undefined symbol: .PQstatus
> ld: 0711-317 ERROR: Undefined symbol: .PQsetNoticeReceiver
> ld: 0711-317 ERROR: Undefined symbol: .PQerrorMessage
> ld: 0711-317 ERROR: Undefined symbol: .last_path_separator
> collect2: ld returned 8 exit status
> gmake[4]: *** [libecpg_compat.so] Error 1
> gmake[4]: Leaving directory `/usr/local/postgres/pgsql/src/interfaces/ecpg/compatlib'

Looks like a missing "-lpq" but i wonder why you get it in compatlib. No
libpq function is called there directly.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

Wed, 24 Sep 2003 09:51:13 +0200
Michael Meskes <meskes@postgresql.org>
Re: ecpg build on AIX 4.2.1
Michael Meskes wrote:
> On Tue, Sep 23, 2003 at 04:21:10PM -0400, Samuel A Horwitz wrote:
> 
>>I am getting Undefined symbols in build ecpg
>>...
>>ld: 0711-317 ERROR: Undefined symbol: .PQfinish
>>ld: 0711-317 ERROR: Undefined symbol: .PQexec
>>ld: 0711-317 ERROR: Undefined symbol: .PQclear
>>ld: 0711-317 ERROR: Undefined symbol: .PQresultErrorField
>>ld: 0711-317 ERROR: Undefined symbol: .PQsetdbLogin
>>ld: 0711-317 ERROR: Undefined symbol: .PQstatus
>>ld: 0711-317 ERROR: Undefined symbol: .PQsetNoticeReceiver
>>ld: 0711-317 ERROR: Undefined symbol: .PQerrorMessage
>>ld: 0711-317 ERROR: Undefined symbol: .last_path_separator
>>collect2: ld returned 8 exit status
>>gmake[4]: *** [libecpg_compat.so] Error 1
>>gmake[4]: Leaving directory `/usr/local/postgres/pgsql/src/interfaces/ecpg/compatlib'
> 
> 
> Looks like a missing "-lpq" but i wonder why you get it in compatlib. No
> libpq function is called there directly.
> 
> Michael


Correct.
I had the same error on AIX 5.1 last week (see hackers' list).
As far as 7.4beta is referred two additional patches are needed (see 
postings by Tom Lane on this topics).

Adding the linker options will solve your problems and PostgreSQL will 
work nicely.

	Regards,

		Hans


-- 
Cybertec Geschwinde u Schoenig
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/2952/30706; +43/660/816 40 77
www.cybertec.at, www.postgresql.at, kernel.cybertec.at



Wed, 24 Sep 2003 13:18:32 +0200
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres@cybertec.at>
Re: ecpg build on AIX 4.2.1
Are these patches going to be applied soon?


On Wed, 24 Sep 2003,
[ISO-8859-1] Hans-J�rgen Sch�nig wrote:

> Date: Wed, 24 Sep 2003 13:18:32 +0200
> From: "[ISO-8859-1] Hans-J�rgen Sch�nig" <postgres@cybertec.at>
> To: Michael Meskes <meskes@postgresql.org>
> Cc: Samuel A Horwitz <horwitz@argoscomp.com>,
>      PostgreSQL Hackers <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] ecpg build on AIX 4.2.1
> 
> Michael Meskes wrote:
> > On Tue, Sep 23, 2003 at 04:21:10PM -0400, Samuel A Horwitz wrote:
> > 
> >>I am getting Undefined symbols in build ecpg
> >>...
> >>ld: 0711-317 ERROR: Undefined symbol: .PQfinish
> >>ld: 0711-317 ERROR: Undefined symbol: .PQexec
> >>ld: 0711-317 ERROR: Undefined symbol: .PQclear
> >>ld: 0711-317 ERROR: Undefined symbol: .PQresultErrorField
> >>ld: 0711-317 ERROR: Undefined symbol: .PQsetdbLogin
> >>ld: 0711-317 ERROR: Undefined symbol: .PQstatus
> >>ld: 0711-317 ERROR: Undefined symbol: .PQsetNoticeReceiver
> >>ld: 0711-317 ERROR: Undefined symbol: .PQerrorMessage
> >>ld: 0711-317 ERROR: Undefined symbol: .last_path_separator
> >>collect2: ld returned 8 exit status
> >>gmake[4]: *** [libecpg_compat.so] Error 1
> >>gmake[4]: Leaving directory `/usr/local/postgres/pgsql/src/interfaces/ecpg/compatlib'
> > 
> > 
> > Looks like a missing "-lpq" but i wonder why you get it in compatlib. No
> > libpq function is called there directly.
> > 
> > Michael
> 
> 
> Correct.
> I had the same error on AIX 5.1 last week (see hackers' list).
> As far as 7.4beta is referred two additional patches are needed (see 
> postings by Tom Lane on this topics).
> 
> Adding the linker options will solve your problems and PostgreSQL will 
> work nicely.
> 
> 	Regards,
> 
> 		Hans
> 
> 
> -- 
> Cybertec Geschwinde u Schoenig
> Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
> Tel: +43/2952/30706; +43/660/816 40 77
> www.cybertec.at, www.postgresql.at, kernel.cybertec.at
> 
> 


horwitz@argoscomp.com (Samuel A Horwitz)



Wed, 24 Sep 2003 09:49:49 -0400 (EDT)
Samuel A Horwitz <horwitz@argoscomp.com>
Re: ecpg build on AIX 4.2.1
Samuel A Horwitz wrote:
> Are these patches going to be applied soon?
> 
> 
>>Correct.
>>I had the same error on AIX 5.1 last week (see hackers' list).
>>As far as 7.4beta is referred two additional patches are needed (see 
>>postings by Tom Lane on this topics).
>>
>>Adding the linker options will solve your problems and PostgreSQL will 
>>work nicely.
>>
>>	Regards,
>>
>>		Hans


puh, good question.
I think I have seen that Tom has applied at least one. I think the one 
you have requested has not been applied yet.
You have to check the COMMITTERS' list to find out. To be honest I don't 
have it in mind. Tom or Michael Meskes will know for sure.

	Regards,
	
		Hans

-- 
Cybertec Geschwinde u Schoenig
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/2952/30706; +43/660/816 40 77
www.cybertec.at, www.postgresql.at, kernel.cybertec.at



Wed, 24 Sep 2003 16:32:57 +0200
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres@cybertec.at>
Re: ecpg build on AIX 4.2.1
On Wed, Sep 24, 2003 at 01:18:32PM +0200, Hans-Jürgen Schönig wrote:
> Correct.
> I had the same error on AIX 5.1 last week (see hackers' list).
> As far as 7.4beta is referred two additional patches are needed (see 
> postings by Tom Lane on this topics).

So adding $(filter -lssl -lm) does fix this? 

> Adding the linker options will solve your problems and PostgreSQL will 
> work nicely.

Probably in the same manner.

I'm sorry, I didn't see the other mails. They simply got lost in that
virus flood happening these days.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

Wed, 24 Sep 2003 18:13:51 +0200
Michael Meskes <meskes@postgresql.org>
Re: ecpg build on AIX 4.2.1