- Some parts of the documentation appear in red?
- Inline graphics don't appear to be included (may be a case of
moving the images/ subdirectory?)
But in the meantime, I hand this back over to the hardworking
documentation authors :)
ATB,
Mark.
--
Mark Cave-Ayland
Siri
message if the version you are using is too old. Compiling a
newer version of PROJ (I'd grab the latest stable) and then re-building
PostGIS 1.3.3 should be enough to resolve this.
PROJ can be found at: http://trac.osgeo.org/proj/.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation -
is not clever enough to detect this, however the relevant
changes have been made in SVN trunk.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailin
here in multi-dimensional space).
If there is an extra constraint you can add to a WHERE clause based upon
another (non-geometry) field value, you may find that things can start
to work better...
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.s
k off-list so we could look into this?
Paul/Mateusz: Could this have been resolved by some of the recent memory
fixes in GEOS SVN?
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
_
help.
Hi Scott,
You'll probably get a suitable answer on the pgsql-general list over at
postgresql.org.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
Gus
Hi Gus,
It almost looks like it's just a simple file permissions problem. Are
you running the installer as an administrator, and does the
administrator user have the correct file permissions on the relevant
directories?
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The
ELECT postgis_full_version()".
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/mailma
de. I would suggest checking the Mapserver/PostgreSQL log files in
order to find any error messages that will point you in the right direction.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608
at http://svn.refractions.net/postgis/branches/1.3?
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:
really is the problem, it should resolve itself when the
rename is complete.
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
pos
d the
SQL procedures to match.
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/listinfo/postgis-users
1 and PostGIS 1.1 are both extremely old - you should
really consider building the latest PostGIS 1.3.x release to avoid
several nasty PostGIS bugs, and preferably a newer version of PostgreSQL
at the same time.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http:
will display an error
during the configure phase if this happens again.
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-
nyone interested? ;)
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/ma
so
Would anyone object to this at all? Of course, the documentation would
also be updated to reflect these changes.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-us
ql, psql should
report the offending line number for you, i.e.:
psql -d mydatabase -f shapefile.sql
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
dditional
"--with-pgsql=/usr/local/pgsql/bin/pg_config" argument to force it to
pick up the newer installation. Follow this with "make install" and you
should then be good to go.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The
e the calculation result correct,
and then change the output type. I'd be quite tempted to make ST_Extent
return a POLYGON geometry in the SVN head...
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
unately changing it in the
1.3.x series will probably break a lot of applications, so the earliest
it will happen is somewhere in 1.4.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
_
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/mailman/listinfo/postgis-users
outines that go beyond what
Buffer(0) can accomplish.
There does seem to be a lot of discussion recently about new features;
perhaps we need to add a "How to sponsor a feature" section to the wiki
explaining how companies can approach developers to get new features
implemented...
ring
shp2pgsql to use the geometry parser so that erroneous geometries are
written out to a separate shapefile if that helps. However at the moment
it's quite far down on the TODO list unless anyone wants to sponsor a
developer to work on it.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Cor
Stephan Holl wrote:
definetly, thanks. Perhaps you could drop a note on the
postgis.org-website for other who are seeking to install postgis
offline on w32.
Best
Stephan
Done.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T
Paragon Corporation wrote:
I guess the only concern with that which Paul Ramsey or Mark Cave-Ayland
can clarify on is that since they are restructuring at least the PostGIS
part not sure how easily it will stream up. I presume the Geos part is
undergoing some changes too with the Prepared
ave any success with profiling under OS X?
If so, it would be good to get at least a working profile output of both
query cases, so we can try and determine where the time is being
swallowed during the index scan.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Sour
y tried removing the IMMUTABLE
definition from SQL definition of mcatest() and it didn't make any
difference to me - probably because adding a POSTGIS_DEBUG macro shows
that it only gets called once in total rather than once per iteration of
the nested loop scan.
ATB,
Mark.
--
Mark Cave-
Mark Cave-Ayland wrote:
*blinks* this is definitely a bug somewhere - there is no way that
adding a function wrapper to a constant should make the query several
orders of magnitude quicker :(
Hmmm. It seems the problem is related to whether or not we copy the
incoming geometry. I've
#x27;ll leave the typmod modifications for a bit to dig into this.
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
e fairly easily that the time is
disappearing into the second index scan. The above output doesn't look
quite right somehow (it's missing at least one node indicator) - can you
try cutting and pasting the exact output from EXPLAIN into an email
again? Also we'll need the output o
website does not say anything about that.
Thanks for any pointers.
Stephan
Hi Stephan,
You can download the Win32 installer direct from pgfoundry.org if you
wish; look for the StackBuilder project.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http
ed!
build_histogram2d() is part of the deprecated statistics subsystem which
only ever got used for PostgreSQL versions < 8.0. If you want access
to the 2D histograms created during ANALYZE, I think you should be able
to get at them through the pg_statistic table or the related pg_stat
tu/+source/postgis/+bug/205179.
Other than basic human error, the only thing I can think of is that
another package somewhere in the GIS application bundle supplied with
Hardy Heron still depends on GEOS 2.2.x series.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
ht
s slated to be 1.4, although who knows what may happen if new features
get added? ;)
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-us
trunk, so feel free to download, test and feedback.
In terms of new features, several people have recently been asking about
multi-dimensional indices. If enough interested parties could donate
some money for developer time, I'm sure this would help fund the
developers required to do the w
ly
to this thread.
[Note: I have also CC-d to postgis-devel, but please keep any resulting
discussion on postgis-users]
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
pos
24KB, as a size.
What ist right ?
Thanks Rolf
Errr... I think you mean 24MB ;) Generally you should adjust this to
suit the amount of RAM on your server - see the various PostgreSQL
tuning guides for more details.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Ex
.
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/mailman/listinfo/postgis-users
in
1.3.2. Upgrade to 1.3.3 and the problem should go away.
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.
ST_EWKT() function which will output the
extra information, but is not spec-compliant.
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
have been completely
uninstalled before you do this.
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://pos
- can you spot anything odd in there?
Thanks,
Calum.
Hi Calum,
Apart from the strange libdir, everything looks good. The only other
thing I can think of is a mismatch between the server version and the
server headers (i.e. the postgresql-devel RPM still belo
ser you ran configure. You may also try "which pg_config" to see
from where configure is finding your PostgreSQL configuration information.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
_
ch is wrong - it should be installed in the postgresql lib
directory which is typically under /usr/lib/pgsql/lib or
/usr/lib/postgresql/lib. Did you pass in any non-standard parameters to
configure?
As a first course of action, I would try removing all liblwgeom files
from /usr/lib64 and trying
headers for the wrong version...
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/listinfo/postgis-users
to point to the wrong one (and hence the library is
installed into the wrong $libdir).
Of course, all of this also assumes that SELinux has been disabled too ;)
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +
QL server so
it can pick up the changes.
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/mailman/listinfo/postgis-users
n get this changed. The installer should still work
without any problems, however.
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-
ade script,
StackBuilder users will need to uninstall their existing version before
1.3.3 can be installed.
Please report any issues to the lists/bug tracker as normal.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 87
compare the settings in
postgresql.conf between both systems, and also check the statistics
target for each of the columns within the join before going any further.
Don't forget to restart PostgreSQL if you make any changes to the memory
/cost settings.
HTH,
Mark.
--
Mark Cave-Aylan
x27;, 21781)
This should return with a few ms. Bear in mind that the "geo.the_geom &&
GeomFromText('Point(682970.983613 246747.010965)', 21781)" section is
redundant with newer versions of PostGIS too.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporati
d simply by
bounding box equality.
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.refract
code that I need to squash before I can
roll them out.
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
is.refractions.net/pipermail/postgis-commits/2007-October/000180.html
for more information. Any doc patches gratefully received :)
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
__
> The function ST_Contains() doesn't work in version 1.3,2. Is it fixed in
> version 1.3.3?
> Regards,
> Stephan
Hi Stephan,
In what way did you think it was broken in 1.3.2? You'll need to post some
form of test case in order for someone to help you.
ATB,
Mark.
--
M
,
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/listinfo/postgis-users
't really know to be honest... :)
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.refr
the shp2pgsql
output like this:
--
-- Generated by shp2pgsql
-- RCSID: $Id: shp2pgsql.c 2760 2008-04-09 19:52:19Z pramsey $
RELEASE: 1.3.3SVN
--
Maybe that would help people?
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +4
On Thu, 2008-04-10 at 21:46 -0400, Paragon wrote:
> Mark has been hanging around databases too long
Ha ha, almost certainly!! ;)
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0
y, but as long as the release checkout comes from a UNIX-type SVN
client, there won't be any problems. I think we're about good to go at
this end - any takers for checking Solaris?
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.sir
kipedia.org/wiki/Short-circuit_evaluation
>
> for a more complete description of this common computer language
> feature.
Fascinating. Being self-taught in C, it's always interesting to learn
something new - even if it does go against intuition :)
p my Win32 virtual to test SVN ready for
release, and I'm getting a failure in the regress_ogc section :(
Unfortunately this will have to wait until later tomorrow before I can
look at it...
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit
p decided to blow up today - as I'm heading out now, I'll see if I
can come up with something later this evening on my home machine.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
efault value of -1, and then use sscanf() within the switch()
statement 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-us
too far off 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-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
ng: comparison with string literal results in
unspecified behaviour
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
gt; Proj-4.4.9
>
> I run out of ideas and I am looking forward for any help.
> Cheers
>
> Rainer
Hi Rainer,
Have you checked the validity of your polygons using ST_IsValid()?
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.
s :(
As a starting point, you may wish to add a collection of notes on the wiki, or
even better if you could contribute documentation patches based upon your
experiences.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siri
the first error looks like an encoding problem. You need to look at
what encoding is used for your shapefile, and then use the -W option 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
f
the documentation online with each release, so there is something like:
http://postgis.refractions.net/docs/1.3/
http://postgis.refractions.net/docs/1.2/
This assumes no API changes between point versions though.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open
;
> USE_STATS"
> on "PostgreSQL 8.2.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
> 3.4.2 (mingw-special)"
> creates a point with a small distance (but >0) in both cases
>
>
> Greetings
>
> Thomas and Rene
Hi Thomas and Rene,
I've added this to
On Fri, 2008-03-28 at 14:56 +, Mark Cave-Ayland wrote:
> 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?
>
&
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
post
ith "s rather than 's.
BTW using internal PostgreSQL OIDs has been 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 Corpor
on()
ST_MakePolygon()/ST_Polygon()
I've tested with PostgreSQL 8.2 and 8.3 and the regression tests look
good; please can other people test and feedback?
Paul: please can you make me an administrator on the Google Bug Tracker?
I've done a quick move over of al
ended. Now in the case of a buggy SRF this could cause
excess memory usage during 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 exper
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
g arrays :( So it's likely 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.
te application ever, but there are a whole 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 Sourc
s down?
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/listinfo/postgis-users
s has mentioned that before 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
___
postgi
name it since it is likely to be linked in with other 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
ttp://postgis.refractions.net/support/wiki/index.php?IssuesPatchesPending.
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 Corporat
in /etc/init.d. You may
need to tweak the init.d script to add a "LD_LIBRARY_PATH=foo" clause in the
command line that launches pg_ctl.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
l free to have a
go. If not, add an entry onto the wiki at
http://postgis.refractions.net/support/wiki/index.php?IssuesPatchesPending
and someone should pick it up in due course.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Expert
regards,
> Chris
Hi Chris,
One thing to check is that you have set LD_LIBRARY_PATH for the user running
PostgreSQL rather than your user, since it is the server process that
attempts to load the shared library. So you need to stop the PostgreSQL
server, add LD_LIBRARY_PATH to the environment
u haven't told us how you generated your .sql files, what was
in them, how you are trying to restore them and what version of PostgreSQL
you are using. So without more information we can't help you much :(
On the positive side, the ERROR above is fairly obvious - you are missing th
some code to reproduce the problem if anyone is
> interested.
>
> Thanks in advance,
> Fernando
Hi Fernando,
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-A
quot;. Running a quick "select distinct srid(the_geom) from
> towns;" shows that all rows are set to srid 26986.
>
> Brad
Hi Brad,
Thanks 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 revie
7;s missing on
something like Solaris? My temptation would be to simply remove it, and let
everything use the system getopt...
Kind regards,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
_
L/PostGIS 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 Sour
est PostgreSQL 8.2/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.siriusi
advance, best regards,
> Chris
Hi Chris,
Ahhh ooops - looks like the pj_set_searchpath() call I added to help the Win32
builds find reprojection files is only present in PROJ 4.4.9 or above :(
The quick solution is to download and install the latest PROJ.4 version and
rebuild PostGIS - eve
and correct. Is that postgresql 8.3 error?
>
> Bogumil
Hi Bogumil,
Can you provide a self-contained test case as a .sql file? And can you confirm
the versions of PostgreSQL/PostGIS you are using?
Many thanks,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
ccess my VM at the
moment :(
Has anyone else experienced this with other combinations of PostgreSQL/PostGIS
installer? For example, does the same PostGIS installer work for PostgreSQL
8.2?
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
issue: see the bug reports/patches
section 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
___
e error is reported? Also which
version of PostgreSQL/PostGIS are you using? You may need to check the
setting of standard_conforming_strings in postgresql.conf.
HTH,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 87
; ERROR: AddToPROJ4SRSCache: Cannot find SRID (32767) in spatial_ref_sys
>
>
> regards
Hi orkun,
Does the spatial_ref_sys table actually exist in your database? If so, does it
have an entry with a SRID of 32767?
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Exp
;Primarky Key GID" on streets_relation
> (cost=0.00..284.19 rows=1 width=758)"
>
> " Index Cond: (thisgid = 10)"
>
>
>
> Any idea on what I can do to improve the performance please?
>
>
>
> Thanks and regards
>
>
&
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 Expe
301 - 400 of 527 matches
Mail list logo
