E.1. Release 1.0.2

E.1.1. Migration to Version 1.0.2

A dump/restore is not required for those running 1.0.X.

E.1.2. Changes

• Fix for bug 3602944: Fixed gtm_ctl to solve the PATH dependency. (Nikhil Sontakke)

• Fix for bug 3601255: Fixed the planner to disable FQS for all the OUTER joins. (Ashutosh Bapat)

• Fix for bug 3600220: Fixed coordinator/datanode to unregister themselves from GTM while restarting after "-m immediate" shutdown. (Koichi Suzuki)

• Fixed gtm_ctl for "status" command with "-Z gtm" to show the status correctly. (Koichi Suzuki)

  Now for -Z gtm option, gtm_ctl status displays if it runs as master or slave.

• Rebased from PostgreSQL 9.1.6 to 9.1.7, and fixed several regression test failures, which had been newly introduced during the rebase. (Satoshi Nagayasu)

• Fix for bug 3597414: Fixed the planner for JOIN between two distributed tables to be pushable when on only one node. (Ashutosh Bapat)

• Fix for bug 3598637: Fixed GTM standby to avoid occasional crash. (Koichi Suzuki)

• Fixed GTM to deal with a promoted master correctly while restarting. (Nikhil Sontakke, Koichi Suzuki)

• Fix for bug 3583921: Fixed coordinator slave (and possibly datanode too) to avoid crash due to "too many KnownAssignedXids". (Koichi Suzuki)

• Fix for bug 3598030: Fixed to allow commit/abort transactions while connecting to the datanode directly.

• Fix for bug 3591285: Fixed autovacuum crash in datanode. (Koichi Suzuki)

• Fix for bug 3571154: Fixed GTM proxy error while reconnecting. (Koichi Suzuki)

• Fixed libgtmclient.a to surpress debug messages. (Koichi Suzuki)

• Fixed GTM proxy to have appropriate default values (retry count and retry interval) for GTM proxy HA. (Koichi Suzuki)

• Fix for bug 3588869: Fixed GTM proxy to avoid stall while reconnecting. (Koichi Suzuki)

• Fixed to enforce autocommit when running ALTER DATABASE SET TABLESPACE. (Michael Paquier)

• Fixed pgxc_clean for -s, --status option working correctly. (Koichi Suzuki)

• Fixed "SET XC_MAINTENANCE_MODE = ON" to ignore "template0" database. (Koichi Suzuki)

• Fixed GTM and GTM proxy for inaccurate default values of the port number. (Koichi Suzuki)

• Added GTM header files in installation to allow compiling server modules. (Michael Paquier)

• Added support to create cached plans for XC-specific DDL commands. (Michael Paquier)

  This allows to use cached plans or prepared queries for following commands: CREATE NODE, ALTER NODE, DROP NODE, CREATE NODE GROUP, DROP NODE GROUP, CLEAN CONNECTION.

• Fixed CREATE NODE GROUP/DROP NODE GROUP commands to stop query pushdown to remote nodes. (Michael Paquier)

• Fixed memory allocation issues pointed by ElectricFence (libefence). (Michael Paquier)

• Fixed memory corruption in GTM/backend buffer for snapshots and transaction IDs. (Michael Paquier)

• Fixed COPY command to deal with quoted column names. (Nikhil Sontakke, Michael Paquier)

• Fixed to ignore automatically generated regression outputs specific to Postgres-XC. (Michael Paquier)

• Fixed COPY command to avoid crash when involving relation with no locator data. (Michael Paquier)

• Fixed ALTER NODE to allow modifying primary node data. (Michael Paquier)

• Fixed compilation error in pg_dump. (Michael Paquier)

• Changed current value management of sequences to make it consistent with vanilla. (Michael Paquier)

• Fixed pg_dump to get consistent sequence dump value. (Nikkhil Sontakke, Michael Paquier)

• Fixed and improved docs for several XC-specific commands, options and parameters. (Koichi Suzuki, Michael Paquier)