La tabla PRUEBA no existe en tu base de datos El 4 de agosto de 2009 17:06, Rhyno Elmer <[email protected]> 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 <[email protected]>wrote: > >> Query failed: ERROR: relation "prueba" does not exist >> >> El 4 de agosto de 2009 17:03, Rhyno Elmer <[email protected]> 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 >>> <[email protected]>wrote: >>> >>>> $result = pg_exec($bdconn , $query); >>>> >>>> El 4 de agosto de 2009 16:53, Rhyno Elmer <[email protected]> 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." >> > > -- 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."
