[postgis-users] pg_query to insert new point

[Paragon Corporation]

André ,
You could also output the error right on the php page by trapping it along
the lines of
 
http://www.php.net/manual/en/function.pg-result-error.php
 
Personally - I tend to use an abstraction layer like PHP ADODB or PEAR.   It
makes your code a bit more portable, and also much less to remember about
the nuances of connecting
 
http://www.postgresonline.com/journal/index.php?/archives/42-REST-in-Postgre
SQL-Part-2-B-The-REST-Server-service-with-PHP-5.html#extended
 
Hope that helps,
Regina

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Moen,
Paul T.
Sent: Tuesday, October 27, 2009 9:18 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] pg_query to insert new point


Try to look at the web server error logs as well.  On unix they are usually
in /var/log/apache2/ or /var/log/httpd/ and named error_log or error.log.  I
don't know where they are on windows systems, but maybe someone else could
point you in the right location.  You could also use pg_last_error ($con);
or pg_last_notice($con); to see the last error that would have been written
to the log.   

Paul 



On Oct 27, 2009, at 2:33 AM, <nicklas.aven at jordogskog.no>
<nicklas.aven at jordogskog.no> wrote:


It might be that the webserver don't have authentication to access the
database.
That is controlled from the file pg_hba.conf in the data-directory in the
postgresql installation.
You should also check the file postgresql.conf in the same directory. At
least if the webserver is on another machine than postgresql you have to
change the line about listen_addresses so it looks like:
listen_addresses = '*'
if you want to let all ip-addresses in.
 
I don't know the details herer, but it might help you continue digging :-)
 
/Nicklas

2009-10-27 André Mendonça wrote:

Hi everyone, first e-mail here.
>I´m trying to insert a new point to a simple table called processos in a
postgis database, using php, in a local server, with apache 2.2, php 5.2.12,
postgre 8.3 and postgis 1.4.
>
>here is the piece of code:
>
>$sql = "INSERT INTO processos (id, the_geom) VALUES
(1,(ST_PointFromText('POINT(-2 -62)',4291)))";
>pg_query($con, $sql);
>
>
>
>
>I can observe (with pg_affected_rows) there´s no new record.
>
>Executing the same query directly in pgsql, with the same database user,
returns a successfully result. 
>
>Any ideas on what´s wrong? I had never done any queries using php before,
is there a way to see an error message when executing this kind of
server-side request? tried firebug console but there´s nothing going on
there...
>
>Thanks a lot!
>
>André Mendonça
>Universidade Federal do Paraná
>Curitiba - BR
>
>
>
>
  _____  

Com o Novo Internet Explorer 8 suas abas se organizam por cor. Baixe
<http://brasil.microsoft.com.br/IE8/mergulhe/?utm_source=MSN%3BHotmail&utm_m
edium=Tagline&utm_campaign=IE8> agora, é grátis! 
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4547 (20091027) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091027/f08607da/attachment.html>