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

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."
>>
>
>

--
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."