We tried but seems this didn't solve the problem.
Actually the ldd command in the log I attached yesterday has showed the link to the right libecpgtypes.so and libpg.so.
Adding the -lecpgtypes and -l libpg in build did not change anything.
It looks to us that the sqlca.sqlcode will never be set to non-zero value when SQL errors, warnings, not_found happen.
Gan
At 4:09 pm +0100 2003/12/11, Michael Meskes wrote:
On Wed, Dec 10, 2003 at 03:29:44PM -0600, Seum-Lim Gan wrote:/platdb/bin/ecpg -I /platdb/include -o dyntest74.c dyntest.pgc cc -I/platdb/include -R/platdb/lib -L/platdb/lib -lecpg -o lucyDyntest74 dyntest74.c
This looks like a wrong library. The latest ecpg does need more that libecpg. It also needs libpgtypes. Since you don't include this i wonder if you link against an older libecpg.
Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
-- +--------------------------------------------------------+ | Seum-Lim GAN email : [EMAIL PROTECTED] | | Lucent Technologies | | 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 | | Naperville, IL 60566, USA. fax : (630)-713-7272 | | web : http://inuweb.ih.lucent.com/~slgan | +--------------------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
