[postgis-users] AddGeometryColumn on VIEW?

Burgholzer,Robert rwburgholzer at deq.virginia.gov
Mon Jul 2 11:07:11 PDT 2007

I have always done a manual insert into the geometry_columns table. I don't know if this is "right", but it works. I have also had some versions of mapserver that want an OID column, so you may want to include that in your view if it is not already there.


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Jan Peters
Sent: Monday, July 02, 2007 1:26 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] AddGeometryColumn on VIEW?

Hello list,
I just tried to load a PostGIS VIEW in mapserver (which worked already with another VIEW). Mapserver repsonded that there was no SRID information. Investigating on this I found that the geometry_columns table did not contain the information regarding this view, so I tried a 

SELECT AddGeometryColumn('public', 'v_iis_map_2007_07_2_18105984', 'the_geom', -1, 'POINT', 2);

on my view and my client responded, that v_iis_map_2007_07_2_18105984 wasn't a table and quit with an error. The view exists, btw, I checked that with a SELECT statement. As I said, I already have information on other VIEWs in that geometry_columns table, so I was wondering how the syntax looked like, when I added the columns for those views a few month ago...

Could anybody point me to the correct way of doing this? Is there maybe a way of pointing all my temporary views to one row in the geometry_columns table (from mapserver), because the structure of the views (i.e. there columns) do not change, just the rows?

Thanks in advance

Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kanns mit allen: http://www.gmx.net/de/go/multimessenger
postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list