On Thu, 2007-05-31 at 17:47 +0200, Christo Du Preez wrote:
I wonder if someone can perhaps shed so light on a very strange issue.
I'm not sure if this is a postgis or postgres question.
I've written a function that takes a geometry and a couple of other
arguments then in the function I
On Fri, 2007-06-01 at 10:06 +0200, Matt Doughty wrote:
Hi,
I’m having some problems with the GeomUnion (geometry, geometry)
function- basically that it takes forever and eventually crashes out
for lack of memory.
I’m trying to perform a union on two polygon tables (of 9,000 and
On Wed, 2007-06-20 at 15:25 +0200, Lobo wrote:
Hi,
I have problem executing the following query:
SELECT transform(the_geom,4326) FROM gm_1996;
It results in the following error message:
ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=sterea
+lat_0= 52.156160
On Fri, 2007-06-22 at 14:56 +0200, Sébastien Geindre wrote:
my example is wrong, in fact i have 16 column but for the post i try to
keep 3 column
but the pb comes from lat/lon precision...of format but from Polygon WKT
format...
sorry
Okay, then let's try a simple test case:
CREATE
On Fri, 2007-06-22 at 15:10 +0200, Sébastien Geindre wrote:
i found !!!
sorry for time lost..
it was copy/paste between specification document (open office) with
wrong character inside the insert request !!! i am crazy !!
a question, if the column is specified with srid 4326 for
On Sun, 2007-06-24 at 12:34 -0400, Kurt Schwehr wrote:
Hi All,
I'm having trouble with a NOAA electronic chart that I am trying to
put into postgres without success. I don't seem to be able to access
the tables.
http://vislab-ccom.unh.edu/~schwehr/ENC/NOAA/US5NH02M.000.bz2
Here is
On Sat, 2007-06-30 at 14:05 -0400, Jonathan Aguero wrote:
Listers
I got a multilinestringM shape that I loaded into postgis without
problem (LRS). Then I used the linear referencing functions to create
the segments and curves tables from the tables (BTW, these linear
referencing functions
On Fri, 2007-07-20 at 17:56 +, Marc Desharnais wrote:
Hi all,
I recompiled postgis from scratch lately with support for GEOS, which
I compiled too. I confirm that GEOS' bin directory is in my path.
When I start Geoserver I keep getting this warning message.
[main] WARN
On Tue, 2007-07-24 at 15:27 +0200, Milo van der Linden wrote:
Hello Mark,
I am using your suggestion at this moment but the problem is as
follows:
I do an insert into the final_geom table which then uses a new id
but;
I need this id to do an insert into the final_attrib table!
On Tue, 2007-07-24 at 15:26 +0200, Boehm, Andreas wrote:
Hi list,
working with an huge data table I've massive performance problems.
Here's the scenario:
There is one table trees, containing about random 250.000.000 points
within the square (x = 10 / y = 10). SRID is -1. A second
On Tue, 2007-07-24 at 19:50 +, Marc Desharnais wrote:
Hi Mark,
I did a make install. Maybe someone can tell me if I missed something to
make GEOS work properly with Postgis.
But my Postgresql is not installed in a default directory. So maybe
there is a problem with that.
What
On Thu, 2007-07-26 at 02:04 +, Alan Cunnane wrote:
Hi guys
I have a query here that joins about 10 tables tables and uses two
distance queries. Im am having massive performance issues with it and
im hoping you could help me to tune it or change it so that
performance is increased. All
On Thu, 2007-07-26 at 22:33 +0100, Mark Cave-Ayland wrote:
So the version of PostgreSQL being used has been installed
under /data/ulysse/postgis_geos/postgresql-8.2.4 - if you want to
override this then you need to re-run configure with the --with-pgsql
option pointing to the correct
On Thu, 2007-07-26 at 19:31 +, Marc Desharnais wrote:
Hi Paul,
thanks for your reply. I checked what you mentioned and I found that
liblwgeom.so is well placed and refreshed when I do make install.
But you gave me an idea about libraries. I had an ancien postgresql
installation and
On Thu, 2007-07-26 at 16:12 -0700, Paul Ramsey wrote:
Or, you can update the directory path for the functions in pg_proc. I've
done that in the past to good effect.
P
Hmmm... that's a nice little hack. Will have to remember that one in
future ;)
I think I might ask pgsql-hackers as to why
On Fri, 2007-07-27 at 07:04 +0100, Mark Cave-Ayland wrote:
Unfortunately since the OSGB36 datum is not defined in PROJ.4 4.5.0,
the library throws an error if you attempt to use this parameter with
older versions - so I don't really know what to do about this :(
Not sure about SRID 4277
On Mon, 2007-08-06 at 13:09 -0400, Burgholzer,Robert wrote:
I am experiencing an error that I have seen in the archives with the
title: “ERROR: function 60821C60 returned NULL”. Any help would be
appreciated.
It seems that in the previous posts, a null geometry (or rather too
many of
On Tue, 2007-08-07 at 09:06 +0100, Dave Potts wrote:
I have a table with a list of places described as Geometry type POINT
and a table loaded from a shape file, which takes the form of target
(ie several inscribed circles), each is encoded as a MULTIPOLYGON. I am
attempting to discover
On Thu, 2007-08-09 at 16:54 -0700, Sunburned Surveyor wrote:
Is there a developer's guide kicking around for PostGIS? I was on the
PostGIS website and downloaded the PDF manual, but it didn't seem to
cover any development topics.
Is there a wish list or feature request list for PostGIS?
On Tue, 2007-08-14 at 09:25 +0200, Stefan Zweig wrote:
i am wondering why postgre has to restart after i run that update query. that
actually should not be, should it?
regards, stefan
Hi Stefan,
If PostgreSQL is restarting, you will find more information in the
server log. Posting the
On Wed, 2007-08-15 at 15:45 +0200, Stefan Zweig wrote:
hi mark, hi list,
i have a problem with running these querys:
SELECT
AddGeometryColumn('public','_g2994','the_geom_1','4326','MULTIPOLYGON',2);
ALTER TABLE _g2994 DROP CONSTRAINT enforce_geotype_the_geom_1;
ALTER TABLE _g2994
PostGIS is in UTF-8, the table is in WindowsLatin1. How do I change the
encoding? Is it just a matter of editting the tab file and changing the
string WindowsLatin1 with UTF-8?
Hi Milo,
If your database is in UTF8 encoding then you can try to get PostgreSQL to
do the conversion for you. A
On Fri, 2007-08-17 at 16:59 -0700, Michael Smedberg wrote:
Mark,
Thanks for the reply!
Yup, adding that WHERE clause DOES make a big difference, but not big
enough (in a sense.) It doesn’t really explain the performance
difference (it still seems like maybe the LIMIT is not
Hi everyone,
The Windows installer for PostGIS 1.3.1, compiled with PROJ 4.5.0 and
GEOS 3.0.0rc4 is now available for download from the Refractions
website.
As well as being the first release of the 1.3.x series, the installer
now uses the newer GEOS 3 by default. So as well as the new function
On Sat, 2007-08-18 at 08:54 +0200, Mateusz Loskot wrote:
(lots cut)
Am I doing anything wrong or there is a bug or everything is correct
and the PostGIS scripts should live outside PostgreSQL installation tree?
Hi Mateusz! :D
It looks like it's because you've specified --prefix, configure
On Sat, 2007-08-18 at 09:01 -0700, Webb Sprague wrote:
Hi,
Yes, lwpostgis.sql contains the correct path - in fact, the previous
line of SQL works just fine and finds liblwgeom for other functions.
It is only this line and subsequent that fails.
I intsalled geos right before building
On Sun, 2007-08-19 at 01:23 -0700, Ryan D. Enos wrote:
Hi Everyone,
I'm sure this is an easy answer, but it has me held up and I'd really
like to figure it out.
I am recently running Windows Vista with postgresql 8.2, I am attempting
to upgrade to postgis 1.3.1. As such, I have removed the
On Sun, 2007-08-19 at 12:31 -0700, Ryan D. Enos wrote:
Thanks Mark, I was hoping it would be that simple, but I am still getting the
same error:
//lwpostgis_upgrade.sql: No such file or directory//
any other suggestions?
thanks.
Ryan
Hmmm, do the file permissions look reasonable for the
On Mon, 2007-08-20 at 23:06 +0200, [EMAIL PROTECTED] wrote:
dear list,
i am building postgis 1.3.1 with geos-3.0.0rc4, proj-4.5.0, postgresql-8.2.4
on suse enterprise server 10
./configure --with-pgsql=/usr/local/PGSQL/bin/pg_config
--with-geos=/usr/local/GEOS-3.0.0RC4/bin/geos-config
On Sun, 2007-08-19 at 09:50 -0700, Webb Sprague wrote:
Here is the tarred diff's from the tests that failed below (again, I
think - I am not sure about postgis regression tests)
Let me know if there are changes and I will rerun.
W
Strange... I'm having trouble understanding those diff
On Tue, 2007-08-21 at 17:51 -0700, Webb Sprague wrote:
Voila. Let me know if there is any way I can help.
-W
Thanks Webb.
Well the reason the diff looks strange is because the tests stop running
half way through :( Are there any messages in the server log to
indicate a server crash? As a
On Tue, 2007-08-21 at 21:01 -0400, Greg Troxel wrote:
I am in the midst of updating the postgis package in pkgsrc to 1.3.1.
templategis has been removed from the build/install targets (r2652) I
found no NEWS entry about this, or anything in the README. As a
packager, should I take this as a
On Tue, 2007-08-21 at 17:40 -0400, Obe, Regina wrote:
I just installed the new version of 1.3.1 and noticed something which
I'm not sure was intended or not or if something went amiss with my
upgrade.
Before there used to be 2 formats of collect
That which takes two geometries used like
On Wed, 2007-08-22 at 07:58 -0400, Obe, Regina wrote:
Hi Mark,
I used your install exe. The recreated template_postgis() is right and
has those aggregate functions. At first I thought maybe I ran the wrong
lwpostgis_upgrade.sql file after upgrading even though the version
changed from
On Wed, 2007-08-22 at 08:19 -0400, Obe, Regina wrote:
I notice that in the 1.3.1 that the aggregate function is called
ST_Union instead of ST_GeomUnion and that the regular function is
called
ST_GeomUnion(geom, geom)
Since the old aggregate was call GeomUnion I had assumed the new
On Wed, 2007-08-22 at 09:04 -0400, Obe, Regina wrote:
Hi Mark,
Thanks for the explanation. Actually now I see I was wrong that there
actually isn't an ST_GeomUnion function as I had thought, so things are
consistently named.
But that means the documentation is wrong
On Wed, 2007-08-22 at 11:43 -0400, Ashaar Khalid Sheikh wrote:
Hi All,
We are trying to package the PostGIS v.1.3.1 to EnterpriseDB Postgres
installers (http://postgres.enterprisedb.com), but are facing the
following issues.
1. $libdir path gets expanded in the install location, making
On Wed, 2007-08-22 at 18:24 -0400, Ashaar Khalid Sheikh wrote:
Thanks for the help Mark,
I will give it another go, it might be something on my buildfarm that
is causing it.
My bad, yes it is coveredby. If a user runs into this, is it
acceptable if the user comments out this function? I
On Sat, 2007-08-25 at 12:08 -0400, Stephen Woodbridge wrote:
I'm trying to upgrade postGIS on my WinXP laptop. The installer is
aborting with the following error:
Output folder: C:\DOCUME~1\woodbri\LOCALS~1\Temp\postgis_installer
UserName=postgres
Password=
Port=5432
On Tue, 2007-08-28 at 23:22 -0600, Charlie Savage wrote:
I've divided up the MSVC++ patch into two parts. This is the
interesting part - it includes the change needed to the current PostGis
code base plus the addition of a file config.h.vc.
The most debatable part of the patch are changes
On Sun, 2007-09-09 at 16:03 -0400, Stephen Woodbridge wrote:
Hi all,
I seem to have missed reading some vital post or something.
What is the difference between ST_function() and function()?
Is this just a renaming for namespace issues?
Are the function() names deprecated?
Are there other
On Mon, 2007-09-10 at 11:40 +0200, Stefan Zweig wrote:
Right, RECHECK seems to be enabled by default for gist indices. Why is
that needed and how can I disable the RECHECK clause? In my case, SRID
lookups are not necessary when a CHECK (srid(the_geom)=4326) constraint is
used since all
On Thu, 2007-09-13 at 15:26 +0200, Stefan Zweig wrote:
Mark,
thank you very much for your response. As far as I understand, pre-computed
bounding boxes are stored (by default) to each Geometry object (wherever that
is) to make bounding box based queries faster, see
On Mon, 2007-09-24 at 00:29 +0100, Chris Jewell wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I have a problem converting OSGB coordinates to lat/long coordinates.
Currently, my
data exists in OSGB (SRID 27700), and I need to convert to WGS84 for
inclusion in a KML
On Wed, 2007-09-26 at 09:16 -0700, Dylan Beaudette wrote:
Hi,
I have looked over a couple documents on tuning a postgis server:
1.
http://postgis.refractions.net/pipermail/postgis-users/2006-March/
011539.html
2. http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
When
On Thu, 2007-10-04 at 14:13 +0900, Anton A. Patrushev wrote:
Hi,
I encounter problem with endPoint() function.
Every time I'm trying to call endPoint() function
with PostgreSQL 8.2.5 + PostGIS 1.3.1 it crashes the backend.
startPoint() function is working well.
I have to use
On Sun, 2007-10-21 at 17:57 -0600, Brian Timoney wrote:
Paul:
In the Windows install, there is the libproj.dll in the BIN directory
but no other files with which have names that imply 'grid' or 'nad'.
Unfortunately, we don't have an older Windows install in the office to
compare to...
On Fri, 2007-10-19 at 00:48 -0700, Brian Hamlin wrote:
Per-Olof
My worst problem it seems is that I had expected the clear warnings as
described in the README and doc.
I just tried a freshly created DB, initialized with postgis 1.3.1 and
got none of those terrible errors.
So things are
On Wed, 2007-10-24 at 13:05 -0400, Ann Holt wrote:
Hello,
I am currently trying to evaluate upgrading to Postgresql 8.3, but
having problems even getting the complete database up and running
because I can’t get PostGIS installed with the database properly.
So,
first I’m
On Mon, 2007-10-29 at 18:46 +0100, ivan minčík wrote:
my detail are:
Debian Etch stable.
select postgis_full_version();
postgis_full_version
--
POSTGIS=1.1.6
On Mon, 2007-10-29 at 18:20 +0100, ivan minčík wrote:
thanks, I just wanted to submit bug described in this thread
http://postgis.refractions.net/pipermail/postgis-users/2007-October/017365.html
this is one of the objects which was the reason
MULTIPOLYGON(((-99.63
On Mon, 2007-10-29 at 23:25 +0100, ivan minčík wrote:
I made pg_dump from the table. You can download it here:
http://disk.jabbim.cz/[EMAIL PROTECTED]/bug_db.tar.gz
You have to:
1. change my database user (called ivo) to Your user
2. createdb somedb
3. psql -U
On Mon, 2007-10-29 at 23:25 +0100, ivan minčík wrote:
I made pg_dump from the table. You can download it here:
http://disk.jabbim.cz/[EMAIL PROTECTED]/bug_db.tar.gz
You have to:
1. change my database user (called ivo) to Your user
2. createdb somedb
3. psql -U
On Mon, 2007-11-19 at 16:07 +0100, Sebastian Bšöck wrote:
Hi all,
i have a problem with multipolygon data. Taking the example data from
the documentation:
test=# select GeomFromText('MULTIPOLYGON(((0 0,4 0,4 4,0 4,0 0),(1 1,2
1,2 2,1 2,1 1)), ((-1 -1,-1 -2,-2 -2,-2 -1,-1 -1)))');
On Mon, 2007-11-19 at 22:40 +0100, Ivan Mincik wrote:
thanks a lot. these wrong are coming from some special format of
cadastral data in my country. data where first saved to ESRI
shapefile by OGR, then imported to postgis by shp2pgsgl. I think that
they are invalid also for the shapefile.
On Tue, 2007-11-20 at 18:40 +0100, Christoph Stasch wrote:
Hi,
I am using PostgreSQL 8.2 together with PostGIS 1.2.1. and I have a
problem with the EXTENT function of PostGIS:
POINT(-86.644724 34.725302) and POINT(-86.644724 34.725183) are
contained in the geom column of myTable.
If
On Mon, 2007-09-24 at 16:45 -0500, Tom Glancy wrote:
We are seeing ERROR: value 6906401929 is out of range
for type integer from Postgres when using shp2pgsql to load
shapefiles. Here is what ArcView reports for field properties:
Alias Type Width Decimal
On Thu, 2007-11-29 at 23:10 -0700, John Cartwright wrote:
Hi Mark,
Using the hourly svn snapshot, the build went fine, but make check
is still failing 12 out of 37:
../loader/shp2pgsql: shape (.shp) or index files (.shx) can not be
opened.
--john
Hi John,
Hmmm I'm not sure why
On Sat, 2007-11-17 at 20:34 +, Mark Cave-Ayland wrote:
So the real bug in this case is that the (E)WKB parser doesn't seem to
attempt to validate any geometries being passed through it :( I've had
a look at the parser code and it's quite a complicated beast with not
many comments, so I
On Fri, 2007-11-30 at 22:04 -0600, William Kyngesburye wrote:
I finally had a chance to try it. Builds and all tests run.
Brilliant. Thanks for testing.
I can't think of what might be going on on your system John. There
might be something helpful in your console or system logs.
Yeah
On Fri, 2007-12-07 at 14:35 +0100, LuVar wrote:
Hi. I have table with points. The points reprezents my ride on bike...
table of points:
id| possition | time| trip | speed
---
0 | point| datetime | null|
Hi everyone,
The Windows installer for PostGIS 1.3.2, compiled with PROJ 4.5.0 and
GEOS 3.0.0rc4 is now available for download from the Refractions
website.
While the installer process may not look any different, there have been
a lot of changes under the hood with respect to error reporting
On Wed, 2007-12-19 at 15:15 +0100, Steven De Vriendt wrote:
thanks Guido, now I want to allow connection from all to this ip
192.168.102.100 How do I configure this in pg_hba ?
For now I have
host all all md5
but that doesn't seem to work... Can you help me out ?
thx
Steven
Hi
On Thu, 2008-01-03 at 00:49 -0500, Darrell Sher wrote:
Issue:
When I run the lwpostgis.sql script it fails when creating the
histogram2d type with the error:
ERROR: function st_histogram2d_out(histogram2d) does not exist
SQL state: 42883
I can create the associated
On Fri, 2008-01-04 at 09:33 +0200, Toomas Aas wrote:
Hello!
Following the instructions in PostGIS online documentation, I performed a
hard upgrade from PostGIS 1.1.6 to 1.3.1, at the same time also upgrading
PostgreSQL from 8.1.5 to 8.2.5. During reloading of databases using
On Fri, 2008-01-04 at 11:44 +0200, Toomas Aas wrote:
Thanks very much for your advice. As I still have the dumps made from old
version before upgrade, I could probably just drop the databases and
re-create them, but this would mean losing couple of hours worth of
'production' data. I use
On Mon, 2008-01-07 at 11:22 +0100, Peter Hopfgartner wrote:
Hi,
in the chapter describing the hard upgrade, the command for a PostgreSQL
dump is given as:
$ pg_dump -Fc olddb olddb.dump
This is not accepted by PostgreSQL, at least on version 8.1 as on
RedHat/Centos. The command could
On Wed, 2008-01-16 at 10:21 +1100, James M. Kelly wrote:
Hi all
I am fairly new to postGIS and postgreSQL, so I am still bumbling
through a few performance issues at the moment.
I am having some trouble with doing an inner join on a spatial table
back with a normal table, and
On Tue, 2008-01-22 at 16:53 +0100, Simon Schneider wrote:
Hi,
I have the following table...
_
create table objects
(
name varchar(15) not null primary key,
parent varchar(15),
type varchar(15) not null
);
select
On Sun, 2008-01-27 at 18:12 +0530, Omkaranathan wrote:
Hi,
It will be great if somebody can suggest where I can get help from.
Thanks
Om
Hi Om,
This is my fault... looking at CVS, it looks as if the new code in 1.3.2
to check for a local PROJ.4 share directory won't work on PostgreSQL
On Mon, 2008-01-28 at 23:19 +0100, Milo van der Linden wrote:
Hello list,
Today I ran into an error on my postGIS database server. The database is
hosted on Windows Server 2003 and is currently postgres version 8.2.5
with postgis 1.3.1-1
The error that I recieved said:
FATAL: could
On Fri, 2008-02-01 at 14:49 +0530, [EMAIL PROTECTED] wrote:
In this path that you had mentioned
./configure --with-pgsql=/usr/local/bin/pg_config
Are you referring to /usr/local/pgsql/bin/pgs_config because the above
path does not exist.
Ah yes. Try instead:
./configure
Hi folks,
Since the bug tracker is out of action, I've been through my
PostGIS-related emails and added a list of known issues / patches
requiring review to the wiki here:
http://postgis.refractions.net/support/wiki/index.php?IssuesPatchesPending. If
we can keep this up to date, it should act as
then you can find the
documentation installed under the PostGIS group.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis-users
On Monday 03 March 2008 19:50:58 Paul Ramsey wrote:
It's back, FYI, having some fun w/ servers this week.
Does that include rebuilding them so that we can use trac as the PostGIS
bugtracker? ;)
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http
.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
on http://postgis.refractions.net/support/wiki/.
(Hmmm. Looks like the wiki is down at the moment...)
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing
should then work as intended.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net
/PostGIS 1.3.2
installer combination? (Note: the installers are all designed so you can have
one version of PostGIS per PostgreSQL installation without breaking
anything).
Many thanks,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608
for a future project or if you
are already a developer looking for new ideas, then this will be an ideal
opportunity to meet face-to-face with the people behind both projects.
Looking forward to seeing you there,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http
for the report. I've added this to the known issues/patches section of
the PostGIS wiki, so it's on the queue to be reviewed during the next
development cycle.
I really can't get into the Google Bug Tracker at all :(
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
,
Yes please. I may not be the person that eventually looks at this, however a
reproducible test case is enormously helpful in cases like these.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
much :(
On the positive side, the ERROR above is fairly obvious - you are missing the
PostGIS geometry_columns table either from your database or earlier on in
your .sql file.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870
process that
attempts to load the shared library. So you need to stop the PostgreSQL
server, add LD_LIBRARY_PATH to the environment for the postgres user, and
then restart.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608
.
I'm hoping to have some time to start looking at these over the next couple of
weeks, but if anyone else feels like reviewing patches in the meantime,
please do.
Kind regards,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
parts of PostgreSQL.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman
that the main problem is
to do with differing pointer sizes under Win64 compared to Unix :(
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
of
outstanding bugs on the wiki that could do with being added, and I won't be
able to spend much time in the way of bugfixing for another couple of weeks.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
something
trying to access the LWGEOM varlena size within an array directly, rather
than using the appropriate access macros provided by PostgreSQL.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
On Wednesday 19 March 2008 14:00:44 Obe, Regina wrote:
This is a known issue which I think Mark Cave-Ayland is working on.
I think Mike Leahy had suggested using
ST_MemUnion as a work around.
Hope that helps,
Regina
My current thinking is that it's related to array access under PostgreSQL
execution that would only be freed at the end of
the SRF. However I have a feeling that most of the memory in PostGIS is being
held by GEOS so this may/or may not make a difference. But please feel free
to experiment :D
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source
to myself and other people. You should also be able to close
issues #2, #3 and #9.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis-users
deprecated for years (because
they can eventually run out). You really should be using a SERIAL column
or PRIMARY KEY instead.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
Hi Dave,
Did you ever find out if there will internet connectivity at the
conference next week for a live mapping demo? And I guess there will be
a projector we can use to display slides etc. to people?
ATB,
Mark.
___
postgis-users mailing list
://postgis.refractions.net/docs/1.2/
This assumes no API changes between point versions though.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis
for
shp2pgsql to convert it into a form usable by your database.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis-users@postgis.refractions.net
polygons using ST_IsValid()?
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net
shp2pgsql.c: In function InsertMultiPoint:
shp2pgsql.c:1243: warning: comparison with string literal results in
unspecified behaviour
I'm busy looking at GBT#13, so if anyone else would like to get to this
before I do, feel free.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source
of pgis_getopt() to read its value.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http
Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
1 - 100 of 386 matches
Mail list logo