Re: Problema C++, libqxx y postgresql

tengo ese mismo problema me gustaria saber si lo resolviste
?

2006/10/17, Espartano <espartano(dot)mail(at)gmail(dot)com>:
>
> On 10/17/06, Andres Jaramillo <anjarami(at)gmail(dot)com> wrote:
> > Hola a tdos y gracias por leerme a ver si alguien me puede ayudar.
> >
> > Tengo el problema de q no logro conectarme a postgresql con libqxx,
> > tengo este archivo de prueba
> >
> > --------
> >
> > #include <iostream>
> > #include <pqxx/pqxx>
> >
> > using namespace std;
> > using namespace pqxx;
> >
> > int main()
> > {
> > connection C;
> > return 0;
> > }
> >
> > ---------
> >
> > ya con eso me saca cualquier cantidad de errores q pego al final del
> mensaje...
> >
> > tengo instalado postgresql 8.0 en /usr/local/pgsql/ en una maquina
> > centos 4.3 compilo mi programa asi g++ test001.cpp -o test001 la
> > version del compilador g++ (GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
> >
> > La verdad no se ni como decirle a libqxx cual es la base de datos y el
> > usuario lo raro es q cuando compile libqxx corri los test y pasaron
> > menos 4 y son como 70.
> >
> > gracias...
> >
> >
> > Los errores del compildor son los siguientes:
> >
> > test001.cpp:38:2: warning: no newline at end of file
> > /tmp/ccB3GImH.o(.text+0x145): In function `main':
> > : undefined reference to `pqxx::connection_base::dbname()'
> > /tmp/ccB3GImH.o(.text+0x1c5): In function `main':
> > : undefined reference to `pqxx::transaction_base::exec(char const*,
> > std::basic_string<char, std::char_traits<char>, std::allocator<char> >
> > const&)'
> > /tmp/ccB3GImH.o(.text+0x239): In function `main':
> > : undefined reference to `pqxx::result::size() const'
> > /tmp/ccB3GImH.o(.text+0x426): In function `main':
> > : undefined reference to `pqxx::transaction_base::exec(char const*,
> > std::basic_string<char, std::char_traits<char>, std::allocator<char> >
> > const&)'
> > /tmp/ccB3GImH.o(.text+0x4ab): In function `main':
> > : undefined reference to `pqxx::transaction_base::commit()'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZNK4pqxx6result5field5c_strEv+0x34):
> > In function `pqxx::result::field::c_str() const':
> > : undefined reference to `pqxx::result::GetValue(unsigned long,
> > unsigned int) const'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZNK4pqxx6result3endEv+0x14): In
> > function `pqxx::result::end() const':
> > : undefined reference to `pqxx::result::size() const'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx8internal7PQAllocI9pg_resultED2Ev+0x1f):
> > In function `pqxx::internal::PQAlloc<pg_result>::~PQAlloc()':
> > : undefined reference to `pqxx::internal::refcount::~refcount()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx16basic_connectionINS_14connect_directEEC1Ev+0x15):
> > In function
> `pqxx::basic_connection<pqxx::connect_direct>::basic_connection()':
> > : undefined reference to
> > `pqxx::connection_base::connection_base(pqxx::connectionpolicy&)'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx16basic_connectionINS_14connect_directEEC1Ev+0x4e):
> > In function
> `pqxx::basic_connection<pqxx::connect_direct>::basic_connection()':
> > : undefined reference to `pqxx::connection_base::init()'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx14connect_directD1Ev+0xb): In
> > function `pqxx::connect_direct::~connect_direct()':
> > : undefined reference to `vtable for pqxx::connect_direct'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx14connect_directD1Ev+0x16): In
> > function `pqxx::connect_direct::~connect_direct()':
> > : undefined reference to `pqxx::connectionpolicy::~connectionpolicy()'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx14connect_directC1ERKSs+0x10):
> > In function
> `pqxx::connect_direct::connect_direct(std::basic_string<char,
> > std::char_traits<char>, std::allocator<char> > const&)':
> > : undefined reference to
> > `pqxx::connectionpolicy::connectionpolicy(std::basic_string<char,
> > std::char_traits<char>, std::allocator<char> > const&)'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx14connect_directC1ERKSs+0x1c):
> > In function
> `pqxx::connect_direct::connect_direct(std::basic_string<char,
> > std::char_traits<char>, std::allocator<char> > const&)':
> > : undefined reference to `vtable for pqxx::connect_direct'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx16basic_connectionINS_14connect_directEED1Ev+0xf):
> > In function
> `pqxx::basic_connection<pqxx::connect_direct>::~basic_connection()':
> > : undefined reference to `pqxx::connection_base::close()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx11transactionILNS_15isolation_levelE0EEC1ERNS_15connection_baseE+0x9c):
> > In function
> `pqxx::transaction<(pqxx::isolation_level)0>::transaction(pqxx::connection_base&)':
> > : undefined reference to
> > `pqxx::dbtransaction::fullname(std::basic_string<char,
> > std::char_traits<char>, std::allocator<char> > const&,
> > std::basic_string<char, std::char_traits<char>, std::allocator<char> >
> > const&)'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx11transactionILNS_15isolation_levelE0EEC1ERNS_15connection_baseE+0x228):
> > In function
> `pqxx::transaction<(pqxx::isolation_level)0>::transaction(pqxx::connection_base&)':
> > : undefined reference to
> > `pqxx::basic_transaction::basic_transaction(pqxx::connection_base&,
> > std::basic_string<char, std::char_traits<char>, std::allocator<char> >
> > const&)'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx11transactionILNS_15isolation_levelE0EEC1ERNS_15connection_baseE+0x296):
> > In function
> `pqxx::transaction<(pqxx::isolation_level)0>::transaction(pqxx::connection_base&)':
> > : undefined reference to `pqxx::transaction_base::Begin()'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx17basic_transactionD2Ev+0x1e):
> > In function `pqxx::basic_transaction::~basic_transaction()':
> > : undefined reference to `pqxx::dbtransaction::~dbtransaction()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx11transactionILNS_15isolation_levelE0EED1Ev+0x17):
> > In function
> `pqxx::transaction<(pqxx::isolation_level)0>::~transaction()':
> > : undefined reference to `pqxx::transaction_base::End()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx8internal7PQAllocI9pg_resultE7loserefEv+0x11):
> > In function`pqxx::internal::PQAlloc<pg_result>::loseref()':
> > : undefined reference to `pqxx::internal::refcount::loseref()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx8internal7PQAllocI9pg_resultE7freememEv+0xf):
> > In function `pqxx::internal::PQAlloc<pg_result>::freemem()':
> > : undefined reference to `pqxx::internal::freemem_result(pg_result*)'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTVN4pqxx11transactionILNS_15isolation_levelE0EEE+0x14):
> > undefined reference to `pqxx::dbtransaction::do_begin()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTVN4pqxx11transactionILNS_15isolation_levelE0EEE+0x18):
> > undefined reference to `pqxx::dbtransaction::do_exec(char const*)'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTVN4pqxx11transactionILNS_15isolation_levelE0EEE+0x1c):
> > undefined reference to `pqxx::basic_transaction::do_commit()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTVN4pqxx11transactionILNS_15isolation_levelE0EEE+0x20):
> > undefined reference to `pqxx::dbtransaction::do_abort()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_17basic_transactionE+0x8):
> > undefined reference to `typeinfo for pqxx::basic_transaction'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_17basic_transactionE+0x14):
> > undefined reference to `pqxx::dbtransaction::do_begin()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_17basic_transactionE+0x18):
> > undefined reference to `pqxx::dbtransaction::do_exec(char const*)'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_17basic_transactionE+0x1c):
> > undefined reference to `pqxx::basic_transaction::do_commit()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_17basic_transactionE+0x20):
> > undefined reference to `pqxx::dbtransaction::do_abort()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_13dbtransactionE+0x8):
> > undefined reference to `typeinfo for pqxx::dbtransaction'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_13dbtransactionE+0xc):
> > undefined reference to `pqxx::dbtransaction::~dbtransaction()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_13dbtransactionE+0x10):
> > undefined reference to `pqxx::dbtransaction::~dbtransaction()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_13dbtransactionE+0x14):
> > undefined reference to `pqxx::dbtransaction::do_begin()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_13dbtransactionE+0x18):
> > undefined reference to `pqxx::dbtransaction::do_exec(char const*)'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTCN4pqxx11transactionILNS_15isolation_levelE0EEE0_NS_13dbtransactionE+0x20):
> > undefined reference to `pqxx::dbtransaction::do_abort()'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx17basic_transactionD0Ev+0xa):
> > In function `pqxx::basic_transaction::~basic_transaction()':
> > : undefined reference to `vtable for pqxx::basic_transaction'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx17basic_transactionD0Ev+0x14):
> > In function `pqxx::basic_transaction::~basic_transaction()':
> > : undefined reference to `VTT for pqxx::basic_transaction'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx17basic_transactionD0Ev+0x20):
> > In function `pqxx::basic_transaction::~basic_transaction()':
> > : undefined reference to `pqxx::dbtransaction::~dbtransaction()'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx17basic_transactionD1Ev+0xa):
> > In function `pqxx::basic_transaction::~basic_transaction()':
> > : undefined reference to `vtable for pqxx::basic_transaction'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx17basic_transactionD1Ev+0x14):
> > In function `pqxx::basic_transaction::~basic_transaction()':
> > : undefined reference to `VTT for pqxx::basic_transaction'
> > /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx17basic_transactionD1Ev+0x20):
> > In function `pqxx::basic_transaction::~basic_transaction()':
> > : undefined reference to `pqxx::dbtransaction::~dbtransaction()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.t._ZN4pqxx11transactionILNS_15isolation_levelE0EED0Ev+0x17):
> > In function
> `pqxx::transaction<(pqxx::isolation_level)0>::~transaction()':
> > : undefined reference to `pqxx::transaction_base::End()'
> >
> /tmp/ccB3GImH.o(.gnu.linkonce.r._ZTIN4pqxx11transactionILNS_15isolation_levelE0EEE+0x8):
> > undefinedreference to `typeinfo for pqxx::basic_transaction'
> > collect2: ld returned 1 exit status
> >
> >
> >
>
>
> Como estas compilando ? que yo recuerde tienes que espesificar la
> libreria de libpq con -lpq
>
> podrias ver esta pparte del manual
> http://www.postgresql.org/docs/8.0/interactive/libpq.html
>
> --
> http://espartano.linuxreal.org/blog/html/index.php
>
> ---------------------------(fin del mensaje)---------------------------
> TIP 4: No hagas 'kill -9' a postmaster
>