[postgis-users] AddGeometryColumn on VIEW?

[Burgholzer,Robert]

Jan,
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.


Robert

-----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

Jan
-- 
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
http://postgis.refractions.net/mailman/listinfo/postgis-users