prefixing - Search results in mailing lists

2025-05-03 19:50:00 | index for LIKE 'prefix%' on text column, but does for equivalent range query (PostgreSQL 17.4) (Abdullah DURSUN)

prefix searches with LIKE 'prefix%'. A btree index on a text column is not used

2025-04-30 14:25:56 | BUG #18908: DEREF_OF_NULL: After having been assigned to a NULL value at descriptor.c (PG Bug reporting form)

prefix, const char *ind_prefix) { *** char *pbuf = (char *) mm_alloc(strlen(name) + ((prefix == NULL) ? 0 : strlen

2025-04-25 08:20:33 | BUG #18903: TRAP: failed Assert("false") in file: "tuplesortvariants.c" (PG Bug reporting form)

prefix=/tmp/pg && make -j8 And running these two files: 1.sql: VACUUM FULL pg_am; VACUUM

2025-04-23 07:48:23 | BUG #18902: TRAP:: failed Assert("!is_sorted") in File: "createplan.c" (PG Bug reporting form)

prefix=/tmp/pg && make -j8 && make install` And executed the following script: ``` CREATE EXTENSION postgres_fdw; CREATE

2025-04-23 04:41:20 | RE: Disabled logical replication origin session causes primary key errors (Hayato Kuroda (Fujitsu))

prefix. After considering more, instances would be created within the test and we ensure to connect

2025-04-17 02:54:23 | Re: BUG #18897: Logical replication conflict after using pg_createsubscriber under heavy load (Zane Duffield)

prefix = '%m [%p] port=$PRIMARY_PORT %q%u@%d/%a ' EOF cat >> "$PRIMARY_DIR"/pg_hba.conf

2025-04-12 05:17:28 | Re: BUG #18831: Particular queries using gin-indexes are not interruptible, resulting is resource usage (Vinod Sridharan)

prefix, STORAGE text; REATE TABLE mytexttable (value tsvector); -- insert a single row that has one field

2025-04-04 22:26:17 | Re: BUG #18877: PostgreSQL triggers assertion failure (Liang, Yu)

prefix=$(pwd) --exec-prefix=$(pwd) --enable-cassert`, triggered Assertion Failure when executing the following statement

2025-04-04 22:15:14 | BUG #18878: PostgreSQL triggers Assertion Failure in Debug build (PG Bug reporting form)

prefix=$(pwd) --exec-prefix=$(pwd) --enable-cassert`, triggered Assertion Failure when executing the following statement

2025-03-14 12:12:41 | BUG #18848: DEREF_AFTER_NULL.EX.COND After having been compared to a NULL (PG Bug reporting form)

prefix, type->counter); if (ind_type != NULL) - ECPGdump_a_simple(o, ind_name, ind_type

2025-03-06 19:50:37 | Re: BUG #18825: Row value equality predicates do not use indices (Nico Williams)

prefix) index then one think that skip-scanning the b-tree would be much faster

2025-02-19 22:02:34 | Re: BUG #18594: CASE WHEN ELSE failing to return the expected output when the same (Vik Fearing)

prefix your literals with their type, you wouldn't be having these problems in the first

2025-02-05 23:24:52 | Bug in recovery of drop database? (David Steele)

prefix = '%m %L ' autovacuum = off We have seen this several times now because a favorite

2025-01-06 11:24:33 | BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction. (PG Bug reporting form)

prefix and their parameters format. But I discovered that when the schema holding these functions

2024-11-25 15:26:52 | BUG #18724: High data disk utilization during log writing (PG Bug reporting form)

prefix= '%m [%p] %d %a %u %h %c ' # special values: cluster_name = '16/main' # added to process