pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql: Typo fix.
7+ messages / 2 participants
[nested] [flat]
* pgsql: Typo fix.
@ 2009-04-26 02:56 Tom Lane <tgl@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: tgl@postgresql.org @ 2009-04-26 02:56 UTC (permalink / raw)
To: pgsql-committers
Log Message:
-----------
Typo fix.
Modified Files:
--------------
pgsql/doc/src/sgml/ref:
truncate.sgml (r1.32 -> r1.33)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/truncate.sgml?r1=1.32&r2=1.33)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: reindexdb: Skip reindexing temporary tables and indexes.
@ 2024-09-30 02:18 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2024-09-30 02:18 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
reindexdb: Skip reindexing temporary tables and indexes.
Reindexing temp tables or indexes of other sessions is not allowed.
However, reindexdb in parallel mode previously listed them as
the objects to process, leading to failures.
This commit ensures reindexdb in parallel mode skips temporary tables
and indexes by adding a condition based on the relpersistence column
in pg_class to the object listing queries, preventing these issues.
Note that this commit does not affect reindexdb when temporary tables
or indexes are explicitly specified using the -t or -j options;
reindexdb in that case still does not skip them and can cause an error.
Back-patch to v13 where parallel mode was introduced in reindexdb.
Author: Fujii Masao
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/5f37ee56-14fb-44fe-9150-9eb97e10538b@oss.nttdata.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/20cfec896c6a20ca436f634b0ffa3582d7b9425c
Modified Files
--------------
src/bin/scripts/reindexdb.c | 4 ++++
1 file changed, 4 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: reindexdb: Skip reindexing temporary tables and indexes.
@ 2024-09-30 02:18 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2024-09-30 02:18 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
reindexdb: Skip reindexing temporary tables and indexes.
Reindexing temp tables or indexes of other sessions is not allowed.
However, reindexdb in parallel mode previously listed them as
the objects to process, leading to failures.
This commit ensures reindexdb in parallel mode skips temporary tables
and indexes by adding a condition based on the relpersistence column
in pg_class to the object listing queries, preventing these issues.
Note that this commit does not affect reindexdb when temporary tables
or indexes are explicitly specified using the -t or -j options;
reindexdb in that case still does not skip them and can cause an error.
Back-patch to v13 where parallel mode was introduced in reindexdb.
Author: Fujii Masao
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/5f37ee56-14fb-44fe-9150-9eb97e10538b@oss.nttdata.com
Branch
------
REL_17_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/77f1546819818aa740fd8e54427ccb33f507f2cf
Modified Files
--------------
src/bin/scripts/reindexdb.c | 4 ++++
1 file changed, 4 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: reindexdb: Skip reindexing temporary tables and indexes.
@ 2024-09-30 02:19 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2024-09-30 02:19 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
reindexdb: Skip reindexing temporary tables and indexes.
Reindexing temp tables or indexes of other sessions is not allowed.
However, reindexdb in parallel mode previously listed them as
the objects to process, leading to failures.
This commit ensures reindexdb in parallel mode skips temporary tables
and indexes by adding a condition based on the relpersistence column
in pg_class to the object listing queries, preventing these issues.
Note that this commit does not affect reindexdb when temporary tables
or indexes are explicitly specified using the -t or -j options;
reindexdb in that case still does not skip them and can cause an error.
Back-patch to v13 where parallel mode was introduced in reindexdb.
Author: Fujii Masao
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/5f37ee56-14fb-44fe-9150-9eb97e10538b@oss.nttdata.com
Branch
------
REL_16_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/653ce5b8b79cffb163216cd53fec78d260d992b8
Modified Files
--------------
src/bin/scripts/reindexdb.c | 4 ++++
1 file changed, 4 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: reindexdb: Skip reindexing temporary tables and indexes.
@ 2024-09-30 02:19 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2024-09-30 02:19 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
reindexdb: Skip reindexing temporary tables and indexes.
Reindexing temp tables or indexes of other sessions is not allowed.
However, reindexdb in parallel mode previously listed them as
the objects to process, leading to failures.
This commit ensures reindexdb in parallel mode skips temporary tables
and indexes by adding a condition based on the relpersistence column
in pg_class to the object listing queries, preventing these issues.
Note that this commit does not affect reindexdb when temporary tables
or indexes are explicitly specified using the -t or -j options;
reindexdb in that case still does not skip them and can cause an error.
Back-patch to v13 where parallel mode was introduced in reindexdb.
Author: Fujii Masao
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/5f37ee56-14fb-44fe-9150-9eb97e10538b@oss.nttdata.com
Branch
------
REL_15_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/92cc21d158f30d46642b5123697f71b7a740fbd7
Modified Files
--------------
src/bin/scripts/reindexdb.c | 4 ++++
1 file changed, 4 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: reindexdb: Skip reindexing temporary tables and indexes.
@ 2024-09-30 02:19 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2024-09-30 02:19 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
reindexdb: Skip reindexing temporary tables and indexes.
Reindexing temp tables or indexes of other sessions is not allowed.
However, reindexdb in parallel mode previously listed them as
the objects to process, leading to failures.
This commit ensures reindexdb in parallel mode skips temporary tables
and indexes by adding a condition based on the relpersistence column
in pg_class to the object listing queries, preventing these issues.
Note that this commit does not affect reindexdb when temporary tables
or indexes are explicitly specified using the -t or -j options;
reindexdb in that case still does not skip them and can cause an error.
Back-patch to v13 where parallel mode was introduced in reindexdb.
Author: Fujii Masao
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/5f37ee56-14fb-44fe-9150-9eb97e10538b@oss.nttdata.com
Branch
------
REL_14_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/88e1153cb3c668f06ac24fdccd5fab7ec9413097
Modified Files
--------------
src/bin/scripts/reindexdb.c | 4 ++++
1 file changed, 4 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: reindexdb: Skip reindexing temporary tables and indexes.
@ 2024-09-30 02:19 Fujii Masao <fujii@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Fujii Masao @ 2024-09-30 02:19 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
reindexdb: Skip reindexing temporary tables and indexes.
Reindexing temp tables or indexes of other sessions is not allowed.
However, reindexdb in parallel mode previously listed them as
the objects to process, leading to failures.
This commit ensures reindexdb in parallel mode skips temporary tables
and indexes by adding a condition based on the relpersistence column
in pg_class to the object listing queries, preventing these issues.
Note that this commit does not affect reindexdb when temporary tables
or indexes are explicitly specified using the -t or -j options;
reindexdb in that case still does not skip them and can cause an error.
Back-patch to v13 where parallel mode was introduced in reindexdb.
Author: Fujii Masao
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/5f37ee56-14fb-44fe-9150-9eb97e10538b@oss.nttdata.com
Branch
------
REL_13_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/9410f7cbf4ff7bb0b94238b8d5fee4aecf157374
Modified Files
--------------
src/bin/scripts/reindexdb.c | 4 ++++
1 file changed, 4 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-09-30 02:19 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-04-26 02:56 pgsql: Typo fix. Tom Lane <tgl@postgresql.org>
2024-09-30 02:18 pgsql: reindexdb: Skip reindexing temporary tables and indexes. Fujii Masao <fujii@postgresql.org>
2024-09-30 02:18 pgsql: reindexdb: Skip reindexing temporary tables and indexes. Fujii Masao <fujii@postgresql.org>
2024-09-30 02:19 pgsql: reindexdb: Skip reindexing temporary tables and indexes. Fujii Masao <fujii@postgresql.org>
2024-09-30 02:19 pgsql: reindexdb: Skip reindexing temporary tables and indexes. Fujii Masao <fujii@postgresql.org>
2024-09-30 02:19 pgsql: reindexdb: Skip reindexing temporary tables and indexes. Fujii Masao <fujii@postgresql.org>
2024-09-30 02:19 pgsql: reindexdb: Skip reindexing temporary tables and indexes. Fujii Masao <fujii@postgresql.org>
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