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: [email protected] [mailto:[email protected]] 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, <[email protected]> <[email protected]> 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 [email protected] 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
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
