Moreover, faulty error recovery could lead to unexpected errors in later commands too.įix possible loss of the commit timestamp for the last subtransaction of a transaction (Alex Kingsborough, Kyotaro Horiguchi)īe sure to fsync the pg_logical/mappings subdirectory during checkpoints (Nathan Bossart) The walsender process would fail for a SQL command containing an unquoted semicolon, or with dollar-quoted literals containing odd numbers of single or double quote marks, or when the SQL command starts with a comment. Remove lexical limitations for SQL commands issued on a logical replication connection (Tom Lane) The replica would retry, but could never get past that error. If a replica server is started while the set of active transactions on the primary crosses a wraparound boundary (so that there are some newer transactions with smaller XIDs than older ones), the replica would fail with “ out-of-order XID insertion in KnownAssignedXids”. While the coercion function should do the right thing (nothing), this translation is undesirably inefficient.įix WAL replay failure when database consistency is reached exactly at a WAL page boundary (Álvaro Herrera)įix startup of a physical replica to tolerate transaction ID wraparound (Abhijit Menon-Sen, Tomas Vondra) The non-returnable column would read as NULL, resulting in wrong query results.Įnsure that casting to an unspecified typmod generates a RelabelType node rather than a length-coercion function call (Tom Lane) If an index has both returnable and non-returnable columns, and one of the non-returnable columns is an expression using a table column that appears in a returnable index column, then a query using that expression could result in an index-only scan plan that attempts to read the non-returnable column, instead of recomputing the expression from the returnable column as intended. Fix index-only scan plans for cases where not all index columns can be returned (Tom Lane)
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |