[postgis-users] Upgrade Postgres & Postgis

[Graeme Gould]

Hi

Have solved the primary issue I had by running a maintenance | analyze on the database.  This seemed to sort out the integration with my GIS application.

Further investigation of the problem shows that even though the values are not displayed in the data table geometry field you can still run spatial queries on them (i.e. SELECT area(geometry) from mytable).  The ones that don't display the geometry values are large polygons with large geometry field values.

Graeme

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Kevin Neufeld
Sent: 08 December 2010 16:35
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Upgrade Postgres & Postgis

Hi Graeme,

Can you isolate the problem?  Find a small geometry that is in your 
original data but not in your new database and place it in it's own 
table.  Then try to dump / restore the single table.  If possible post 
your problematic geometry here.

Maybe it's a particularly bad / invalid geometry that the new parser is 
having problems with.
-- Kevin


On 12/8/2010 4:27 AM, Graeme Gould wrote:
> Hi Ralf
>
> Thanks for the response.  Think I should have been clearer - it does not seem to be the geometry column table that is the issue, but the geometry field in the data table that is occasionally missing data.  It is in the original table in version 8.2 but is not picked up in the backup or restore process.
>
> Graeme
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


---------------------------------------------------------------------------------------------------------------------
This email and any files transmitted with it are confidential and intended solely for the use 
of the individual or entity to whom they are addressed. If you have received this email in 
error please let us know by email reply and delete it from your system. 

Please note that any views or opinions presented in this email are solely those of the 
author and do not necessarily represent those of Grand Union Housing Group. 

Finally, the recipient should check this email and any attachments for the presence of viruses. 
Grand Union Housing Group accepts no liability for any damage caused by any virus 
transmitted by this email. 

Grand Union Housing Group
Registered Office: 
Katherines House
Dunstable Street
Ampthill
Bedfordshire
MK45 2JP 
Registered under the Industrial and Provident Societies Act 1965 Registered No. 30388R 
Housing Corporation Registered No. L4518 

http://www.grandunionhousing.co.uk
--------------------------------------------------------------------------------------------------------------------