Ah, thank you very much! I think I understand now. Best regards,
Mark Lidstone Tel: +44 (0)23 80232222; Fax: +44 (0)23 80232891 BMT Cordah Ltd Grove House 7 Ocean Way Ocean Village Southampton SO14 3TJ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of SAIG - Listas Sent: 08 August 2008 10:45 To: PostGIS Users Discussion Subject: Re: [postgis-users] Geometry column does not exist? Good morning Mark. Try to put the Location column name between "" as the next: insert into BathingArea (ID, Name, "Location") values ('Bathingarea_A', 'Bathing area A', GeomFromText('POLYGON((0.0 10.0,8.66 -5.0, -8.66 -5.0,0.0 10.0))',4326)); When you added the geometry column you indicated that the location column must be Location, with the l in uppercase. You must use then "Location" to refer to this column in your queries. Hope this helps, Mark Lidstone escribió: > Hi all, > > I've just spent about an hour looking for some help on this problem, > but I can't find anything useful. Hopefully, someone on here might be > able to help? > > I'm trying to create a simple table with geographic content, so I'm > doing the following: > > create table BathingArea (ID varchar(30) not null primary key, Name > varchar(256) not null); > select AddGeometryColumn('bathingarea','Location',4326,'POLYGON',2); > > Everything works fine and "select * from bathingarea;" shows the > Location field (albeit with no rows in the table) and "select * from > geometry_columns;" shows an entry pointing at the new column. > > Next I try to populate the table with a sample record: > > insert into BathingArea (ID, Name, Location) > values ('Bathingarea_A', 'Bathing area A', > GeomFromText('POLYGON((0.0 > 10.0,8.66 -5.0, -8.66 -5.0,0.0 10.0))',4326)); > > But I get the following error: > > ERROR: column "location" of relation "bathingarea" does not exist. > > I'm running on PostgreSQL 8.3.3 with PostGIS 1.3.3 under Windows. > > Could someone please tell me how stupid I'm being and how to get this > working? > > Many thanks, > > Mark Lidstone > Tel: +44 (0)23 80232222; Fax: +44 (0)23 80232891 > > BMT Cordah Ltd > Grove House > 7 Ocean Way > Ocean Village > Southampton > SO14 3TJ > > > > BMT Cordah Ltd. > A member of the BMT group of companies Registered Office: Investment > House, 6 Union Row, Aberdeen AB10 1DQ Registered in Scotland No. > 163413 http://www.bmtcordah.com/ http://www.bmt.org/ > > The contents of this e-mail and any attachments are intended only for the use > of the e-mail addressee(s) shown. If you are not that person, or one of those > persons, you are not allowed to take any action based upon it or to copy it, > forward, distribute or disclose the contents of it and you should please > delete it from your system. BMT Cordah Limited does not accept liability for > any errors or omissions in the context of this e-mail or its attachments, > which arise as a result of Internet transmission, nor accept liability for > statements which are those of the author and not clearly made on behalf of > BMT Cordah Limited. > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > -- Sergio Baños Calvo Jefe de desarrollos Sistemas Abiertos de Información Geográfica, S.L. (SAIG S.L.) Tlfno. móvil: 685005960 Tlfno. fijo: (+34) 954788876 E-mail: [EMAIL PROTECTED] _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users BMT Cordah Ltd. A member of the BMT group of companies Registered Office: Investment House, 6 Union Row, Aberdeen AB10 1DQ Registered in Scotland No. 163413 http://www.bmtcordah.com/ http://www.bmt.org/ The contents of this e-mail and any attachments are intended only for the use of the e-mail addressee(s) shown. If you are not that person, or one of those persons, you are not allowed to take any action based upon it or to copy it, forward, distribute or disclose the contents of it and you should please delete it from your system. BMT Cordah Limited does not accept liability for any errors or omissions in the context of this e-mail or its attachments, which arise as a result of Internet transmission, nor accept liability for statements which are those of the author and not clearly made on behalf of BMT Cordah Limited. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
