[postgis-users] pg_query to insert new point

[nicklas.aven at jordogskog.no]

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 agora, é grátis!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091027/84faed6c/attachment.html>