or me?
Thanks
Eoghan
---(end of
broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
-
James Cradock, [EMAIL PROTECTED]
---
(end of
broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
-
James Cradock, [EMAIL PROTECTED]
me3 Technology Consultants, LLC
24
or. I get the error also if I try creating the GiST index on the
table with the 33,000,000 rows.
Are there limitations with the GiST index? Has anyone seen this?
Thanks.
Jim
-
James Cradock, [EMAIL PROTECTED]
-
James Cradock, [EMAIL PROTECTED]
me3 Technology Consultants, LLC
24 P
Thanks.
I'm using PostgreSQL 8.0.2.
On Sep 1, 2005, at 6:35 AM, Richard Huxton wrote:
James Cradock wrote:
Hello.
I'm getting an Out Of Memory error when I try to create a GiST index
on a geometry column (PostGIS) with approximately 33,000,000 rows. I
can truncate the data in
database the table (or index) was
dropped from may free up disk space too.
Jim
-
James Cradock, [EMAIL PROTECTED]
me3 Technology Consultants, LLC
24 Preble Street, 2nd Floor
Portland, ME 04101
207-772-3217 (office)
207-838-8678 (mobile)
www.me3.com
---(end of broadcast
using geo-spatial coordinates. Software like MapServer (web) and Qgis (desktop) use PostGIS to provide data in map applications. The Refractions site already noted is a good start. The MapServer site is another: http://mapserver.gis.umn.edu/gallery Jim -James Cradock, [EMAIL PROTECTED]
On Nov 2, 2006, at 10:41 AM, Sandeep Kumar Jakkaraju wrote:After all it is open source ...so how can one trust it fully If you have a question about how something is working, and you find the end-user documentation to be lacking, you can look at the software's source. -James Cr
Try pg_type. typname should give you what you're looking for.
On Dec 30, 2005, at 1:57 PM, Jonel Rienton wrote:
Hi guys,
Does Postgres store all the possible column datatypes somewhere in its
system tables? Like int8, int4, character varying, etc. I'm trying
to write
another GUI client tha
It's not normal. What's the installation? OS, applications connecting to the server, etc. On Apr 7, 2006, at 8:20 AM, surabhi.ahuja wrote:hi, is it possible for postmaster to go doen on its own? all what the logs say is FATAL: terminating connection dur to administrator's command. thanks, regar
