[postgis-users] Populate_geometry_columns() problems

[Andreas Forø Tollefsen]

Great,

Thank you for fixing this.
Good to be able to contribute.

Andreas

2011/9/18 Paragon Corporation <lr at pcorp.us>:
> 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
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>