From: | felipe fernandez <ffdezrguez(at)gmail(dot)com> |
---|---|
To: | Rhyno Elmer <rhynos(at)gmail(dot)com> |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation |
Date: | 2009-08-04 15:57:13 |
Message-ID: | f50088cd0908040857n45e0ab86tadd50be153d9adaf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
$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."
From | Date | Subject | |
---|---|---|---|
Next Message | Sergio Gabriel Rodriguez | 2009-08-04 16:06:45 | Re: Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation |
Previous Message | Rhyno Elmer | 2009-08-04 15:53:01 | Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation |