Timeline


and

Dec 30, 2011:

8:45 PM Changeset [8624] by robe
bump up release numbers
8:36 PM Changeset [8623] by robe
forgot altitude arg for hillshade
3:11 PM Ticket #1305 (ST_Azimuth on the spheroid) reopened by pramsey
Oh bugger, so the existing one returns rads... humbug. It makes sense …
3:08 PM Ticket #657 (Spheroid/Ellipsoid projection given Lat/Lon, Distance & Bearing) reopened by pramsey
Oops, am I exposing radians? I want to only work with degrees at a …
10:32 AM Ticket #1422 ([raster] Issues with Mapserver and GDAL) created by robe
Bborie, I think you are right that gdal is not aware of the new …
8:25 AM Ticket #1421 ([raster] [PATCH] Auto-set SRID in raster2pgsql from GetProjectionRef() info) created by rouault
If the SRID is not explicitely set, the following patch tries to …
7:52 AM Changeset [8622] by robe
quickly change the options name arg to agree with ST_AsGML docs
7:43 AM Changeset [8621] by robe
#1415 -- beginning support for options -- expose the currently useless …
6:48 AM Ticket #1404 ([raster] raster2pgsql overviews don't look right) reopened by robe
Testing r8619(on windows) I'm still observing some funkiness with …
5:23 AM Changeset [8620] by pramsey
Stub in ST_LocateAlong and ST_LocateBetween for implementation before 2.0
5:17 AM Ticket #1420 (ST_LocateBetween(geom, m1, m2, offset)) created by pramsey
Add in an LRS function using SQL/MM function naming, replaces and …
5:16 AM Ticket #1419 (ST_LocateAlong(geom, measure, offset)) created by pramsey
Add in an LRS function using SQL/MM function naming, replaces and …
3:18 AM Ticket #1418 (Fix up errors in new loader GUI and add dumper support) created by mcayland
From my email to postgis-devel yesterday: 1) Instead of passing …
1:24 AM Changeset [8619] by robe
put in default values for ST_AsSVG geography
1:06 AM Changeset [8618] by robe
change ST_AsSVG(text) to explicilty list all args otherwise upgrade …
12:48 AM Changeset [8617] by robe
change ST_AsSVG to use default args and support named args. Also …

Dec 29, 2011:

7:56 PM Ticket #1417 (ST_AsX3d output tests against x3dom 1.3 framework and x3doms.js) created by robe
The 1.3 X3DOm framework recently got released (just before Christmas) …
6:47 PM Ticket #1416 (ST_AsX3D output for curves) created by robe
The name says it all. I think this is something I can get in before …
6:44 PM Ticket #1415 (X3D output optional options arg for flipping coordinates and output bbox) created by robe
This will be similar to the opt argument we have for ST_AsGML. Except …
6:36 PM Ticket #854 (X3D output functions) closed by robe
fixed: This is more or less done so will close this out to include tickets …
1:00 PM Changeset [8616] by pramsey
Conditionally drop loader test tables (requires PostgreSQL >= 8.2 to …
12:33 PM Ticket #1413 (COPY into typmod table fails on OSX) closed by pramsey
fixed: Actually this was a larger problem with how the in/out functions were …
12:32 PM Changeset [8615] by pramsey
Fix postgis_valid_typmod to use gserialized* as an input instead of …
11:53 AM Ticket #1414 (TypMod Support for Curves) created by pramsey
The typmod code was written for geography, so the types it supports …
11:35 AM Ticket #1413 (COPY into typmod table fails on OSX) created by pramsey
From the loader regression: […] returns […]
10:13 AM Changeset [8614] by strk
Retain type of TopoGeometry objects defined by NO element (#1017) …
10:01 AM Changeset [8613] by strk
Consider TopoElements? of type 0 as empty, allow CreateTopoGeom? calls …
3:18 AM Changeset [8612] by strk
Test more TopoGeometry creation
2:52 AM Changeset [8611] by strk
CreateTopoGeom?: tweak error message on out-of-range TopoGeometry type
2:44 AM Changeset [8610] by strk
Complete parameter names

Dec 28, 2011:

11:40 PM Changeset [8609] by strk
Typos and argument names
11:39 PM Changeset [8608] by strk
Honour verbosity for database initialization errors
11:04 PM Changeset [8607] by strk
Tabs to spaces, a few TODO items…
11:04 PM Changeset [8606] by strk
Put overridden (for topology) spatial predicates in their own file
10:48 PM Changeset [8605] by strk
topology.toTopoGeom: add type compatibility checks (#1017)
10:05 PM Changeset [8604] by strk
Add geometry parameter names to functions
2:05 PM Ticket #1412 (ST_Intersects not using indices) created by strk
That's due to STRICTness of the function, see #1410
1:34 PM Ticket #1411 (Remove JAR files from the repository) created by strk
The PostGIS repository should contain sources, not precompiled …
8:51 AM Ticket #1410 ([raster] ST_Intersects doesn't seem to be using index) closed by dustymugs
fixed: Done in r8603.
8:51 AM Changeset [8603] by dustymugs
Removed STRICT from various ST_Intersects functions and changed the …
8:36 AM Ticket #1410 ([raster] ST_Intersects doesn't seem to be using index) created by robe
I just noticed this recently, but haven't ruled out its not something …
7:45 AM Changeset [8602] by dustymugs
Force initialization of output GDAL raster from rt_raster_gdal_warp to …
7:39 AM Ticket #1402 ([raster] ST_Resample producing incorrect transformation) closed by dustymugs
worksforme: After testing, the transformed rasters are correct spatially upon …
6:07 AM Changeset [8601] by robe
I have difficulty with simple math
5:59 AM Changeset [8600] by robe
more description of over view
4:56 AM Ticket #1404 ([raster] raster2pgsql overviews don't look right) closed by robe
fixed: yap that fixes the issue. Thanks, Regina
3:02 AM Ticket #1409 (Can't compile topology or raster anymore under mingw) closed by strk
fixed: Peter Clark found out: white space. Please try r8599
3:01 AM Changeset [8599] by strk
Drop spurious white spaces. Should fix #1409. Thanks Peter Clark.

Dec 27, 2011:

6:19 PM Changeset [8598] by dustymugs
Correct output of INSERT statements for overviews in raster2pgsql.c. …
5:20 PM UsersWikiPostGISHosters edited by dghed
(diff)
8:37 AM Changeset [8597] by robe
oops missing tag -- removed other copy paste mistakes
8:33 AM Changeset [8596] by robe
document ST_HillShade (still need to put in examples)
7:31 AM Changeset [8595] by robe
norm is right - powers of 2 are better especially since my file tiles …
6:40 AM Ticket #1404 ([raster] raster2pgsql overviews don't look right) reopened by robe
Okay I think after much head scratching, flipping binaries, renaming …

Dec 26, 2011:

10:32 PM Changeset [8594] by robe
link to npgsql download site.
10:27 PM Changeset [8593] by robe
fix typo and provide link to java jdbc download site
10:04 PM Changeset [8592] by robe
link to raster applications section that demonstrates how to use these …
10:01 PM Changeset [8591] by robe
replace java example with a simpler more useful one
9:29 PM Changeset [8590] by robe
provide a java console app example
2:22 PM Changeset [8589] by robe
more description
2:10 PM Changeset [8588] by robe
c# example using ST_AsPNG
12:31 PM Changeset [8587] by robe
more cleanup
12:24 PM Changeset [8586] by robe
use docbook paragraph tags
12:21 PM Changeset [8585] by robe
some other minor cleanup
12:20 PM Changeset [8584] by robe
wrap php code in cdata tags
12:10 PM Changeset [8583] by robe
Add php example using postgis raster
9:43 AM Changeset [8582] by robe
correct comment
9:38 AM Changeset [8581] by robe
minor formatting cleanup
9:37 AM Changeset [8580] by robe
fix typo in image names
3:04 AM Changeset [8579] by robe
example of resample
2:31 AM Changeset [8578] by robe
fix typo in cast check expression. Should be checking for box3d …
1:32 AM Changeset [8577] by robe
bump up version numbers

Dec 25, 2011:

11:30 AM Ticket #1409 (Can't compile topology or raster anymore under mingw) created by robe
Something happened recently and I don't know what it is. Might be the …
2:56 AM Changeset [8576] by strk
Stub toTopoGeom function and testcase (#1017)
2:56 AM Changeset [8575] by strk
Add missing dependencies of topology.sql (includes)

Dec 24, 2011:

2:59 PM DevWikiWinMingWSys_20 edited by robe
(diff)
2:27 PM Changeset [8574] by robe
another minor typo
2:10 PM Changeset [8573] by robe
fix typo in column numbers
1:51 PM Ticket #1408 (PDF generator sets transparency to black) created by robe
I think this is an issue I mentioned before and for the wkt raster …
1:39 PM Changeset [8572] by robe
minor formatting change
1:07 PM Changeset [8571] by robe
fix formatting of ST_Transform example and add another sub example …
12:18 PM Changeset [8570] by robe
example for raster transform
10:58 AM Ticket #1404 ([raster] raster2pgsql overviews don't look right) closed by robe
fixed: Okay its not that either. Bborie -- sorry I have no idea why it's …
10:40 AM Changeset [8569] by robe
change docs to use unix style slashes which work correctly on both …
8:42 AM Changeset [8568] by dustymugs
If generating overviews and -F is set, overview tables will have …
7:52 AM Changeset [8567] by dustymugs
Testing the wrong variable when checking if two rasters is different.
3:41 AM Changeset [8566] by strk
Encode dependency of objects and scripts on configuration
3:23 AM Ticket #1407 (uninstall_topology.sql machinery) closed by strk
fixed: it took a few more commits to complete, among adding support for …
3:22 AM Changeset [8565] by strk
Ignore generated uninstall_rtpostgis.sql
3:22 AM Changeset [8564] by strk
Drop created tables after run
3:22 AM Changeset [8563] by strk
Cleanup created tables after run
3:21 AM Changeset [8562] by strk
drop created table after run
3:21 AM Changeset [8561] by strk
Add support for dropping DOMAINs in create_undef.pl (#1407)
3:21 AM Changeset [8560] by strk
Enable uninstall_topology.sql testing
3:21 AM Changeset [8559] by strk
Allow fully-qualified basetype name for aggregates
3:21 AM Changeset [8558] by strk
Drop tables in reverse order, reducing probability of fkey troubles
2:42 AM Changeset [8557] by strk
run_test doesn't need USE_VERSION anymore
2:42 AM Changeset [8556] by strk
Generate uninstall_topology.sql
2:34 AM Changeset [8555] by strk
Stop using USE_VERSION, assume pgsql is always > 7.4. Hopefully fixes #819
2:34 AM Changeset [8554] by strk
Add support for objects schema definition in create_undef.pl
2:08 AM Ticket #1407 (uninstall_topology.sql machinery) created by strk
Generate uninstall_topology.sql, regress-test it and install it. See …
2:01 AM Ticket #301 ([raster] Add uninstall_rtpostgis.sql machinery) closed by strk
fixed: With r8553 the work here is completed. uninstall_rtpostgis.sql will be …
1:59 AM Changeset [8553] by strk
Drop created function after run
1:59 AM Changeset [8552] by strk
Ensure mapalgebra test functions are dropped
1:59 AM Changeset [8551] by strk
Don't load rt_utility_test data creator as test
1:58 AM Changeset [8550] by strk
Add rt_empty_raster dropper script
1:58 AM Changeset [8549] by strk
Add rt_properties_test dropper script
1:58 AM Changeset [8548] by strk
Move single-test data tables within the testfiles, cleanup after run
1:58 AM Changeset [8547] by strk
Cleanup after run
1:58 AM Changeset [8546] by strk
Add a drop_rt_band_properties_test script for cleanup purposes
1:58 AM Changeset [8545] by strk
cleanup data tables
1:58 AM Changeset [8544] by strk
Add a drop_rt_gist_test.sql file for cleanup purposes (#301)
1:58 AM Changeset [8543] by strk
Cleanup created objects
1:57 AM Changeset [8542] by strk
Avoid function calls in DEFAULT specifications for unknown SRID …
1:57 AM Changeset [8541] by strk
Enhance DEFAULT specification stripper
1:57 AM Changeset [8540] by strk
Run uninstall test for raster, when enabled
1:56 AM Changeset [8539] by strk
Generate uninstall_rtpostgis.sql (#301)

Dec 23, 2011:

10:12 PM Ticket #1406 (shp2pgsql crashes when loading into geography) created by pcreso
I was trying to load a GSHHS global shapefile into postgis geography …
6:51 PM Changeset [8538] by dustymugs
Additional work to remove DROP FUNCTION statements depending upon …
5:14 PM Changeset [8537] by dustymugs
Instead of using spatial reference text in WKT format, use PROJ.4 …
5:08 PM Changeset [8536] by dustymugs
Fix issue with RASTER_sameAlignment where the deserializing of the …
4:28 PM Ticket #1403 ([raster] Can't use -Y and -F together in raster2pgsql) closed by dustymugs
fixed
12:10 PM Ticket #1402 ([raster] ST_Resample producing incorrect transformation) reopened by dustymugs
9:33 AM Changeset [8535] by strk
support multiline function signatures at the parsing stage too…
9:30 AM Changeset [8534] by strk
Add support for multiline function signatures
9:01 AM Changeset [8533] by dustymugs
Overview constraints should always be added regardless of whether or …
8:49 AM Changeset [8532] by strk
Write header in the files generated by create_undef.pl Header …
8:49 AM Changeset [8531] by strk
Simplify uninstall_postgis.sql rule, drop the manual edited version
8:39 AM Changeset [8530] by dustymugs
Fixed erroneous addition of filename to overviews when the flags -l -F …
8:22 AM Changeset [8529] by dustymugs
Fixed for better path handling
8:18 AM Changeset [8528] by robe
put in sections for postgis extensions. Probably will need some cleanup.
8:14 AM Changeset [8527] by strk
Ignore generated comment files
8:14 AM Changeset [8526] by strk
Ignore generated raster files
8:14 AM Changeset [8525] by strk
Let create_undef.pl generate uninstall_postgis.sql
8:14 AM Changeset [8524] by strk
Cleanup after loader test runs, fixing uninstall testing
8:14 AM Changeset [8523] by strk
Drop objects created by the tests
8:14 AM Changeset [8522] by strk
Fix create_undef.pl script to generate correct uninstall script
8:04 AM Changeset [8521] by dustymugs
Added uninstall_script to facilitate generation of …
8:00 AM Ticket #1405 (Hudson should run make check RUNTESTFLAGS='-v') created by strk
By passing RUNTESTFLAGS='-v' to "make check" all failure should …
7:23 AM Ticket #1404 ([raster] raster2pgsql overviews don't look right) created by robe
This could be an issue with just windows. But I'm finding that some …
5:20 AM Changeset [8520] by robe
minor code change to make example a bit shorter
5:06 AM Changeset [8519] by robe
fix some erroneous statements about ST_Clip and provide example …
12:53 AM Changeset [8518] by robe
fix unbalanced tag
12:38 AM Changeset [8517] by robe
some cosmetic cleanup
12:35 AM Changeset [8516] by robe
example of st_clip with pictures
12:13 AM Ticket #1403 ([raster] Can't use -Y and -F together in raster2pgsql) created by robe
This might be just a windows issue, but I can do this […] -- and …

Dec 22, 2011:

11:58 PM Changeset [8515] by robe
start documenting ST_Clip
2:54 PM Ticket #911 (regress_managment ticket failing on 9.1 alpha5 and hudson) closed by strk
fixed: I'm assuming this is fixed. Can't belive hudson is still failing after …
2:52 PM Ticket #1287 (Drop of "gist_geometry_ops" broke a few clients) closed by strk
wontfix: Too late to go back, tagging this as "history" to remember to put in …
2:49 PM Ticket #1133 (Figure out and approve library dependency strategy.) closed by strk
fixed: I think we're pretty much settled about libs dependencies for the time …
2:48 PM Ticket #878 (ST_LineMerge with collection) closed by strk
invalid: Actually, will need to be done outside of PostGIS in any case…
11:59 AM Ticket #1402 ([raster] ST_Resample producing incorrect transformation) closed by dustymugs
wontfix: After testing a raster file (attached to ticket) of the same spatial …
11:09 AM Changeset [8514] by robe
fill in missing protos for droprasterconstraints / addrasterconstraints
7:58 AM Ticket #1402 ([raster] ST_Resample producing incorrect transformation) created by dustymugs
As per email …
5:24 AM Changeset [8513] by robe
make title a little shorter
5:23 AM Changeset [8512] by robe
changing titles -- raster data man I'm eventually going to throw in …
5:18 AM Changeset [8511] by robe
minor error in statement
3:20 AM Ticket #1397 (regress test uninstall scripts) closed by strk
fixed: re-fixed with r8507
3:20 AM Ticket #543 (uninstall_postgis.sql doesn't remove operator family) closed by strk
fixed: Confirmed by new uninstall regression tester and fixed with r8510
3:20 AM Changeset [8510] by strk
Drop operator families, not classes (#543)
3:20 AM Changeset [8509] by strk
Encode dependency of uninstall_postgis.sql on included files
3:20 AM Changeset [8508] by strk
Add more uninstall objects found by uninstall test (#1397)
3:19 AM Changeset [8507] by strk
Count objects in the _regress_ database, not elsewhere (#1397)
2:59 AM Ticket #1401 (Deprecate getSRID function) created by strk
getSRID was never deprecated. availability of st_srid is undocumented …
2:45 AM Ticket #1397 (regress test uninstall scripts) reopened by strk
No wonder the count succeeded so easly.. it was counting objects from …
2:37 AM Ticket #1397 (regress test uninstall scripts) closed by strk
fixed
2:36 AM Ticket #1400 (Drop deprecated polygonize and collect aggregates) closed by strk
fixed: Removed in r8504
2:22 AM Ticket #1153 (uninstall script is broken) closed by strk
fixed: r8505 fixes the script manually. Please file another ticket if there …
2:21 AM Changeset [8506] by strk
Fix testing of uninstall script count #1397 This commit also adds …
2:21 AM Changeset [8505] by strk
Fix uninstall script #1153
2:21 AM Changeset [8504] by strk
Deprecate Polygonize and Collect aggregates #1400
2:21 AM Changeset [8503] by strk
Encode dependency of postgis.sql from included scripts
2:21 AM Changeset [8502] by strk
Encode dependency of postgis objects on postgis_config.h Fixes …
2:21 AM Changeset [8501] by strk
Add testing for uninstall_postgis.sql #1397 The uninstall currently …
1:27 AM Ticket #1400 (Drop deprecated polygonize and collect aggregates) created by strk
Both aggregates have been deprecated in 1.2.3:
1:20 AM Ticket #1399 (postgis_drop.sql not being generated) closed by strk
invalid: ok, postgis.sql includes directly the .sql.in.c version so doesn't …
1:20 AM Ticket #1399 (postgis_drop.sql not being generated) created by strk
postgis.sql includes postgis_drop.sql, but postgis_drop.sql is not …
12:23 AM Changeset [8500] by strk
Don't depend on bytea representation for unrelated tests. Fix testing …
12:05 AM Ticket #1396 (No definition of INFINITY on Solaris/GCC) closed by strk
fixed: That file is the only one using INFINITY. In r8499 I changed it to …
12:01 AM Changeset [8499] by strk
Replace INFINITY with MAXFLOAT. Should fix Solaris build #1396 I …

Dec 21, 2011:

9:48 PM Changeset [8498] by pramsey
Move SPI_finish to after elog calls. This seems to fix the regression …
1:49 PM Changeset [8497] by robe
change ST_Reclass example to use less verbose ST_AddBand array syntax
11:26 AM Ticket #1398 (ST_Azimuth, ST_Project regression tests) created by pramsey
Using the Australian web site to generate some "known good" results, …
11:24 AM Ticket #877 (st_estimated_extent returns error on empty table) reopened by pramsey
Something deeply wrong in this fix on OSX, will have to examine... …
11:07 AM Ticket #1305 (ST_Azimuth on the spheroid) closed by pramsey
fixed: Committed at r8496 Regina, could you do the doco-magic on this one, …
11:07 AM Changeset [8496] by pramsey
ST_Azimuth on the spheroid (#1305)
10:42 AM Ticket #657 (Spheroid/Ellipsoid projection given Lat/Lon, Distance & Bearing) closed by pramsey
fixed: Committed at r8495
10:42 AM Changeset [8495] by pramsey
Add ST_Project(geography, distance, azimuth) (#657) to construct a new …
9:16 AM Changeset [8494] by robe
fix typo
9:15 AM Changeset [8493] by strk
Add missing options in the help string
9:09 AM Changeset [8492] by strk
Put staged postgis.sql with other staged intsall objects
8:44 AM Ticket #1397 (regress test uninstall scripts) created by robe
1) Install of postgis without any adding of postgis specific user …
8:27 AM Ticket #1396 (No definition of INFINITY on Solaris/GCC) created by martin
gserialized_gist_2d.c: In function `box2df_distance': …
8:17 AM Changeset [8491] by strk
Document the new -s from:to syntax of shp2pgsql #994
7:29 AM Ticket #1172 (Solaris requires endian macros in liblwgeom for lwin_wkb and lwout_wkb) closed by strk
fixed: No please, file a new one. Possibly with a patch. Thank you !
7:12 AM Ticket #1216 ([raster] Make raster_columns a view) closed by robe
fixed: this is done already and I think it might be a duplicate ticket too.
7:08 AM Ticket #1386 ([raster] raster regress failing on 9.1) closed by robe
fixed: Yes that did fix it.
7:01 AM Ticket #1395 ([raster] Double check skew in rt_raster_gdal_rasterize and ...) created by dustymugs
Need to make sure that skew (if not zero) is properly handled in the …
6:53 AM Changeset [8490] by strk
Add include for lwgeom_typmod_valid define
6:50 AM Changeset [8489] by strk
Add top-level and postgis/ dirs in include path for building scripts …
6:37 AM Changeset [8488] by strk
Use own implementation of endian detection, should fix #1172
6:22 AM Ticket #1394 (Improve speed of geocode_intersection) created by robe
Enough said. Subsequent calls around the same area can be very fast …
6:16 AM Changeset [8487] by strk
Fix repeated modifier
6:04 AM Ticket #1333 (Support geocoding of cross streets) closed by robe
fixed: This is done, but I'll put the improve performance as separate ticket …
6:03 AM Changeset [8486] by strk
Put PostgreSQL module related code in a new postgis_module.c file …
6:00 AM Ticket #1257 (mem_size not dropped by uninstall_legacy.sql) closed by robe
fixed
5:59 AM Changeset [8485] by robe
#1257 - drop mem_size
5:48 AM DevGUC edited by strk
(diff)
5:48 AM Ticket #691 (test_wkt_in_multipoint cunit test failing on mingw) closed by robe
fixed: I'm not sure what this is about anymore, but my cunit tests are all …
5:38 AM Ticket #722 (Remove all functions with ST_ equivalents from core postgis.sql) closed by robe
fixed: this is done enough.
5:37 AM Ticket #969 ([raster] Inconsistent order of named args in ST_MapAlgebra) closed by robe
invalid: I think Pierre was waiting for me to document this before closing out. …
5:23 AM DevGUC created by strk
5:20 AM DevWikiMain edited by strk
(diff)
5:15 AM Ticket #1345 (ST_StartPoint, ST_EndPoint regress failure) closed by robe
fixed: Since apparently I'm the only one who noticed or cares about this …
5:14 AM Changeset [8484] by robe
#1345 write this off as an observed regression difference and document …
5:06 AM Ticket #1242 (Document bug or regression bug - ST_Line_Locate_Point for multilinestring) closed by robe
fixed: wiped out the statement in the docs at r8483 for 1.5 and r8482 for …
5:04 AM Changeset [8483] by robe
#1242 write this off as a documentation bug. I don't have 1.5.1 …
5:03 AM Changeset [8482] by robe
#1242 write this off as a documentation bug. I don't have 1.5.1 …
2:49 AM Ticket #1393 (Evaluate use of GUC for postgis) created by strk
Hooking on the Grand Unified Configuration of PostgreSQL would give us …

Dec 20, 2011:

12:53 PM Ticket #1392 (Can't geocode an intersection that should work) created by arencambre
The attached image is a sample from the tiger_data.tx_edges
11:35 AM Changeset [8481] by strk
Convert java components to SRID<=0 being unknown and 0 being the …
10:51 AM Changeset [8480] by strk
Different types _can_ be equal, see #756
10:51 AM Ticket #756 (ST_Equals(MULTILINE, LINE) fails) closed by strk
fixed: Fixed and regress tested in r8479 for trunk. 1.5 branch isn't affected.
9:42 AM UsersWikiWinUpgrade edited by robe
(diff)
8:59 AM UsersWikiWinUpgrade edited by robe
(diff)
8:57 AM UsersWikiWinUpgrade edited by robe
(diff)
8:56 AM Changeset [8479] by robe
link to windows supplementary hard upgrade instructions
8:51 AM UsersWikiWinUpgrade edited by robe
(diff)
8:50 AM UsersWikiWinUpgrade edited by robe
(diff)
8:49 AM UsersWikiWinUpgrade edited by robe
(diff)
8:48 AM UsersWikiWinUpgrade edited by robe
(diff)
8:48 AM UsersWikiWinUpgrade edited by robe
(diff)
8:47 AM UsersWikiWinUpgrade edited by robe
(diff)
8:47 AM UsersWikiWinUpgrade edited by robe
(diff)
8:47 AM UsersWikiWinUpgrade edited by robe
(diff)
8:44 AM UsersWikiWinUpgrade edited by robe
(diff)
8:44 AM UsersWikiWinUpgrade edited by robe
(diff)
8:42 AM UsersWikiWinUpgrade edited by robe
(diff)
8:41 AM UsersWikiWinUpgrade edited by robe
(diff)
8:39 AM UsersWikiWinUpgrade edited by robe
(diff)
8:37 AM UsersWikiWinUpgrade edited by robe
(diff)
8:36 AM UsersWikiWinUpgrade edited by robe
(diff)
8:36 AM UsersWikiWinUpgrade edited by robe
(diff)
8:35 AM UsersWikiWinUpgrade edited by robe
(diff)
8:20 AM UsersWikiWinUpgrade created by robe
8:10 AM Ticket #1390 (postgis_upgrade.pl should skip postgis function comments) closed by strk
fixed: r8478 adds comments in 2.0 including those for topology and raster, …
8:05 AM FAQ edited by robe
(diff)
8:01 AM Changeset [8478] by strk
Add comments in current version, including topo and raster #1390
7:43 AM Changeset [8477] by strk
Add comments from pgis-1.4 #1390 Also handle pg_restore errors more …
7:18 AM Changeset [8476] by strk
Add more objects from a 1.5 install, including comments #1390
6:11 AM Ticket #1391 (postgis errors during upgrade of old db) created by robe
strk, Here are the errors I see in the db I moved over from my …
5:48 AM Ticket #1390 (postgis_upgrade.pl should skip postgis function comments) created by robe
Comments are of the form: […] As a result, the restore process …
2:56 AM Ticket #1389 (wrong proj4text in spatial_ref_sys for SRID 31300 and 31370 (again)) created by kmaesen
This problem was previously reported in ticket #23 and was fixed. …

Dec 19, 2011:

7:32 PM Ticket #165 ([raster] missing uninstall target) closed by dustymugs
fixed: Added in r8475.
7:28 PM Changeset [8475] by dustymugs
Finished support for make target "uninstall".
6:58 PM Changeset [8474] by dustymugs
Correct handling of make target "distclean". Next is "uninstall".
4:22 PM Ticket #1388 ([raster] add regression tests for raster2pgsql) created by dustymugs
Add loader regression tests since shp2pgsql has regression tests.
11:21 AM Ticket #994 (-r used in shp2pgsql and pgsql2shp to mean two different things) closed by strk
fixed: committed as r8472 and r8473
11:21 AM Changeset [8473] by strk
Update loader tests to use the new reprojection switch #994
11:06 AM Changeset [8472] by strk
Drop -r switch, allow requesting reprojection with -s #994
10:56 AM DevWikiWinMingWSys_20 edited by robe
(diff)
10:53 AM Ticket #1387 (Add Bborie to Hudson mail) closed by chodgson
fixed: I've put dustymugs' e-mail into hudson. I don't believe that the …
8:28 AM Ticket #859 (shp2pgsql new option to do something with bad geometries.) closed by strk
worksforme: I think what we should _do_ with bad geometries is: load them. As of …
8:19 AM Ticket #1146 (/trunk/doc/html/image_src/generator.c crashes when provided with ...) closed by strk
fixed: Committed slightly modified patch in r8470 (the calloc call was invalid)
8:19 AM Changeset [8471] by strk
Make sure input is at least 3 characters long (#1146)
8:19 AM Changeset [8470] by strk
Report testing of pg-8.4.9/pgis-2.0.0SVN => pg-9.1.2/pgis-2.0.0SVN
4:28 AM Ticket #1367 (Provide a clear upgrade path to 2.0) closed by strk
fixed: r8469 documents the procedure in the existing HARD UPGRADE section of …
4:27 AM Changeset [8469] by strk
Document postgis_restore.pl based HARD UPGRADE procedure Reviews are …
1:07 AM Changeset [8468] by strk
Allow keeping rows in spatial_ref_sys at postgis_restore.pl time …
12:18 AM Changeset [8467] by strk
Fix SRIDs in topology.topology after restore.

Dec 18, 2011:

11:07 PM Ticket #1387 (Add Bborie to Hudson mail) created by robe
I'm seeing error in hudson logs […] So I assume Bborie is not …
10:33 PM Changeset [8466] by robe
bump up numbers. logic to drop raster casts from extension if they …
9:00 PM Changeset [8465] by robe
get rid of superfluous drop if exists _drop_st_samealignment
8:56 PM Changeset [8464] by dustymugs
Fixed to suppress PL/pgSQL notices causing issues due to line # …
8:48 PM Changeset [8463] by robe
revise upgrade script to take into consideration change in casts
8:29 PM Ticket #1386 ([raster] raster regress failing on 9.1) created by robe
I haven't tried on my others -- tests failing are …
8:12 PM Changeset [8462] by robe
replace box2d with box3d in examples and remaining func
7:44 PM Changeset [8461] by robe
Clarify topology topoelement example that it is an example of WHAT NOT …
7:37 PM Changeset [8460] by robe
replace references to box2d with box3d
6:18 PM Changeset [8459] by robe
get rid of remove ST_Intersection signatures and replace with new …
5:59 PM Changeset [8458] by robe
update faq for raster to bring it more up to line with new loading , …
5:53 PM Changeset [8457] by dustymugs
Refactored and cleaned up the regressions checks of values in …
3:02 PM Changeset [8456] by strk
Document darkblue test: pg-9.1b3/pgis-1.5 to pg-9.1.1/pgis-2.0.0SVN
2:42 PM Changeset [8455] by strk
Do not expect things to happen in "userland" schema (what is it?)
2:34 PM Ticket #877 (st_estimated_extent returns error on empty table) closed by strk
fixed
10:49 AM Changeset [8454] by robe
put in missing tag
10:05 AM Changeset [8453] by robe
add in some missing raster2pgsql switches and provide an example of …
9:12 AM Ticket #1350 ([raster] GDALPolygonize not being set to 1 when compiling with GDAL 1.9) closed by robe
fixed: Bborie, Thanks -- setting the LDFLAGS environment variable seems to …
6:25 AM Ticket #1385 (ST_Extent() segfaults on null geometries) closed by strk
fixed: Fixed in r8451, thanks !
6:24 AM Changeset [8452] by strk
Update after typo fix for AddGeometryColumn? error message
6:22 AM Changeset [8451] by strk
Fix st_extent on empty relation (#1385)
4:06 AM Ticket #1385 (ST_Extent() segfaults on null geometries) created by rouault
The following sequence causes a crash in BOX3D_combine(), line 348, on …

Dec 17, 2011:

9:08 PM Ticket #1382 (Some addresses take a long time to geocode or normalize) closed by robe
fixed: I'm closing this ticket out and continuing on #1384.
9:07 PM Ticket #1384 (Issue with geocoding addresses where place name doesn't match) created by robe
Example boroughs of NY. Tiger just has these as New York , NY. This …
2:56 PM Ticket #1383 (Topology: ST_AddEdgeNewFaces() fail to add an edge) created by aperi2007
Hi, Im having an error try-ing to insert a new edge on a building …
1:00 PM Changeset [8450] by strk
AddGeometryColumns? => AddGeometryColumn?
8:34 AM Ticket #1147 (geocoded points bunching up northwards) closed by robe
duplicate: this is a dupe of #1052

Dec 16, 2011:

5:50 PM Changeset [8449] by robe
fix typo
4:11 PM Ticket #1378 ([raster] Add regression tests for AddRasterConstraints and ...) closed by dustymugs
fixed: Regression tests added in r8448
2:07 PM Changeset [8448] by dustymugs
Minor comment cleanup in rtpostgis.sql.in.c. Added regression tests …
1:12 PM Ticket #1382 (Some addresses take a long time to geocode or normalize) created by raviada
Regina, Thanks for helping me on this, normalize_address return slow …
11:32 AM Ticket #1341 ([raster] Integrate ST_Clip script into rtpostgis.sql) closed by dustymugs
duplicate: Duplicate of #597. Discussion will continue there.
9:30 AM Ticket #1173 (TopologyException from intersection of valid geography) reopened by jgilman
The geography described by those points is not invalid. The …
9:20 AM Changeset [8447] by strk
Do restore spatial_ref_sys from dump, temporarly disabling srid check …
8:39 AM Changeset [8446] by strk
Add more signatures to skip on restore (raster)
8:33 AM Ticket #1327 ([raster] ST_AsRaster invalid memory alloc request size) closed by dustymugs
fixed: I believe your test works now so I'm closing this ticket.
8:09 AM Ticket #1239 ([raster] A warning message makes psql to hang) closed by dustymugs
wontfix: Insufficient information to fully investigate this issue. I'm …
7:23 AM Ticket #1045 (TopologyException if I don't use ST_Dump to resolve single geometries ...) closed by strk
worksforme: Works here with GEOS-3.3.2: […] What version of GEOS are you using …
7:18 AM Ticket #1173 (TopologyException from intersection of valid geography) closed by strk
invalid: The first operand is really invalid: […]
7:16 AM Changeset [8445] by strk
Report full exception string on ST_Intersection failure (see #1173)
7:02 AM Ticket #294 (Rationalize support for EMPTY) closed by strk
fixed: This is completed as of r8415
6:59 AM Changeset [8444] by strk
Add test for #1344 (can't dump invalid geometries)
6:57 AM Ticket #1344 (ST_MakeLine fails for export with pgsql2shp) closed by strk
fixed: Fixed by r8443
6:56 AM Changeset [8443] by strk
Allow exporting tables with invalid geometries (#1344)

Dec 15, 2011:

8:34 PM Changeset [8442] by robe
fix more typos
8:27 PM Changeset [8441] by robe
more typo fix
8:24 PM Changeset [8440] by robe
fix more typos
8:21 PM Changeset [8439] by robe
flesh out creating rasters section a bit.
5:41 PM Changeset [8438] by robe
start best practices stuff and break up loading and creating into two …
5:25 PM Changeset [8437] by robe
cosmetic change to lists
5:11 PM Ticket #1298 ([raster] ST_MinPossibleValue) closed by dustymugs
fixed: Added in r8436
5:11 PM Changeset [8436] by dustymugs
Addition of C-based ST_MinPossibleValue to replace the existing …
4:09 PM Changeset [8435] by dustymugs
Just changes to the comments of ST_Intersection(geometry, raster)
4:04 PM WKTRaster/SpecificationWorking03 edited by dustymugs
ST_Intersection(raster, raster) and ST_Intersection(raster, geometry) (diff)
3:47 PM Ticket #1381 ([raster] two-raster ST_Intersection) closed by dustymugs
fixed: Committed in r8434. Final specs will be found in the working specs: …
3:47 PM Changeset [8434] by dustymugs
Addition of two-raster ST_Intersection function set in raster-space …
3:43 PM Changeset [8433] by dustymugs
Renamed function parameters for ST_SameAlignment and ST_Intersects so …
3:29 PM Ticket #1320 (typmod geometry type not changing in before trigger) closed by strk
fixed: r8431 fixes this case. I've found the culprit for calls to LWGEOM_in …
3:29 PM Changeset [8432] by strk
Allow calling geography_in with less than 3 args (see #1320)
3:26 PM Changeset [8431] by strk
Check typmod on geometry input. Fixes before triggers (#1320)
10:00 AM Ticket #1380 (Hudson has fallen again) closed by chodgson
fixed: kicked. (killed the long-running pdflatex command)
7:11 AM Changeset [8430] by strk
Fix documentation for the new option for GML box output
6:56 AM Ticket #1000 (box3d_extent output is 2d, casted to box3d makes up random numbers) closed by strk
fixed: Seems fixed as of r8414
6:55 AM Ticket #459 (GML Envelope) closed by strk
fixed: Both unit tests and documentation are ready.

Dec 14, 2011:

7:45 PM Ticket #1381 ([raster] two-raster ST_Intersection) created by dustymugs
Related spec is FV.14 with the addition of a geometry parameter being …
6:26 PM Ticket #952 (Document new raster analytic and processing functions in official docs) closed by robe
fixed: pretty much done with this too.
6:25 PM Ticket #960 ([raster] Start reducing number of functions by using defaults) closed by robe
fixed: I think this is pretty much done so closing it out.
6:21 PM Ticket #1380 (Hudson has fallen again) created by robe
I think I put in documentation changes that have made hudson mad. …
6:19 PM Changeset [8429] by robe
more error fixes and change ordered lists to itemized lists
6:17 PM Changeset [8428] by robe
fix invalid link end
6:15 PM Changeset [8427] by robe
get rid of extra tag
6:14 PM Changeset [8426] by robe
correct regular_blocking definition, add descriptions for …
5:56 PM Changeset [8425] by robe
more reasons why we have raster overviews
5:54 PM Changeset [8424] by robe
Start raster_overviews section
4:24 PM Ticket #1372 (Update with rtpostgis_upgrade_20_minor.sql causes error) closed by dustymugs
fixed: Fixed in r8389
4:22 PM Ticket #1003 ([raster] st_bytea should be renamed to bytea) closed by dustymugs
fixed: Committed in r8423. Will need to resolve how to upgrade existing …
4:21 PM Changeset [8423] by dustymugs
Renamed st_bytea to bytea as per PostGIS convention. Existing …
4:16 PM Changeset [8422] by dustymugs
Commented out the dropping of box2d casts as the upgrade scripts won't …
3:52 PM Ticket #633 ([raster] st_above, st_below, st_right whatever make raster_above, ...) closed by dustymugs
fixed: Fixed in r8421. Will need to decide on how to handle upgrades …
3:51 PM Changeset [8421] by dustymugs
Renamed operator functions and made appropriate changes to associated …
3:03 PM Ticket #1379 ([raster] raster2pgsql: load a raster as a band(s) of an existing raster) created by chdemars
It would be nice to be able to load a raster as a band of an existing …
3:02 PM Changeset [8420] by dustymugs
Added DROP CAST and DROP FUNCTION for box2d.
2:58 PM Ticket #1330 ([raster] change casts to box3d) closed by dustymugs
fixed: fixed in r8419.
2:57 PM Changeset [8419] by dustymugs
Dropped casts to box2d and replaced with casts to box3d. Associated …
2:37 PM Ticket #1378 ([raster] Add regression tests for AddRasterConstraints and ...) created by dustymugs
Add regression tests for AddRasterConstraints? and DropRasterConstraints?.
2:32 PM Ticket #1049 ([raster] ST_SetBandNoDataValue change to use default args) closed by dustymugs
fixed: If forcechecking is TRUE, the band specified is inspected pixel by …
2:24 PM Ticket #1374 ([raster] raster2pgsql: option to list supported raster types) closed by dustymugs
fixed: Added in r8418.
2:24 PM Ticket #1375 ([raster] raster2pgsql: add ability to specify ranges of band indices ...) closed by dustymugs
fixed: Added in r8418.
2:24 PM Ticket #153 ([raster] raster2pgsql: check for same pixelsize when loading using wildcard) closed by dustymugs
fixed: Added in r8418.
2:23 PM Changeset [8418] by dustymugs
Added option -G to get listing of supported raster types instead of …
2:14 PM Changeset [8417] by robe
document raster_columns catalog view
11:52 AM DevFOSS4GCodeSprintNotes edited by robe
(diff)
11:51 AM DevFOSS4GCodeSprintNotes edited by robe
(diff)
11:50 AM DevFOSS4GCodeSprintNotes edited by robe
(diff)
10:45 AM Ticket #1377 (GML for empty geometries should be NULL) created by strk
EMPTY geometries can't be represented with a valid GML, so NULL should …
10:33 AM Changeset [8416] by strk
Make dropping of log files fully controlled by switch (#1376) This is …
10:26 AM Ticket #692 (Add regression tests for OGC predicates vs EMPTY cases) closed by strk
fixed: Fixed with r8415. I taken all of the advertised requests, not …
10:25 AM Changeset [8415] by strk
Regress test all behaviors involving EMPTY geometries See …
10:24 AM Changeset [8414] by strk
Crossref ST_InteriorRingN with ST_ExteriorRing
9:59 AM DevWikiEmptyGeometry edited by strk
InteriorRingN and ExteriorRing? were meant to be called on empty, not … (diff)
9:51 AM DevWikiEmptyGeometry edited by strk
ST_RingN doesn't exist, ST_ExteriorRing and ST_InteriorRingN do (diff)
9:49 AM DevWikiEmptyGeometry edited by strk
ST_NumRings doesn't exist, ST_NRings does (diff)
9:30 AM DevWikiEmptyGeometry edited by strk
forget what I said.. (diff)
9:28 AM DevWikiEmptyGeometry edited by strk
(diff)
9:13 AM Changeset [8413] by strk
Drop temporary files if there are no failures (#1376)
8:06 AM Ticket #681 (ST_AsGML and ST_AsKML crashes on POLYGON EMPTY or acts really bizarre) closed by strk
fixed: Anyway, the crashers are gone so please file another ticket if you …
8:02 AM Changeset [8412] by strk
Fix crash on ST_AsGML('POLYGON EMPTY') (#681) Also tweak GML of empty …
7:56 AM Ticket #1376 (cleanup /tmp/ after run_test) created by strk
It's annoying to have /tmp full of leftover files when the regression …
7:20 AM Ticket #1343 ([raster] raster Upgrade script doesn't work because of new type) closed by robe
fixed: this works for me now cleanly. Though puzzled what kind of issue …
7:14 AM Ticket #1375 ([raster] raster2pgsql: add ability to specify ranges of band indices ...) created by dustymugs
As per suggestion in PostGIS IRC channel, have -b support specifying …
7:11 AM Ticket #1374 ([raster] raster2pgsql: option to list supported raster types) created by dustymugs
Add flag to output what raster types are supported by the loader and …
7:07 AM Changeset [8411] by strk
Fix a typo from last commit, stub test for GML emptyness
6:46 AM Changeset [8410] by strk
Enable a test for an old bugfix (#683)
6:46 AM Changeset [8409] by strk
Move the EMPTY buffer test from tickets.sql to empty.sql
6:38 AM Ticket #1089 (ST_SnapToGrid(EMPTY) returns NULL) closed by strk
fixed
6:37 AM Changeset [8408] by strk
Return empty geoms snapped to a grid as immutated (#1089) Also …
6:25 AM Changeset [8407] by robe
minor corrections / enhancements
5:31 AM Changeset [8406] by strk
Drop topology specific versioning
5:31 AM Changeset [8405] by strk
Add more skip signatures, from interim builds
3:22 AM Changeset [8404] by robe
minor change to rtpostgis_drop so can more easily drop from extension …
2:44 AM Changeset [8403] by robe
fix errors in documentation and comment scripts preveningt comments …
2:06 AM Changeset [8402] by robe
Get rid of removed AddRasterTable?,Column etc and replace with newer …

Dec 13, 2011:

11:59 PM Changeset [8401] by strk
Add -v switch to postgis_restore.pl, tweak usage and debug output
6:54 PM Changeset [8400] by robe
Add stub section describing the raster_columns and raster_overview …
6:31 PM Changeset [8399] by dustymugs
As per discussion in postgis-devel regarding Ubuntu 11.10, tweaked the …
5:22 PM Changeset [8398] by dustymugs
Refactored for less memory usage by aggresively flushing string buffers.
3:30 PM Ticket #1371 (postgis_restore.pl: insert or update on table "layer" violates foreign ...) closed by strk
fixed: The disabling/enabling revealed successful. Didn't test with a dump …
3:29 PM Changeset [8397] by strk
Disable triggers on the topology.layer table during restore, to allow …
3:22 PM Ticket #1373 (Can't apply Scale Y constraint -- raster2pgsql) closed by dustymugs
fixed: Fixed in r8396.
3:21 PM Changeset [8396] by dustymugs
As per discussion in ticket #1373, convert raster constraints with …
2:39 PM Changeset [8395] by robe
Add -Y copy switch
2:00 PM Ticket #1106 (OpenJump (JTS): Unknown WKB type 48) closed by pramsey
invalid
1:58 PM Changeset [8394] by robe
more examples -- put in a missing copy switch -- more switches to add.
1:34 PM Ticket #1373 (Can't apply Scale Y constraint -- raster2pgsql) created by robe
Bborie, This may be my misunderstanding, but assuming its a bug I …
1:19 PM Changeset [8393] by dustymugs
Fixed handling of output ranges going from high to low rather than the …
12:48 PM Ticket #1370 ([raster] undefined references to GDAL library) closed by strk
fixed: confirmed. thanks.
12:05 PM Changeset [8392] by dustymugs
Fixed incorrect entity using_raster_dataman.
11:15 AM Changeset [8391] by robe
break raste loder into its own data management chapter -- this chapter …
10:19 AM Changeset [8390] by dustymugs
Removal of now-unsupported AddRasterColumn?, DropRasterColumn? and …
10:16 AM Changeset [8389] by dustymugs
Added DROP AGGREGATE for new ST_Union signature. Associated ticket is …
10:05 AM Ticket #1372 (Update with rtpostgis_upgrade_20_minor.sql causes error) created by cgsbob
I just updated to r8388. When I upgrade my db with …
9:24 AM Changeset [8388] by dustymugs
Removed PGXS and added explicit bin path variable. Works now in 8.4, …
8:42 AM Ticket #1371 (postgis_restore.pl: insert or update on table "layer" violates foreign ...) created by strk
Restoring a dump containing topologies using postgis_restore.pl gives …
8:37 AM Changeset [8387] by strk
Drop the old postgis_restore.pl and substitute it with the new one
8:33 AM Changeset [8386] by strk
Ignore more Makefiles
8:33 AM Changeset [8385] by strk
Strictness fixes, internal docs
7:56 AM Ticket #1370 ([raster] undefined references to GDAL library) reopened by strk
Oops, sorry, I had local modifications to Makefile. It still fails as …
7:54 AM Ticket #1370 ([raster] undefined references to GDAL library) closed by strk
fixed: works here
7:04 AM Changeset [8384] by dustymugs
Revert change made in r8383. Install of loader doesn't work correctly …
6:14 AM Changeset [8383] by dustymugs
Removed PGXS as per ticket #1370.
4:01 AM Ticket #1123 (Create a legacy_compatibility_layer.sql.in.c) closed by robe
fixed: Yes we still do. Doesn't your script leave out functions dropped? …
4:00 AM Changeset [8382] by strk
Maintain the buffer-returns-areal invariant on empty input (#322)
4:00 AM Changeset [8381] by strk
tabs to spaces
4:00 AM Ticket #322 (Support all typologies of EMPTY (POINT EMPTY, LINESTRING EMPTY, ...) closed by strk
fixed: The low-level support for this is in there. Any broken result should …
3:30 AM Ticket #1370 ([raster] undefined references to GDAL library) created by strk
[…] Many more. As of r8375
2:40 AM Ticket #1097 (postgis upgrade scripts not outputting geometry_columns) closed by strk
fixed: Fixed in r8380. I suspect the major version parts are all broken. At …
2:38 AM Changeset [8380] by strk
Always output create ore replace view in upgrade scripts (#1097)
2:21 AM Ticket #103 (Box3D always gets cast to 2D geometry) closed by strk
wontfix: Ticket #1329 obsoletes this one, as the only reason why you'd want to …
1:59 AM Ticket #1365 (postgis_upgrade_20_minor.sql is broken) closed by strk
fixed: This is now fixed as r8379
1:59 AM Changeset [8379] by strk
Allow function definitions to end with '$$ LANGUAGE' (#1365)
1:59 AM Changeset [8378] by strk
Use warnings
1:58 AM Changeset [8377] by strk
Encode dependency of upgrade script from the tool generating it
1:16 AM Changeset [8376] by strk
Add copyright headers, looking at SCM logs. Review welcome.

Dec 12, 2011:

9:23 PM Changeset [8375] by dustymugs
Text format cleanup in loader/raster2pgsql.c. Fixed missing target in …
9:20 PM Ticket #1016 ([raster] make raster2pgsql accept user-specified padding value) closed by dustymugs
fixed: In the new default raster2pgsql loader, use -N to specify the NODATA value.
9:12 PM Ticket #1369 ([raster] raster2pgsql missing help version info) closed by dustymugs
fixed: Added in r8372.
9:11 PM Changeset [8374] by dustymugs
Added missing Makefile.in for raster/scripts
9:06 PM Changeset [8373] by dustymugs
Set svn:keywords for "$Id$"
9:03 PM Changeset [8372] by dustymugs
Added version information. Associated ticket is #1369.
8:38 PM Ticket #970 ([raster] Cannot assume only one Python on system) closed by dustymugs
wontfix: Python no longer a dependency for PostGIS Raster.
8:26 PM Ticket #1356 ([raster] srid in raster_columns view is zero) closed by dustymugs
invalid: Invalid as behavior is as expected when no SRID constraint is set.
8:26 PM Ticket #1187 ([raster] DropRasterTable/DropRasterColumn doesn't remove table overviews) closed by dustymugs
wontfix: Won't fix as DropRasterColumn? and DropRasterTable? will be dropped in …
8:24 PM Ticket #989 ([raster] gdal2wktraster.py has trouble with GRD files) closed by dustymugs
wontfix: Won't fix as Python is no longer required as of r8369 as the Python …
8:23 PM Ticket #766 ([raster] The raster2pgsql.py -M option should just do an ANALYSE) closed by dustymugs
fixed: In the C-base raster2pgsql, adding a GIST index automatically adds an …
8:19 PM Ticket #1151 ([raster] raster2pgsql.py -l option is broken) closed by dustymugs
wontfix: raster2pgsql.py is now unsupported. If the same issue exists in the …
8:18 PM Ticket #825 ([raster] raster overview -- trying to insert into wrong table (if ...) closed by dustymugs
wontfix: No longer valid as raster_overview is a view now instead of table. …
8:14 PM Ticket #1369 ([raster] raster2pgsql missing help version info) created by robe
Bborie, Just noticed the help screen on raster2pgsql when I run …
7:00 PM Changeset [8371] by dustymugs
With commit of C-based raster2pgsql in r8369, removed dependency …
5:58 PM Changeset [8370] by dustymugs
Additional check with warnings if PostgreSQL identifiers exceed the …
3:12 PM Ticket #1297 ([raster] C version of raster2pgsql) closed by dustymugs
fixed: Committed in r8369.
3:12 PM Changeset [8369] by dustymugs
Addition of C-based raster2pgsql in raster/loader. No changes have …
2:42 PM Changeset [8368] by strk
Skip constraints on raster_columns and raster_overviews
2:38 PM Changeset [8367] by robe
fix title
2:22 PM Changeset [8366] by strk
Rewrite spatial table constraints to add st_ prefix and use 0 rather …
1:46 PM Ticket #1368 (ERROR: operator does not exist: hstore @ hstore) closed by strk
fixed: r8365 fixes this. Now that I feel the superpowers I'll move on to also …
1:45 PM Changeset [8365] by strk
Filter OPERATOR at the ASCII dump phase to have finer control over …
12:32 PM Changeset [8364] by robe
another example of ST_Union
12:23 PM Changeset [8363] by robe
example of ST_Union
8:11 AM Ticket #1362 (Remove lwgeom_gist.c) closed by strk
fixed: Done in r8362. There were no much dependent objects. There are still …
8:10 AM Changeset [8362] by strk
Drop lwgeom_gist and dependent items, including from dumps (#1362)
8:02 AM Ticket #1368 (ERROR: operator does not exist: hstore @ hstore) created by strk
The *postgis_restore.pl family of function try to avoid restoring …
7:52 AM Ticket #1367 (Provide a clear upgrade path to 2.0) created by strk
We need a way to upgrade an existing spatial database to 2.0 w/out …
7:49 AM Ticket #1360 (Update new_postgis_restore.pl) closed by strk
fixed: With r8361 this script is pretty complete. There are still problems …
7:45 AM Changeset [8361] by strk
Do not restore metadata tables which now became views
7:28 AM Changeset [8360] by strk
Cleanup item list: drop duplicates, add some missings
7:28 AM Changeset [8359] by strk
Remove duplicated entries, add some missing ones
4:17 AM Changeset [8358] by robe
reduce ST_MakeEnvelope down to one function but make srid default to 0 …
4:09 AM Changeset [8357] by robe
oops took out a tag by accident
4:03 AM Changeset [8356] by robe
document the new ST_MakeEnvelope variant (pretend like its used …

Dec 11, 2011:

6:20 PM Ticket #1366 (geocode_intersection returns nothing with lowercase state) closed by robe
fixed: fixed at r8355
6:20 PM Changeset [8355] by robe
#1366 -- don't rely on state field being capitalized.
6:13 PM Ticket #1366 (geocode_intersection returns nothing with lowercase state) created by arencambre
If I run this: […] ...I get no results. If I run this: […] …
12:23 PM Changeset [8354] by robe
forgot about max /min
12:21 PM Changeset [8353] by robe
change generateor to display name for aggregates instead of id. For …
11:47 AM Ticket #1365 (postgis_upgrade_20_minor.sql is broken) created by robe
Did someone change the perl script to upgrade minor. It's outputing …
11:29 AM Changeset [8352] by robe
preliminary documentation for raster version of ST_Union aggregate function
7:45 AM Changeset [8351] by robe
Revisions to ST_Union for raster: get rid of dependency on rastexpr …

Dec 10, 2011:

6:42 PM Changeset [8350] by robe
fix function name typo in geocode_intersection
10:08 AM Changeset [8349] by robe
minor edit
10:03 AM Changeset [8348] by robe
fix error in logic
9:34 AM WKTRaster/SpecificationWorking03 edited by dustymugs
(diff)
9:01 AM WKTRaster/SpecificationWorking03 edited by dustymugs
(diff)
8:57 AM WKTRaster/SpecificationWorking03 edited by dustymugs
(diff)
8:56 AM Changeset [8347] by robe
missed a spot
8:55 AM Changeset [8346] by robe
describe the example a bit better for ST_AddBand multi-band example
3:09 AM Changeset [8345] by robe
#1361: fill in some more cases where hard/soft
3:05 AM Ticket #1361 (Release notes should include notice about upgrading) closed by robe
fixed: fixed at r8344
3:04 AM Changeset [8344] by robe
#1361: make it clearer that a hard upgrade is required of everyone.
2:38 AM Ticket #1364 ([raster] Make ST_Union a c-implementation) created by robe
Bborie, Just putting this on the list before I forget to. I'm still …
2:20 AM Ticket #1363 ([raster] convert ST_AddBand array version to C) created by robe
As noted in #1245, I've implemented this in plpgsql to satisfy my need …
12:42 AM DevWikiWinMingW64 edited by robe
(diff)
12:38 AM DevWikiWinMingW64 edited by robe
(diff)
12:37 AM DevWikiWinMingW64 edited by robe
(diff)
12:16 AM DevWikiWinMingW64 edited by robe
(diff)
12:12 AM DevWikiWinMingW64 edited by robe
(diff)

Dec 9, 2011:

8:49 PM WKTRaster/SpecificationWorking03 edited by dustymugs
(diff)
8:46 PM WKTRaster/SpecificationWorking03 edited by dustymugs
raster_overviews (diff)
8:18 PM WKTRaster/SpecificationWorking03 edited by dustymugs
(diff)
7:59 PM WKTRaster/SpecificationWorking03 edited by dustymugs
(diff)
7:55 PM WKTRaster/SpecificationWorking03 edited by dustymugs
(diff)
7:52 PM WKTRaster/SpecificationWorking03 edited by dustymugs
Addition of raster_columns view. (diff)
7:14 PM Ticket #1245 ([raster] ST_AddBand that can build a multi band raster from an array ...) closed by robe
fixed: plpgsql version added at r8343. Would be nice to convert to C as it …
7:12 PM Changeset [8343] by robe
ST_AddBand version that takes an array of rasters
5:20 PM Changeset [8342] by dustymugs
Fixed calls to the wrong memory allocation function in rtpg_XXX …
5:01 PM Changeset [8341] by dustymugs
Code refactoring in rtpg_ utility functions for better memory usage …
5:00 PM Changeset [8340] by dustymugs
Fixed missing $ in AddOverviewConstraint?() which was setting 7 as the …
12:34 PM Ticket #1362 (Remove lwgeom_gist.c) created by pramsey
This file includes obsoleted index bindings from the 1.5 …
12:11 PM Ticket #1309 (gserialized_read_gbox_p: Conditional jump or move depends on ...) closed by pramsey
fixed
10:59 AM Changeset [8339] by strk
Add all signatures found in a newly created PostGIS 2.0 database See #1360
9:53 AM Ticket #1361 (Release notes should include notice about upgrading) created by strk
The Upgrading chapter of the postgis manual says that release notes …
9:23 AM Ticket #1360 (Update new_postgis_restore.pl) created by strk
There seem to be lot of items to add to new_postgis_restore.pl. I …
9:19 AM Ticket #1359 (Cleanup after box3d_extent removal) closed by strk
fixed: r8338 adds the skips to posgis_restore.pl and new_postgis_restore.pl …
9:17 AM Changeset [8338] by strk
Add box3d related objects to skip in the _restore scripts (#1359)
8:41 AM Ticket #1359 (Cleanup after box3d_extent removal) created by strk
Now that box3d_extent is gone (r8324) we need a way, possibly, to get …
8:38 AM Ticket #1001 (box3d(box3d_extent) is not unique) closed by strk
fixed: box3d_extent doesn't exist anymore as of r8324
8:33 AM Ticket #1351 (ST_Buffer around A LINESTRING crashes the database) closed by strk
fixed
8:27 AM Changeset [8337] by strk
Restrict disabled code to the one really hurting See ticket #665 for …
7:33 AM Changeset [8336] by strk
gbox_float_round: don't roundup Z value if the box doesn't have one …
6:37 AM Ticket #1324 (Provide a function to read an LWGEOM bounding box and stop reading it ...) closed by strk
fixed: r8335 make the new function public
6:37 AM Changeset [8335] by strk
Add a public lwgeom_get_bbox function (#1324)
6:37 AM Changeset [8334] by strk
Don't let lwgeom_add_bbox syntetize a fake box for empty geometries …
5:52 AM Ticket #1323 (lwgeom_extent_to_gml3 segfaults when passed an LWGEOM with no BBOX cache) closed by strk
fixed: Fixed by r8333, which includes comprensive regress testing. The EMPTY …
5:50 AM Changeset [8333] by strk
Fix segfault in GML3 extent output (#1323) Add support for …
5:05 AM Ticket #1358 (Have notices/errors shown by unit tests) closed by strk
invalid: I was wrong, the messages are there, just printed out of context so …
5:01 AM Ticket #1358 (Have notices/errors shown by unit tests) created by strk
It looks like errors and notices aren't printed by unit tests. Doesn't …
4:29 AM Ticket #1266 (postgis_gdal_version missing) closed by strk
fixed: r8101 fixed this properly
4:25 AM Ticket #1339 (ST_MakeEnvelope should have an option to not take an srid) closed by strk
fixed: Fixed in r8332
4:25 AM Changeset [8332] by strk
Allow calling ST_MakeEnvelope w/out a srid (#1339)
3:18 AM Ticket #1357 (Use gbox_overlap where appropriate) closed by strk
fixed: As of r8331 I added a gbox_overlaps_2d and used that within …
3:18 AM Changeset [8331] by strk
Add a gbox_overlaps_2d function, use when appropriate (#1357)

Dec 8, 2011:

2:22 PM Changeset [8330] by pramsey
Guard GEOS from NaN and InF values in coordinates. (#627)
2:19 PM Ticket #627 (PostGIS/PostgreSQL process terminates on invalid geometry) closed by pramsey
fixed: Guarded in 1.5 at r8329.
2:19 PM Changeset [8329] by pramsey
Guard GEOS from NaN coordinate values. (#627)
2:16 PM Changeset [8328] by pramsey
Guard against NaN values in coordinates passing into GEOS (#627)
1:57 PM Changeset [8327] by pramsey
Check that NaN coordinate values find their way into bboxes, they do, …
1:52 PM Ticket #987 (Bad handling of Inf values in GEOS) closed by pramsey
fixed: This seems to have been applied to trunk also. Closing out.
1:26 PM Changeset [8326] by pramsey
Test for bbox calculations when there's an infinite coordinate.
1:08 PM Ticket #1357 (Use gbox_overlap where appropriate) created by strk
In r8323 a manually crafted "box overlap" is implemented. It would be …
1:06 PM Ticket #542 ([raster] raster2pgsql.py should not set regular_blocking to true when ...) closed by dustymugs
wontfix: As regular_blocking is now an "informational" constraint explicitly …
12:56 PM Ticket #470 (ST_Centroid/ST_X Memory Leak?) closed by pramsey
worksforme
12:55 PM Ticket #152 ([raster] raster_columns out-db field should be an array) closed by dustymugs
wontfix: The field out_db field no longer exists in raster_columns. It may …
12:05 PM Changeset [8325] by dustymugs
Return use of GDAL "natural" blocking removed in r8313 and refactor …
11:51 AM Changeset [8324] by pramsey
Remove box3d_extent hack
11:46 AM Ticket #1356 ([raster] srid in raster_columns view is zero) created by bnordgren
Not sure if this is a bug or not. As of r8322, I tried: […] …
9:54 AM Changeset [8323] by pramsey
Make the ST_Equals test insensitive to minor box differences.
6:44 AM Changeset [8322] by robe
Add Jose and Even to credits
5:35 AM Changeset [8321] by strk
Add a note about ST_Estimated_Extent on empty or non-analyzed tables (#877)
5:34 AM Changeset [8320] by strk
Add a note about ST_Estimated_Extent on empty or non-analyzed tables (#877)
3:29 AM Changeset [8319] by strk
Have ST_Estimated_Extent return NULL when no stats are found for a …
3:28 AM Changeset [8318] by strk
Hush VACUUM and ANALYZE backend feedback while running tests
3:25 AM Changeset [8317] by strk
Have ST_Estimated_Extent return NULL when no stats are found for a …
3:24 AM Changeset [8316] by strk
Hush VACUUM and ANALYZE feedbacks while running tests
12:07 AM Changeset [8315] by strk
topology.AddToSearchPath?: quote database identifier. Thanks to Jose …

Dec 7, 2011:

1:03 PM Ticket #1355 (Normalizing internal addresses with non-numeric unit identifier strips ...) created by bpanulla
Normalizing an address with an internal component that starts with a …
12:46 PM Changeset [8314] by dustymugs
Added rt_raster_set_pixel_line for use when setting values for …
11:30 AM Ticket #1354 (Problems geocoding addresses containing "ST STE") created by bpanulla
The geocoder gets confused by addresses with a type of "ST" followed …
11:05 AM Ticket #1353 ([raster] ST_SetRotation incorrect) created by bnordgren
SetRotation does not preserve the angle between the basis vectors. …
7:29 AM Changeset [8313] by dustymugs
Refactored the GDALRasterIO part of rt_raster_from_gdal_dataset to use …

Dec 6, 2011:

10:17 PM Changeset [8312] by robe
alphabetize and update tester credits
7:41 PM Changeset [8311] by robe
update license to provide detail about documentation license and …
6:59 PM Ticket #841 (Commiter Responsibilities Guidelines) closed by robe
fixed: I'm going to close this out since I think we have all agreed to the …
6:58 PM Ticket #1352 (License review of data samples and docs) created by robe
review data samples used in docs and regression tests and note in …
5:15 PM Changeset [8310] by dustymugs
Fixed regression issue with rt_raster_from_gdal_dataset by explicitly …
8:48 AM Changeset [8309] by dustymugs
Removed attempt to duplicate entire band in rt_raster_from_gdal_dataset
6:40 AM Changeset [8308] by robe
put some obsolete notes in existing management functions. Now that …
5:46 AM Ticket #1351 (ST_Buffer around A LINESTRING crashes the database) created by royl
The attached query attempts to create a buffer around a LINESTRING. …
4:16 AM Changeset [8307] by strk
Add copyright header. Date and attribution looked up by SCM history. …

Dec 5, 2011:

10:06 PM Changeset [8306] by dustymugs
Resolved a bunch of memory issues related to use of SPI that have been …
4:45 PM Ticket #1336 ([raster] Problem with ST_AsRaster() alignment) closed by dustymugs
fixed
2:00 PM Ticket #1350 ([raster] GDALPolygonize not being set to 1 when compiling with GDAL 1.9) created by robe
I suspect this is just mingw issue. Getting back to what was …
10:58 AM Ticket #1319 ([raster] Make raster_columns a constraint-based view, replace ...) closed by dustymugs
fixed: Added in r8305
10:58 AM Changeset [8305] by dustymugs
As per discussions and ticket #1319, raster_columns and …
10:36 AM Changeset [8304] by dustymugs
Removed division by bin-width for when bin-widths are specified in …

Dec 4, 2011:

6:06 PM Ticket #1349 (ST_AddBand is not null safe) closed by dustymugs
fixed: Fixed in r8303
6:06 PM Changeset [8303] by dustymugs
Correctly free raster memory when handling NULL rasters. Associated …
4:37 PM Ticket #1349 (ST_AddBand is not null safe) created by robe
I was able to crash the postgres daemon when one of my procedures …

Dec 3, 2011:

12:29 AM Changeset [8302] by robe
#1343: get rid of geomvalxy and change ST_PixelAsPolygons to use …

Dec 2, 2011:

11:37 PM Ticket #1338 ([raster] document ST_PixelWidth and ST_PixelHeight) closed by robe
fixed: feel free to reopen if you think further changes are required
11:24 PM Changeset [8301] by robe
#1338 - document ST_PixelWidth/Height
10:54 PM Changeset [8300] by dustymugs
Removed VARIADIC from ST_BandMetadata. Associated ticket is #1343.
10:23 PM Ticket #1343 ([raster] raster Upgrade script doesn't work because of new type) reopened by robe
Same issue with geomvalxy. I'll take care of this one Bborie since I …
12:01 PM Ticket #1348 (st_curvetoline not working when casting from geography type) created by bcrosby
The following returns a polygon instead of a curvedpolygon: select …
10:06 AM Ticket #1347 (postgis_upgrade_minor.sql fails as can't drop aggregate) created by strk
when you have views using aggregates you can't drop them (the …
9:50 AM Ticket #1346 ("$user", public, topology, topology, topology, topology) closed by robe
fixed: fixed at r8299
9:44 AM Changeset [8299] by robe
#1346: fix misuse of quote_literal causing topology, topology, …
9:28 AM Changeset [8298] by strk
Encode dependency of topology.sql on ManageHelper?.sql
9:20 AM Ticket #1346 ("$user", public, topology, topology, topology, topology) created by strk
The more you source topology/topology.sql the more "topology" elements …
7:43 AM Changeset [8297] by robe
more revisions to cross streets logic -- don't rely on start point …
7:30 AM Ticket #1345 (ST_StartPoint, ST_EndPoint regress failure) created by robe
I just noticed (by accident of course when testing my cross street …
7:22 AM Changeset [8296] by dustymugs
Added cleanup statements for bandmetatype type and change function …
7:14 AM Ticket #1343 ([raster] raster Upgrade script doesn't work because of new type) closed by dustymugs
fixed: OK. I've removed the type in r8295.
7:13 AM Changeset [8295] by dustymugs
Removed the type bandmetadata as per #1343.
3:35 AM Ticket #1344 (ST_MakeLine fails for export with pgsql2shp) created by bporfidia
making linestring with st_makeline from a table of points, fails the …
1:10 AM Ticket #1343 ([raster] raster Upgrade script doesn't work because of new type) created by robe
I see someone created a bandmetadata type. Can we get rid of it? and …
12:07 AM Changeset [8294] by robe
move geocode_intersection.sql to user api section since it is documented.

Dec 1, 2011:

10:27 PM Changeset [8293] by robe
try to make emphasis bold by putting in a role='bold'
12:41 PM Changeset [8292] by robe
replace ~= with ST_OrderingEquals (now that we got rid of recheck the …
12:37 PM Changeset [8291] by robe
emphasize approximate in KNN operators to reduce the chance of any …
11:06 AM Changeset [8290] by robe
make compatible with postgresql 8.4, more speed improvements
9:52 AM Changeset [8289] by robe
missed a spot about occasions where point distance is not same as <->
9:38 AM Changeset [8288] by robe
try to clarify accuracy etc. of <#> and <->
8:20 AM WKTRaster/SpecificationWorking03 edited by pracine
(diff)
8:14 AM Changeset [8287] by pracine
Ticket 1342. Integrate ST_PixelAsPolygons into rtpostgis.sql
8:13 AM Ticket #1342 ([raster] Integrate ST_PixelAsPolygons into rtpostgis.sql) created by pracine
8:07 AM Changeset [8286] by pracine
Return null when band number does not exist.
8:06 AM Changeset [8285] by pracine
Removed ST_MinPossibleVal defined in another script
8:05 AM Changeset [8284] by pracine
Added doc, more test and return null when band number does not exist.
7:52 AM Changeset [8283] by pracine
Ticket 1342. Integrate ST_Clip script into rtpostgis.sql
7:52 AM Ticket #1341 ([raster] Integrate ST_Clip script into rtpostgis.sql) created by pracine
7:15 AM Changeset [8282] by pracine
Ticket #1340. Integrate ST_Union into rtpostgis.sql
7:13 AM Ticket #1340 ([raster] Integrate the plpgsql ST_Union script in rtpostgis.sql) created by pracine
7:11 AM Changeset [8281] by pracine
Replaced AsBinary? with ST_AsBinary in the test section
5:36 AM Ticket #1339 (ST_MakeEnvelope should have an option to not take an srid) created by robe
Just noticed ST_MakeEnvelope doesn't have an option not to take an …
5:34 AM Ticket #1337 (documentation: attribute-based restrictions reduce number of records, ...) closed by robe
fixed: fixed. Also made some other corrections of obsolete syntax. 2.0: …
5:32 AM Changeset [8280] by robe
#1337 clarify what sql is good for and get rid of some other obsolete …
5:13 AM Changeset [8279] by robe
#1337 clarify what sql is good for and get rid of some other obsolete …
5:13 AM Changeset [8278] by robe
#1337 clarify what sql is good for and get rid of some other obsolete …
5:13 AM Changeset [8277] by robe
#1337 clarify what sql is good for and get rid of some other obsolete …
12:36 AM Changeset [8276] by robe
#1333 geocode_intersections: would help to actually include the …
12:28 AM Changeset [8275] by robe
#1333 geocode intersections
12:06 AM Ticket #1077 (Regression tests for tiger geocoder) closed by robe
fixed: going to mark this done since have got a decent regress test suite. …

Nov 30, 2011:

8:29 PM Changeset [8274] by dzwarg
Added neighborhood hillshade on top of ST_MapAlgebraFctNgb. Part of #1318
6:23 PM Changeset [8273] by dustymugs
Tweaked ST_BandMetadata so that calling the function with an empty …
5:11 PM Changeset [8272] by pracine
Copied from ST_MapAlgebra.sql
5:10 PM Changeset [8271] by pracine
Copied from ST_Union
5:09 PM Changeset [8270] by pracine
Some cleaning before inclusion in rtpostgis.sql Removed …
5:07 PM Changeset [8269] by pracine
Return the last band when the provided band number does not exist.
5:07 PM Changeset [8268] by pracine
Added some variants and tests
2:42 PM Changeset [8267] by pracine
plpgsql implementation for st_clip.sql(raster, geom)
2:41 PM Changeset [8266] by pracine
Added the id of the polygon in the example
2:34 PM Changeset [8265] by dzwarg
Added ST_Aspect map algebra neighborhood shortcut function. #1318
1:44 PM Changeset [8264] by dzwarg
Added ST_Slope map algebra neighborhood shortcut function.
12:35 PM Changeset [8263] by dustymugs
Fixed ST_AsRaster to duplicate exactly the attributes of a reference …
12:11 PM Ticket #1338 ([raster] document ST_PixelWidth and ST_PixelHeight) created by dzwarg
These are in trunk, need documentation.
11:46 AM Ticket #1337 (documentation: attribute-based restrictions reduce number of records, ...) created by lorin
Here …
11:26 AM Changeset [8262] by dzwarg
Added helper user functions for common MapAlgebra? operations: Min, …
11:08 AM Ticket #1336 ([raster] Problem with ST_AsRaster() alignment) created by pracine
I have a test raster that I display in Openjump: […] Then I have …
8:45 AM Changeset [8261] by dzwarg
Updated tests for 'dog-ate-my-homework' test. Expanded comments and …
7:30 AM WKTRaster/SpecificationWorking03 edited by pracine
(diff)
6:51 AM Changeset [8260] by dzwarg
Added additional tests for ST_MapAlgebraFctNgb, changed string compare …
6:31 AM Ticket #1278 ([raster] Document ST_Rotation, ST_SetRotation) closed by dzwarg
fixed: Completed in r8187
12:37 AM WKTRaster/SpecificationWorking03 edited by robe
(diff)
Note: See TracTimeline for information about the timeline view.