pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg-migrator - pg_migrator: Warn about uninstalling user-data linked
2+ messages / 2 participants
[nested] [flat]

* pg-migrator - pg_migrator: Warn about uninstalling user-data linked
@ 2009-06-06 02:04 User Bmomjian <bmomjian@pgfoundry.org>
  0 siblings, 0 replies; 2+ messages in thread

From: bmomjian@pgfoundry.org @ 2009-06-06 02:04 UTC (permalink / raw)
  To: pgsql-committers

Log Message:
-----------
Warn about uninstalling user-data linked /contrib modules.

Modified Files:
--------------
    pg_migrator:
        INSTALL (r1.22 -> r1.23)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pg-migrator/pg_migrator/INSTALL?r1=1.22&r2=1.23)




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* pgsql: Don't try to fix eliminated nbtree array scan keys.
@ 2024-04-18 15:49 Peter Geoghegan <pg@bowt.ie>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Geoghegan @ 2024-04-18 15:49 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Don't try to fix eliminated nbtree array scan keys.

Preprocessing for nbtree index scans allowed array "input" scan keys
already marked eliminated during array-specific preprocessing to be
"fixed up" during preprocessing proper.  This allowed eliminated scan
keys on DESC index columns to spurious have their strategy commuted,
causing assertion failures.

To fix, teach _bt_fix_scankey_strategy to ignore these scan keys.  This
brings it in line with its only caller, _bt_preprocess_keys.

Oversight in commit 5bf748b8, which enhanced nbtree ScalarArrayOp
execution.

Reported-By: Donghang Lin <donghanglin@gmail.com>
Discussion: https://postgr.es/m/CAA=D8a2sHK6CAzZ=0CeafC-Y-MFXbYxnRSHvZTi=+JHu6kAa8Q@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f22e17f76cf569a797c45268081feadc8ebd68c7

Modified Files
--------------
src/backend/access/nbtree/nbtutils.c | 7 +++++++
1 file changed, 7 insertions(+)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2024-04-18 15:49 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-06-06 02:04 pg-migrator - pg_migrator: Warn about uninstalling user-data linked User Bmomjian <bmomjian@pgfoundry.org>
2024-04-18 15:49 pgsql: Don't try to fix eliminated nbtree array scan keys. Peter Geoghegan <pg@bowt.ie>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox