I finally got around to upgrading from Postgres 8.4 / PostGIS 1.5 to
Postgres 9.1 / PostGIS 2.0. Did full dump and restore of my database
using postgis_restore.pl. Noticed that the tables remained in PostGIS
1.5 format. I tested the following SQL on a table:
ALTER TABLE alis.geo_tracts
ALTER
You can stuff things into an upper memory context, but I'm not sure
how wise that would be. I does however seem to be the only reasonable
approach to getting things to last much longer than a statement.
P.
On Sat, Oct 20, 2012 at 9:12 PM, Stephen Woodbridge
wood...@swoodbridge.com wrote:
Hi
OK, I can look into doing that if I need to. I guess the appropriate
thing to do at the moment is to see if I can get things working just
loading them from tables first and see if there are performance issues
before I try to optimize it.
I should not be an issue for standardizing the
On Fri, Oct 19, 2012 at 11:56:18AM -0500, William Kyngesburye wrote:
Can the attributes of child layers be seen from a layer?
Sure, given enough neurons to build the appropriate SQL query...
(TopoGeomeometry management still has rough edges)
It would be something like this:
SELECT * FROM
hello,
I would like to know if post GIS supports hibernate ? and also if it has
authentication support?
Thank you in advance.___
postgis-users mailing list
postgis-users@postgis.refractions.net
Actually, it's the other way around. Hibernate that has to support PostGIS.
For what I know, Hibernate supports spatial objects and PostgreSQL. PostGIS
is probably included.
On Sun, Oct 21, 2012 at 8:14 PM, lineh arineh line...@yahoo.com wrote:
hello,
I would like to know if post GIS
I get the same invalid endian flag value encountered error with your
example on PostGIS 2.0. However, if I remove the escapes and use
dollar quoting instead, it works:
SELECT ST_AsEWKT(ST_GeomFromEWKB($$\001\001\000\000
Oh, I just realized that your example would have worked fine with
escape strings prefixed with E:
select st_astext(ST_GeomFromEWKB(E'\\001\\001\\000\\000
\\263\\216\\001\\000\\000\\000\\000\\000\\252\\326''\\301\\000\\000\\000\\000X\\025.\\301'::bytea))
(note the above has a space character in
hi,
you need check out something called spatial hibernate at
http://www.hibernatespatial.org/
It supports Postgis and other spatial databases.
Dave.
lineh arineh wrote:
hello,
I would like to know if post GIS supports hibernate ? and also if it has
authentication support?
Thank you in