Re: Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation

O mas interesante aun, como se llama la tabla realmente en la base de datos?... prueba o
Prueba?...

On Mar 04 Ago 2009 11:38:01 felipe fernandez escribió:
> La tabla PRUEBA no existe en tu base de datos
>
> El 4 de agosto de 2009 17:06, Rhyno Elmer <rhynos(at)gmail(dot)com> escribió:
> > ya y eso que significa?? eso es lo que no entiendo, hice pruebas con
> > varias tipos de conexiones y siempre me aparece ese error.. que es lo que
> > esta malo???
> >
> > On Tue, Aug 4, 2009 at 12:03 PM, felipe fernandez <ffdezrguez(at)gmail(dot)com>wrote:
> >> Query failed: ERROR: relation "prueba" does not exist
> >>
> >> El 4 de agosto de 2009 17:03, Rhyno Elmer <rhynos(at)gmail(dot)com> escribió:
> >>
> >> Si esta mal la llamada a la conexion pero ese no es problema, porque me
> >>
> >>> arroja los mismos errores, es como que no reconociera las fucncioes
> >>> propias de Postgre.
> >>> *Warning*: pg_exec()
> >>> [function.pg-exec<http://localhost/tic/function.pg-exec>]: Query
> >>> failed: ERROR: relation "prueba" does not exist in *
> >>> D:\htdocs\tic\index.php* on line *6*
> >>>
> >>> *Warning*: pg_numrows(): supplied argument is not a valid PostgreSQL
> >>> result resource in *D:\htdocs\tic\index.php* on line *7*
> >>> Number of rows:
> >>> *Warning*: pg_freeresult(): supplied argument is not a valid PostgreSQL
> >>> result resource in *D:\htdocs\tic\index.php* on line *8*
> >>>
> >>> *Warning*: pg_close(): supplied argument is not a valid PostgreSQL link
> >>> resource in *D:\htdocs\tic\index.php* on line *9*
> >>>
> >>> On Tue, Aug 4, 2009 at 11:57 AM, felipe fernandez <ffdezrguez(at)gmail(dot)com>wrote:
> >>>> $result = pg_exec($bdconn , $query);
> >>>>
> >>>> El 4 de agosto de 2009 16:53, Rhyno Elmer <rhynos(at)gmail(dot)com> escribió:
> >>>>
> >>>> Buenas.
> >>>>
> >>>>> No entiendo mucho Postgre, trabajo en MySql y necesito pasar un
> >>>>> sistema a Postgre, tengo instalado todo bien, tengo la conexion bien
> >>>>> hecha, pero al tratar de hacer una conexion con mi BD me tira un
> >>>>> error.
> >>>>>
> >>>>> *Warning*: pg_exec(): supplied argument is not a valid PostgreSQL
> >>>>> link resource in *D:\htdocs\tic\index.php* on line *6*
> >>>>> *Warning*: pg_numrows(): supplied argument is not a valid PostgreSQL
> >>>>> result resource in *D:\htdocs\tic\index.php* on line *7*
> >>>>> Number of rows:
> >>>>> *Warning*: pg_freeresult(): supplied argument is not a valid
> >>>>> PostgreSQL result resource in *D:\htdocs\tic\index.php* on line *8*
> >>>>> *Warning*: pg_close(): supplied argument is not a valid PostgreSQL
> >>>>> link resource in *D:\htdocs\tic\index.php* on line *9**
> >>>>>
> >>>>> *Mi BD tiene dos usuarios, postgres y consultas, los dos con todos
> >>>>> los Privilegios. Si me pudieran orientar sobre esto se agradeceria.
> >>>>>
> >>>>> Los php con cual estoy trabajando son los siguientes:
> >>>>>
> >>>>> connect.php
> >>>>> <?
> >>>>> $bdconn = pg_connect("host=localhost dbname=template1 port=5432
> >>>>> user=consultas password=XXXX");
> >>>>> if (pg_ErrorMessage($bdconn)) { echo "<p><b>Error conectando a la
> >>>>> base de datos: .</b></p>"; exit; }
> >>>>> ?>
> >>>>>
> >>>>> index.php
> >>>>> <?
> >>>>>
> >>>>> include('connect.php');
> >>>>>
> >>>>> $query = "SELECT * FROM prueba";
> >>>>> $result = pg_exec($db_handle, $query);
> >>>>> echo "Number of rows: " . pg_numrows($result);
> >>>>> pg_freeresult($result);
> >>>>> pg_close($db_handle);
> >>>>>
> >>>>> ?>
> >>>>>
> >>>>> Rhynos
> >>>>
> >>>> --
> >>>> Salu2
> >>>>
> >>>>
> >>>> Felipe Fernández
> >>>> "Linux is for people who hate Windows,
> >>>> Debian is for people who love Linux,".
> >>>>
> >>>> "Documentation is like sex: when it is good, it is very, very good;
> >>>> and when it is bad, it is better than nothing."
> >>
> >> --
> >> Salu2
> >>
> >>
> >> Felipe Fernández
> >> "Linux is for people who hate Windows,
> >> Debian is for people who love Linux,".
> >>
> >> "Documentation is like sex: when it is good, it is very, very good; and
> >> when it is bad, it is better than nothing."

--
Santiago Zarate
santiago(at)zarate(dot)net(dot)ve
(+58) 4129864175
(+58) 4241073905