Menu
▾
▴
Bugs
Known Bug List of Postgres-XC
The list here is based upon open bug as of 17 June 2014. All the fixed bugs at this date may not be included in this list.
Bug SN Summary Created Updated Fixed Remarks URL
PG-35
EXECUTE DIRECT document bug
2014/06/19
2014/09/19
2014/06/19
1.1, 1.2 and master
https://postgres-xc.atlassian.net/browse/PG-35
PG-34
SPI strange behavior (plpgsql)
2014/06/18
All versions
https://postgres-xc.atlassian.net/browse/PG-34
PG-33
Pg_dump/pg_dumpall does not work with 1.2 when dumping sequences.
2014/06/17
1.2 or later. Patch submitted
https://postgres-xc.atlassian.net/browse/PG-33
PG-32
ALTER TABLE fails in table redistribution with \x0000 data in byte.
2014/06/10
1.1 or later
https://postgres-xc.atlassian.net/browse/PG-32
PG-31
VACUUM, VACUUM analyze don't work against materialized view
07/Apr/14
07/Apr/14
1.2 or later
https://postgres-xc.atlassian.net/browse/PG-31
PG-30
pg_xlogdump does now work with Postgres-XC
01/Apr/14
01/Apr/14
01/Apr/14
Committed: 60dec441ff38558d (master) 9aa5907b5201b851 (REL1_2_STABLE)
https://postgres-xc.atlassian.net/browse/PG-30
PG-25
pg_dump serial dump updates the current value
19/Mar/14
19/Mar/14
All versions
https://postgres-xc.atlassian.net/browse/PG-25
483
Using distribution column in updateable view does not work
2014/03/03
2014/03/04
1.2 or later
https://sourceforge.net/p/postgres-xc/bugs/483/
482
EXPLAIN FORMAT Does Not Work
2014/02/24
2014/04/02
1.2 or later
https://sourceforge.net/p/postgres-xc/bugs/482/
481
CREATE EXTENSION Failure
2014/02/20
2014/02/22
1.2 or later
https://sourceforge.net/p/postgres-xc/bugs/481/
480
Disconnect Pooled Connections when Role Dropped
2014/02/20
2014/02/20
All versions
https://sourceforge.net/p/postgres-xc/bugs/480/
479
Add LIKE tablename option to DISTRIBUTE Clause
2014/02/19
2014/02/19
New feature
https://sourceforge.net/p/postgres-xc/bugs/479/
478
LIKE INCLUDING ALL Does not include DISTRIBUTE BY
2014/02/14
2014/02/19
All versions
https://sourceforge.net/p/postgres-xc/bugs/478/
477
Allow HASH distribution UUID column
2014/02/13
2014/02/13
All versions
https://sourceforge.net/p/postgres-xc/bugs/477/
476
Occasional failure of cluster regression test
2014/02/10
2014/02/10
All versions
https://sourceforge.net/p/postgres-xc/bugs/476/
475
Updating rows during BEFORE ROW trigger firing
2014/02/07
2014/02/07
1.1 or later
https://sourceforge.net/p/postgres-xc/bugs/475/
474
Starting GTM and GTM Proxy after unexpected termination
2014/02/03
2014/02/03
All versions
https://sourceforge.net/p/postgres-xc/bugs/474/
473
Search Path Propagation Issue
2014/01/31
2014/02/03
1.1 or later
https://sourceforge.net/p/postgres-xc/bugs/473/
472
Permission issues with view updation
2014/01/27
2014/01/27
All versions (architectural issue included_)
https://sourceforge.net/p/postgres-xc/bugs/472/
471
Functions taking parameters of type view cannot be created
2014/01/27
2014/01/27
All versions
https://sourceforge.net/p/postgres-xc/bugs/471/
470
Issues compiling 1.1 on FreeBSD
2014/01/20
2014/01/20
1.1 or later
"https://sourceforge.net/p/postgres-xc/bugs/470/"
469
Issues compiling 1.1 on FreeBSD
2014/01/20
2014/01/20
1.1 or later
"https://sourceforge.net/p/postgres-xc/bugs/469/"
467
inefficient plan for a simple query.
2014/01/03
2014/01/03
Fix patch submitted.
https://sourceforge.net/p/postgres-xc/bugs/467/
466
nodename syntax in initdb
2013/12/31
2013/12/31
All versions
https://sourceforge.net/p/postgres-xc/bugs/466/
465
Simple join pushdown does not work
2013/12/12
2013/12/12
All versions
https://sourceforge.net/p/postgres-xc/bugs/465/
464
lock table in a statement block cause error
2013/12/12
2013/12/12
1.1 or later
https://sourceforge.net/p/postgres-xc/bugs/464/
463
EXECUTE DIRECT queries with particular GROUP BY clause return strange binary results.
2013/12/11
2013/12/11
https://sourceforge.net/p/postgres-xc/bugs/463/
462
GROUP BY clause with JOIN clause and DISTINCT clause and combination of implicit/explicit table specification
2013/12/02
2013/12/02
https://sourceforge.net/p/postgres-xc/bugs/462/
461
Repeated rollback gets different error code from PostgreSQL
2013/12/02
2013/12/03
All versions
https://sourceforge.net/p/postgres-xc/bugs/461/
460
Production Platform Migration Error
2013/10/25
2013/10/25
All versions, GTM fallback to local XID
https://sourceforge.net/p/postgres-xc/bugs/460/
458
COLLATE clause causes incorrect sort results.
2013/10/10
2013/10/10
All versions
https://sourceforge.net/p/postgres-xc/bugs/458/
456
Autovacuum freeze corrupts database
2013/10/07
2013/10/07
1.2 or later
https://sourceforge.net/p/postgres-xc/bugs/456/
455
pg_dump triggers not including schema info
2013/09/26
2013/09/26
1.1 or later
https://sourceforge.net/p/postgres-xc/bugs/455/
454
Update triggers on replicated tables may corrupt data
2013/09/26
2013/09/26
1.1 or later
https://sourceforge.net/p/postgres-xc/bugs/454/
451
Query returns no rows when run through JDBC
2013/09/03
2013/12/02
1.2 or later. Workaround is to disable binary transfer mode.
https://sourceforge.net/p/postgres-xc/bugs/451/
450
CREATE TABLE AS does not work through JDBC
2013/09/03
2013/12/02
1.1 or later
https://sourceforge.net/p/postgres-xc/bugs/450/
449
A couple of queries producing syntax error
2013/09/03
2014/03/17
1.2 or later
https://sourceforge.net/p/postgres-xc/bugs/449/
448
clog error: No such file or directory
2013/09/02
2013/12/02
1.2 or later
https://sourceforge.net/p/postgres-xc/bugs/448/
439
Preferred node when a node added
2013/07/26
2013/07/26
all versions
https://sourceforge.net/p/postgres-xc/bugs/439/
437
Slaves to subset of masters
2013/07/26
2013/07/26
1.1 or later
https://sourceforge.net/p/postgres-xc/bugs/437/
436
Availability improvement needed
2013/07/16
2013/07/16
New feature
https://sourceforge.net/p/postgres-xc/bugs/436/
432
Using 1 GTM and 1 Proxy creates broken Datanode Config
2013/07/10
2013/07/11
pgxc_ctl, 1.1 or later
https://sourceforge.net/p/postgres-xc/bugs/432/
431
Servercrash in case of a 1 coordinator 1 datanode cluster
2013/07/10
2013/12/02
1.2 or later
https://sourceforge.net/p/postgres-xc/bugs/431/
430
generate_series() does not work with INSERT
2013/07/05
2013/12/04
https://sourceforge.net/p/postgres-xc/bugs/430/
429
Dumping and restoring sequences
2013/07/02
2013/12/04
https://sourceforge.net/p/postgres-xc/bugs/429/
428
User can update a distributio column column through triggers
2013/06/20
2013/06/20
https://sourceforge.net/p/postgres-xc/bugs/428/
427
Some statment stucks with EXECUTE DIRECT
2013/06/06
2013/12/02
https://sourceforge.net/p/postgres-xc/bugs/427/
425
Syntax not supported by XC
2013/05/30
2013/06/12
https://sourceforge.net/p/postgres-xc/bugs/425/
423
Use MergeAppend for merging sorted runs from datanodes
2013/05/23
2013/05/23
Feature? Not a bug?
https://sourceforge.net/p/postgres-xc/bugs/423/
422
combiner->command_complete_count needs to be handled correct
2013/05/21
2013/05/21
https://sourceforge.net/p/postgres-xc/bugs/422/
420
EXPLAIN no distinction from vanilla
2013/05/15
2013/06/11
Document bug
https://sourceforge.net/p/postgres-xc/bugs/420/
419
gtm_proxy segfaults on subsequent queries
2013/05/08
2013/11/27
https://sourceforge.net/p/postgres-xc/bugs/419/
418
No responce at EXPLAIN ANALYZE to LEFT OUTER JOIN
2013/05/08
2013/05/08
https://sourceforge.net/p/postgres-xc/bugs/418/
417
Fault start at gtm_standby w/o connection with GTM
2013/05/08
2013/11/27
https://sourceforge.net/p/postgres-xc/bugs/417/
410
WITH queries return "input of anonymous composite ty...."
2013/04/18
2013/06/11
https://sourceforge.net/p/postgres-xc/bugs/410/
409
Do DML remote query and data params at same place
2013/04/16
2013/04/16
https://sourceforge.net/p/postgres-xc/bugs/409/
406
Should fetch required columns in case of DMLs
2013/04/01
2013/04/01
https://sourceforge.net/p/postgres-xc/bugs/406/
405
Cross-node constraint undetected
2013/03/26
2013/03/26
https://sourceforge.net/p/postgres-xc/bugs/405/
403
PREPARE and EXECUTE do not work as expected
2013/03/14
2013/06/11
https://sourceforge.net/p/postgres-xc/bugs/403/
396
SQL functions containing utility statements do not work
2013/02/23
https://sourceforge.net/p/postgres-xc/bugs/396/
395
Use GetRelationNodes for CMD_INSERT in create_remotedml_plan
2013/02/22
2013/02/22
https://sourceforge.net/p/postgres-xc/bugs/395/
394
Leaking connections
2013/02/14
2013/12/02
https://sourceforge.net/p/postgres-xc/bugs/394/
393
GROUP BY using primary column with other columns in SELECT
2013/02/12
2013/02/12
https://sourceforge.net/p/postgres-xc/bugs/393/
392
XC error in prepare after iteration in JDBC
2013/02/12
2014/05/11
https://sourceforge.net/p/postgres-xc/bugs/392/
389
Count(*) within prepare incorrect
2013/02/05
2013/02/05
https://sourceforge.net/p/postgres-xc/bugs/389/
387
CREATE TABLE AS ... with aggregate
2013/02/01
2013/06/11
https://sourceforge.net/p/postgres-xc/bugs/387/
386
Multiple GTM standbys -- no error log
2013/01/31
2013/12/02
https://sourceforge.net/p/postgres-xc/bugs/386/
384
Network error detection at gtm_proxy
2013/01/30
2013/11/27
https://sourceforge.net/p/postgres-xc/bugs/384/
379
Named prepared statement remain in pooler
2013/01/23
2013/01/23
https://sourceforge.net/p/postgres-xc/bugs/379/
376
Pooler warnings with coord/dn slaves
2013/01/23
2013/01/23
https://sourceforge.net/p/postgres-xc/bugs/376/
375
genrate_series and FQS
2013/01/22
2013/01/22
https://sourceforge.net/p/postgres-xc/bugs/375/
374
DML with RETURNING on a replicated table
2013/01/21
2013/01/21
https://sourceforge.net/p/postgres-xc/bugs/374/
373
Handling of processed tuple counting in DMLs
2013/01/21
2013/01/21
https://sourceforge.net/p/postgres-xc/bugs/373/
323
Multiple primary nodes in XC
2012/07/24
2013/06/11
https://sourceforge.net/p/postgres-xc/bugs/323/
321
GTM_Standby crash
2012/07/04
2012/08/02
https://sourceforge.net/p/postgres-xc/bugs/321/
319
CREATE functions with views: fails at creation
2012/06/20
2013/12/02
https://sourceforge.net/p/postgres-xc/bugs/319/
311
plpgsql: failed to send COMMIT command to node
2012/05/11
2013/12/03
https://sourceforge.net/p/postgres-xc/bugs/311/
303
CTAS output with psql
2012/04/27
2012/06/03
https://sourceforge.net/p/postgres-xc/bugs/303/
302
A few problems with whole row references
2012/04/27
2013/06/12
https://sourceforge.net/p/postgres-xc/bugs/302/
298
CREATE TABLE AS passes even if there is a collation clash
2012/04/20
2012/06/03
https://sourceforge.net/p/postgres-xc/bugs/298/
285
Use node identifier to identify nodes every where
2012/03/29
2013/06/12
https://sourceforge.net/p/postgres-xc/bugs/285/
272
OpenBSD porting
2012/02/10
2012/06/03
https://sourceforge.net/p/postgres-xc/bugs/272/
264
TRANSACTION ISOLATION LEVEL SERIALIZABLE does not work.
2011/12/20
2012/06/03
https://sourceforge.net/p/postgres-xc/bugs/264/
263
One FETCH is necessary for UPDATE/DELETE WHERE CURRENT OF
2011/12/20
2013/06/12
https://sourceforge.net/p/postgres-xc/bugs/263/
262
WITH HOLD cursors do not work in XC.
2011/12/20
2013/06/12
https://sourceforge.net/p/postgres-xc/bugs/262/
261
MOVE BACKWARDS works only if SCROLL is used in CURSOR
2011/12/20
2013/06/12
Feature?
https://sourceforge.net/p/postgres-xc/bugs/261/
260
For multi-step queries WHERE CURRENT OF does not work
2011/12/20
2013/06/12
Feature, not a bug
https://sourceforge.net/p/postgres-xc/bugs/260/
259
Successive UPDATEs using WHERE CURRENT OF does not work
2011/12/20
2013/06/12
Feature, not a bug
https://sourceforge.net/p/postgres-xc/bugs/259/
245
Temporary objects when session is reloaded
2011/12/01
2012/06/03
https://sourceforge.net/p/postgres-xc/bugs/245/
239
prepared insert on round robin table
2011/11/16
2013/06/12
https://sourceforge.net/p/postgres-xc/bugs/239/
119
Cursor CURRENT OF for replicated tables
2011/02/15
2012/09/12
Feature, not a bug
https://sourceforge.net/p/postgres-xc/bugs/119/
99
Server crash in case of WHERE CURRENT OF
2010/12/30
2013/06/12
Feature, not a bug
https://sourceforge.net/p/postgres-xc/bugs/99/1
