[postgis-users] Populate_geometry_columns() problems

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] 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 <andreasft at gmail.com>:
> > 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 <lr at pcorp.us>:
> >> 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: postgis-users-bounces at postgis.refractions.net
> >> [mailto:postgis-users-bounces at postgis.refractions.net] 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 <strk at keybit.net>:
> >>> 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
> >>> postgis-users at postgis.refractions.net
> >>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>