#POSTGIS IRC Log - 2009-05-26

For logs after Feb 3, 2007, all times are GMT-8. Prior logs are GMT-9.
Back to Logs
05:36:04 smartnude: When I use the shp2pgsql.exe with a very large data set I get "fseek( -721683687 ) failed on DBF file." ... the DBF file is ~3.3 GiB
05:36:09 smartnude: anyone who knows what's wrong ?
05:52:31 strk: ask on #gdal as it sounds shapelib's fault
05:54:27 bitner: I believe dbf files have a size limit of 2G
06:09:18 smartnude: strk, bitner: okey... I'll investigate further
07:01:26 CIA-34: robe * r4100 /trunk/doc/html/image_src/ ( Makefile.in st_within01.wkt ): Add st_within example to makefile and translate example so in viewable region.
07:09:24 jhammel: does anyone know how accurate ST_distance_sphere vs ST_distance_spheroid are?
08:00:41 m_e_: guys ive got a strange problem i try to alter my srids with this query: "UPDATE geodata SET geometry = st_setsrid( geometry, 4326 );" which return the following error: "ERROR: Operation on two GEOMETRIES with different SRIDs" and i dont know why :(
08:19:48 CIA-34: robe * r4101 /trunk/doc/html/image_src/st_within01.wkt: bad image try again
08:22:12 CIA-34: robe * r4102 /trunk/doc/reference.xml: for consistency make example be same as what is used to generate the image.
08:43:30 CIA-34: robe * r4103 /trunk/doc/ ( 5 files in 2 dirs ): put in images for buffer, fix within example image and example query
09:04:06 CIA-34: robe * r4104 /trunk/doc/ ( html/image_src/st_buffer02.wkt reference.xml ): Make lame circle more lame
09:04:40 jhammel: hah!
09:20:28 CIA-34: robe * r4105 /trunk/doc/reference.xml: make example fit the diagram in text
09:56:42 CIA-34: kneufeld * r4106 /trunk/ ( GNUmakefile configure.ac doc/Makefile.in ):
09:56:42 CIA-34: added postgis_comments.sql as a target to the main makefile
09:56:42 CIA-34: Since we don't want to add xsltproc as a dependency, this will remain separate for now:
09:56:42 CIA-34: make comments
09:56:42 CIA-34: make comments-install
09:56:43 CIA-34: ( the file should be removed by 'make uninstall' )
10:06:05 CIA-34: kneufeld * r4107 /trunk/doc/Makefile.in: added postgis_aggs_mm.xml to the 'make clean' target
10:10:10 adube: I execute queries using pgsql2shp to create shapefiles and sometimes the queries return 0 records and no shapefile is created. Is there a way to have the shapefile with 0 entries, like when you use ogr2ogr ?
10:23:13 CIA-34: kneufeld * r4108 /trunk/configure.ac: added dblatex and convert to the status lines at the end of configure
10:23:47 CIA-34: kneufeld * r4109 /trunk/doc/installation.xml: added version numbers to the requirements section in the installation doc.
10:30:55 CIA-34: kneufeld * r4110 /trunk/doc/Makefile.in: updated the comments-install make target