[postgis-users] Populate_geometry_columns() problems

[Andreas Forø Tollefsen]

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
>