[postgis-users] Populate_geometry_columns() problems

[Paragon Corporation]

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