Great, Thank you for fixing this. Good to be able to contribute.
Andreas 2011/9/18 Paragon Corporation <[email protected]>: > Andreas, > I had forgotten to exclude raster_columns (fixed now), but the fundamental > problem was that > empty geometry tables weren't being handled correctly. I suspect > raster_columns was probably the only > empty table with a geometry column in your database. > > Should all be fixed now. > > Thanks for reporting, > Regina > http://www.postgis.us > > > > >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On >> Behalf Of Andreas Forø Tollefsen >> Sent: Sunday, September 18, 2011 2:07 AM >> To: PostGIS Users Discussion >> Subject: Re: [postgis-users] Populate_geometry_columns() problems >> >> Tonight I did a full reinstall of Ubuntu 11.04 and >> reinstalled the postgresql and postgis. >> "POSTGIS="2.0.0SVN" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, >> 23 September 2009" LIBXML="2.7.8" USE_STATS" >> This is also rev 7862. >> >> The same error exists, >> ERROR: query string argument of EXECUTE is null >> CONTEXT: PL/pgSQL function "populate_geometry_columns" line >> 53 at EXECUTE statement PL/pgSQL function >> "populate_geometry_columns" line 50 at assignment >> >> ********** Error ********** >> >> ERROR: query string argument of EXECUTE is null SQL state: 22004 >> Context: PL/pgSQL function "populate_geometry_columns" line >> 53 at EXECUTE statement PL/pgSQL function >> "populate_geometry_columns" line 50 at assignment >> >> while this works fine: >> select populate_geometry_columns('public.cshapes'::regclass); >> 0 >> >> 2011/9/17 Andreas Forø Tollefsen <[email protected]>: >> > Hi, >> > >> > This is a small database, and the populate_geometry_columns >> works for >> > all tables when i do them one at the time. >> > i.e. select >> populate_geometry_columns('public.cshapes'::regclass); returns 0. >> > >> > However running this just as a populate_geometry_columns(); >> produces the error. >> > >> > Just out of curiosity I tried with: >> > select populate_geometry_columns('public.raster_columns'::regclass); >> > which is not supposed to work? Or is it? >> > And this returned: >> > ERROR: query string argument of EXECUTE is null >> > CONTEXT: PL/pgSQL function "populate_geometry_columns" line 53 at >> > EXECUTE statement >> > >> > ********** Error ********** >> > >> > ERROR: query string argument of EXECUTE is null SQL state: 22004 >> > Context: PL/pgSQL function "populate_geometry_columns" line 53 at >> > EXECUTE statement >> > >> > Andreas >> > >> > 2011/9/18 Paragon Corporation <[email protected]>: >> >> Andreas, >> >> >> >> I'll take a look at this one tomorrow. Off the top of my >> head, I'm >> >> guessing you have an empty geometry table with no >> constraints on it >> >> so the routine can not guess what to set the constraints >> to. I'm not >> >> sure I guarded against that condition. >> >> >> >> Can you verify that doing populate_geometry_columns works for a >> >> single table >> >> >> >> E.g. >> >> >> >> SELECT populate_geometry_columns('public.mytable'::regclass); >> >> >> >> >> >> If you do see an empty table you can try the single call >> against that >> >> and I suspect it will fail. >> >> >> >> -----Original Message----- >> >> From: [email protected] >> >> [mailto:[email protected]] On >> Behalf Of >> >> Andreas Forø Tollefsen >> >> Sent: Saturday, September 17, 2011 8:39 PM >> >> To: PostGIS Users Discussion >> >> Subject: Re: [postgis-users] Populate_geometry_columns() problems >> >> >> >> Hi, >> >> This is revision 7862. >> >> Just tried updating through the svn respitory. >> >> select postgis_full_version(); returns >> >> postgis_full_version >> >> >> --------------------------------------------------------------------- >> >> ------- >> >> --------------------------------- >> >> POSTGIS="2.0.0SVN" GEOS="3.4.0dev-CAPI-1.8.0" PROJ="Rel. >> 4.7.1, 23 >> >> September 2009" LIBXML="2.7.7" USE_STATS >> >> (1 row) >> >> >> >> Still having the same issue: >> >> priogrid=# select populate_geometry_columns(); >> >> ERROR: query string argument of EXECUTE is null >> >> CONTEXT: PL/pgSQL function "populate_geometry_columns" line 53 at >> >> EXECUTE statement PL/pgSQL function >> "populate_geometry_columns" line >> >> 50 at assignment >> >> >> >> >> >> >> >> 2011/9/16 Sandro Santilli <[email protected]>: >> >>> On Thu, Sep 15, 2011 at 11:25:52PM +0200, Andreas Forø >> Tollefsen wrote: >> >>>> Hi all, >> >>>> >> >>>> Trying to do a populate_geometry_columns(); but it does not work. >> >>>> This is PostGis 2.0 with Gdal 1.8, Geos 3.4 >> >>> >> >>> Revision number ? >> >>> >> >>>> Command: SELECT Populate_Geometry_Columns(); >> >>>> ERROR: query string argument of EXECUTE is null >> >>>> CONTEXT: PL/pgSQL function "populate_geometry_columns" >> line 53 at >> >>>> EXECUTE statement PL/pgSQL function "populate_geometry_columns" >> >>>> line 50 at assignment >> >>>> >> >>>> Any ideas? >> >>> >> >>> Update to latest trunk revision, make sure to re-source >> postgis.sql, >> >>> try again. If the problem persists please file ticket. >> >>> >> >>> --strk; >> >>> >> >>> () Free GIS & Flash consultant/developer >> >>> /\ http://strk.keybit.net/services.html >> >>> _______________________________________________ >> >>> postgis-users mailing list >> >>> [email protected] >> >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >>> >> >> _______________________________________________ >> >> postgis-users mailing list >> >> [email protected] >> >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >> >> >> >> _______________________________________________ >> >> postgis-users mailing list >> >> [email protected] >> >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >> > >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
