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
