http://www.postgresonline.com/journal/ Postgres OnLine Journal - an In depth look at the PostgreSQL open source database en Serendipity 1.4.1 - http://www.s9y.org/ Wed, 22 May 2013 05:09:53 GMT http://www.postgresonline.com/journal/templates/default/img/s9y_banner_small.png http://www.postgresonline.com/journal/ 100 21 http://www.postgresonline.com/journal/archives/306-KNN-GIST-with-a-Lateral-twist-Coming-soon-to-a-database-near-you.html#c8098 http://www.postgresonline.com/journal/archives/306-KNN-GIST-with-a-Lateral-twist-Coming-soon-to-a-database-near-you.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=306 nospam@example.com (Beatriz) I also kept away from ARX order p90x insanity today since trying to eliminate excess weight and also be in tip-top shape you will be in great company. If you have failed with other workout schedule order p90x insanity for the entire program back one day. Wed, 22 May 2013 01:06:27 -0400 http://www.postgresonline.com/journal/archives/306-guid.html#c8098 http://www.postgresonline.com/journal/archives/306-KNN-GIST-with-a-Lateral-twist-Coming-soon-to-a-database-near-you.html#c8091 http://www.postgresonline.com/journal/archives/306-KNN-GIST-with-a-Lateral-twist-Coming-soon-to-a-database-near-you.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=306 nospam@example.com (Mike Toews) "ST_GeomFromText(234054, 902182)" should be corrected to "ST_MakePoint(234054, 902182)" Tue, 21 May 2013 21:40:10 -0400 http://www.postgresonline.com/journal/archives/306-guid.html#c8091 http://www.postgresonline.com/journal/archives/303-Which-PostGIS-should-you-use-with-PostgreSQL-9.3.html#c7488 http://www.postgresonline.com/journal/archives/303-Which-PostGIS-should-you-use-with-PostgreSQL-9.3.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=303 nospam@example.com (Regina) We are still on a different release cycle mostly because our code base is fairly huge for a contrib module. Having to match release cycle with PostgreSQL would be very frustrating for us. We have enough fighting amongst ourselves when to release without having another group controlling us. That said as dusty mentioned, the licensing is incompatible. But really the main reason is our module is too big to fit in PostgreSQL release cycle. The other issue is a lot of GIS folks want newer features without having to upgrade PostgreSQL and are also tied to 3rd party GIS tools that only support X version etc. Being part of PostgreSQL would force us into a 1 version of PostGIS per version of PostgreSQL which I think would make everyone unhappier. As much as I like to complain, I'd rather distros package more than one version of PostGIS per PostgreSQL release rather than we being forced into a one PostGIS version per PostgreSQL. Tue, 30 Apr 2013 13:45:46 -0400 http://www.postgresonline.com/journal/archives/303-guid.html#c7488 http://www.postgresonline.com/journal/archives/303-Which-PostGIS-should-you-use-with-PostgreSQL-9.3.html#c7485 http://www.postgresonline.com/journal/archives/303-Which-PostGIS-should-you-use-with-PostgreSQL-9.3.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=303 nospam@example.com (dustymugs) PostGIS can't be part of PostgreSQL (in contrib) due to non-compatible licenses. PostgreSQL has its own BSD/MIT-like license while PostGIS is GPL v2. Tue, 30 Apr 2013 12:39:38 -0400 http://www.postgresonline.com/journal/archives/303-guid.html#c7485 http://www.postgresonline.com/journal/archives/303-Which-PostGIS-should-you-use-with-PostgreSQL-9.3.html#c7481 http://www.postgresonline.com/journal/archives/303-Which-PostGIS-should-you-use-with-PostgreSQL-9.3.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=303 nospam@example.com (Grazvydas) I think PostGIS became mature enough to become aligned to PostgreSQL release cycle. How about to move it to PG contrib or find another way to integrate it to the core PG? Historical reasons of developing PostGIS separately become less and less attractive - you described reasons of that. On the other hand - PostGIS is huge value to PostgreSQL. Why PG would insist to keep PostGIS separated? Tue, 30 Apr 2013 08:56:03 -0400 http://www.postgresonline.com/journal/archives/303-guid.html#c7481 http://www.postgresonline.com/journal/archives/303-Which-PostGIS-should-you-use-with-PostgreSQL-9.3.html#c7463 http://www.postgresonline.com/journal/archives/303-Which-PostGIS-should-you-use-with-PostgreSQL-9.3.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=303 nospam@example.com (Moses) I'm fine with it. No problem when postgresql and postgis versions going hand in hand. Since we anyway updating to every new version, because there is so much cool stuff. Tue, 30 Apr 2013 01:15:14 -0400 http://www.postgresonline.com/journal/archives/303-guid.html#c7463 http://www.postgresonline.com/journal/archives/302-Word-Play-with-Spatial-SQL.html#c7278 http://www.postgresonline.com/journal/archives/302-Word-Play-with-Spatial-SQL.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=302 nospam@example.com (Bruce) Nothing is as easy as it seems. Take the phrase "Dot you i's and cross your t's" The dot above an i must be coded as a separate path which is different from a donut hole like in the letter e. If a t is coded as two separate paths the geometries will intersect and not be valid. Both cases are handled easily in SVG. The nasty coding is converting ellipses and bezier curves (very common in fonts/SVG) to WKT geometries. Mon, 22 Apr 2013 11:04:57 -0400 http://www.postgresonline.com/journal/archives/302-guid.html#c7278 http://www.postgresonline.com/journal/archives/249-ODBC-Foreign-Data-wrapper-to-query-SQL-Server-on-Window-Part-2.html#c7128 http://www.postgresonline.com/journal/archives/249-ODBC-Foreign-Data-wrapper-to-query-SQL-Server-on-Window-Part-2.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=249 nospam@example.com (Regina) Unfortunately I don't think so. Or at least not last time I tried. I tried a couple of months ago and it wouldn't compile against. 9.2 changed FDW in a major way whcih broke a lot of past FDWs. I was trying to see if I could patch the code up to work with 9.2 but got as far as getting it to compile, but then it failed on load. Then I had to move on to something else. I'll check if its been updated recently. Sun, 14 Apr 2013 17:16:42 -0400 http://www.postgresonline.com/journal/archives/249-guid.html#c7128 http://www.postgresonline.com/journal/archives/249-ODBC-Foreign-Data-wrapper-to-query-SQL-Server-on-Window-Part-2.html#c7116 http://www.postgresonline.com/journal/archives/249-ODBC-Foreign-Data-wrapper-to-query-SQL-Server-on-Window-Part-2.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=249 nospam@example.com (Rytis) Hi, Would it be possible to post the ODBC FDW binaries for windows 64bit PostgreSQL 9.2? I've tried to compile myself with MinGW but after two long nights this seems to be way out of my league:) Rytis Sun, 14 Apr 2013 05:37:39 -0400 http://www.postgresonline.com/journal/archives/249-guid.html#c7116 http://www.postgresonline.com/journal/archives/214-Using-PgAdmin-PLPgSQL-Debugger.html#c7103 http://www.postgresonline.com/journal/archives/214-Using-PgAdmin-PLPgSQL-Debugger.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=214 nospam@example.com (Regina Obe) I presume you are running the 32-bit version of PostgreSQL since you are referencing a 32-bit version? You shouldn't need all that path stuff in shared_preload_libraries, just the dll name should be sufficient since its going to look in lib of the postgresql instance. If for some reason you need the full path, change the slashes from \ to / . PostgreSQL never seems to work right in a lot of places with windows style slashes Sat, 13 Apr 2013 17:32:39 -0400 http://www.postgresonline.com/journal/archives/214-guid.html#c7103 http://www.postgresonline.com/journal/archives/300-pgRouting-windows-binaries-for-PostgreSQL-9.2-32-bit-and-64-bit.html#c7102 http://www.postgresonline.com/journal/archives/300-pgRouting-windows-binaries-for-PostgreSQL-9.2-32-bit-and-64-bit.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=300 nospam@example.com (Regina) David, Of course. Started a series on BostonGIS. Here is first of what I hope to be several: http://www.bostongis.com/PrinterFriendly.aspx?content_name=pgrouting_osm2po_1 Sat, 13 Apr 2013 17:19:46 -0400 http://www.postgresonline.com/journal/archives/300-guid.html#c7102 http://www.postgresonline.com/journal/archives/300-pgRouting-windows-binaries-for-PostgreSQL-9.2-32-bit-and-64-bit.html#c7031 http://www.postgresonline.com/journal/archives/300-pgRouting-windows-binaries-for-PostgreSQL-9.2-32-bit-and-64-bit.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=300 nospam@example.com (David Fetter) Great news! Will some examples of using pgRouting follow here, or are they somewhere else? Tue, 09 Apr 2013 14:26:26 -0400 http://www.postgresonline.com/journal/archives/300-guid.html#c7031 http://www.postgresonline.com/journal/archives/214-Using-PgAdmin-PLPgSQL-Debugger.html#c7028 http://www.postgresonline.com/journal/archives/214-Using-PgAdmin-PLPgSQL-Debugger.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=214 nospam@example.com (Ion) Hi Regina, I installed PostgreSQL 9.2 onto a Windows server 2008 (x64). I made the modification in the postgres.conf like this: shared_preload_libraries = 'C:\Program Files (x86)\PostgreSQL\9.2\lib\plugin_debugger.dll'; I restarted the service postgres_9.2 who is assigned to postgres user; Into a database I used the shell to crete extension pldbgapi with this command: create extension pldbgapi; I had the confirmation the extension was created; I verified in the pgAdminIII the existence of the extension pldbgapi; The user postgres was created manually before installing Postgres and it hasn't specials privileges; I verified in Tools\Server configuration that shared_preload_libraries is checked; But the debugger is still not activated. Can you give me a hint for this problem, please. PS Before, I tried to install x64 of Postgres 9.2 but I was unable to restart the server because, pg_ctl.exe has 0 bytes. Thank you, Ion Tue, 09 Apr 2013 09:09:01 -0400 http://www.postgresonline.com/journal/archives/214-guid.html#c7028 http://www.postgresonline.com/journal/archives/293-Saying-Happy-Valentine-in-PostGIS.html#c6932 http://www.postgresonline.com/journal/archives/293-Saying-Happy-Valentine-in-PostGIS.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=293 nospam@example.com (Bruce) I have a javascript/php setup that does this. It parses the SVG file from Batik and converts it to WKT geometry format. Each glyph is stored as a record in a table. Works very well. Wed, 03 Apr 2013 11:33:58 -0400 http://www.postgresonline.com/journal/archives/293-guid.html#c6932 http://www.postgresonline.com/journal/archives/298-PostOS.html#c6906 http://www.postgresonline.com/journal/archives/298-PostOS.html#comments http://www.postgresonline.com/journal/wfwcomment.php?cid=298 nospam@example.com (Regina) Joe, No extension required. That feature is built in. It even understands GO to further make SQL Server converts feel homey. Mon, 01 Apr 2013 12:08:12 -0400 http://www.postgresonline.com/journal/archives/298-guid.html#c6906