Postgresonline - postgresonline.com - Postgres OnLine Journal
General Information:
Latest News:
CREATE SCHEMA IF NOT EXISTS in 9.3 and tiger geocoder 23 Aug 2013 | 10:21 am
One of the new features in PostgreSQL 9.3 is CREATE SCHEMA IF NOT EXISTS someschema;. We were so excited about this new feature that we started using it in the tiger geocoder loader routine. For some ...
Raster Words using PostGIS 2.1 18 Aug 2013 | 08:40 pm
Two of the big changes in PostGIS 2.1 raster are the improved speed and functionality of the raster ST_Union function and ST_Clip. Aside from speed, the big thing with ST_Union in 2.1 is that it appli...
PostGIS 2.1.0 released 18 Aug 2013 | 08:46 am
The 2.1.0 release of PostGIS is now available. The PostGIS development team is proud to release PostGIS 2.1.0. As befits a minor release, the focus is on speed improvements, more features, and bug fi...
Materialized geometry_columns using Event Triggers 15 Aug 2013 | 09:18 am
One of the big changes in PostGIS 2.0 was that the geometry_columns table became a read only view. This change was not without sacrifice. On the plus it meant a table no longer needed to be maintained...
Caching data with materialized views and statement level triggers 14 Aug 2013 | 07:49 am
One exciting new feature coming in PostgreSQL 9.3 is materialized views. Materialized views is really a mechanism for caching data of a query. It is especially useful if you have long running queries ...
PostGIS 2.1.0rc2 released 3 Aug 2013 | 11:53 pm
The 2.1.0rc2 release of PostGIS is now available. The PostGIS development team is proud to release a release candidate version of upcoming PostGIS 2.1.0. As befits a minor release, the focus is on sp...
In defense of being blunt and to the point 22 Jul 2013 | 11:56 am
This is partly in response to Josh's blog entry Calling Bullsh*t in Open Source communities and Sarah Sharp's plea for No more verbal abuse. Normally I don't make these public statements but this time...
pgRouting 2.0.0rc1 and PostGIS 2.1.0rc1 17 Jul 2013 | 12:07 pm
This past day, the pgRouting development team released pgRouting 2.0.0 RC1 just steps after PostGIS 2.1.0 rc1. Last week PostGIS project released RC1 of upcoming 2.1.0 PostGIS 2.1.0 RC1. Now only thi...
Boston PostgreSQL Meetup September 10, 2013: PostGIS Intro 25 Jun 2013 | 10:39 am
We'll be hosting the September 10th, 2013 PostgreSQL User Group meetup at Devonshire Sky Club (in the center of Boston Financial district and block away from city hall). This is the same venue we host...
PostGIS 2.1.0beta3 released 23 Jun 2013 | 03:11 am
The PostGIS development team is proud to release a feature complete beta version of upcoming PostGIS 2.1.0. As befits a minor release, the focus is on speed improvements, more features, and bug fixes....
