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 <rhy...@gmail.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 > > <ffdezrg...@gmail.com>wrote: > >> Query failed: ERROR: relation "prueba" does not exist > >> > >> El 4 de agosto de 2009 17:03, Rhyno Elmer <rhy...@gmail.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 > >>> <ffdezrg...@gmail.com>wrote: > >>>> $result = pg_exec($bdconn , $query); > >>>> > >>>> El 4 de agosto de 2009 16:53, Rhyno Elmer <rhy...@gmail.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 santi...@zarate.net.ve (+58) 4129864175 (+58) 4241073905
signature.asc
Description: This is a digitally signed message part.
