If you see my orginal email,I mentioned to link to inc & lib for pgsql.Even when i use PQsetdb,I didn't recieve error message for using PQsetdb. Yours,Mohsen > > On Wed, 23 Feb 2005, Mohsen Pahlevanzadeh wrote: > >> My program is using both MySQL & PostgreSQL.I don't have problem with >> Mysql.But i have problem with pgsql. > > That could be because you don't appear to be linking to the PostgreSQL > libraries (as Richard was hinting at). > >> > Mohsen Pahlevanzadeh wrote: >> >> I recieve following error: >> >> [root@localhost sql2sql]# make >> >> g++ -c -I/usr/include/mysql -I/usr/include sql2sql.cpp; >> > ^^^^^^ >> >> g++ -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -L/usr/lib >> -o >> > ^^^^^ ^^^^^^^^^^^ >> > Those aren't going to help, are they? >> > >> > -- >> > Richard Huxton >> > Archonet Ltd >> > >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: Have you searched our list archives? >> >> http://archives.postgresql.org >> > ---------------------------(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