2009/10/27 André Mendonça <[email protected]>: > 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?
Perhaps your php db connection has auto commit turned off, so you have to explicitly COMMIT after INSERT. > 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! > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= Sent from Madison, WI, United States _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
