pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedpgfouine - pgfouine: applied a patch from Steve Woodcock to fix a long
2+ messages / 2 participants
[nested] [flat]
* pgfouine - pgfouine: applied a patch from Steve Woodcock to fix a long
@ 2009-04-05 20:55 User Gsmet <gsmet@pgfoundry.org>
0 siblings, 0 replies; 2+ messages in thread
From: gsmet@pgfoundry.org @ 2009-04-05 20:55 UTC (permalink / raw)
To: pgsql-committers
Log Message:
-----------
applied a patch from Steve Woodcock to fix a long standing problem resulting in leading "statement: " in the query text for some queries
Modified Files:
--------------
pgfouine:
ChangeLog (r1.79 -> r1.80)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/ChangeLog.diff?r1=1.79&r2=1.80)
pgfouine/include/postgresql:
PostgreSQLRegexps.lib.php (r1.14 -> r1.15)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/PostgreSQLRegexps.l...)
^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Allow specifying an access method for partitioned tables
@ 2024-03-25 15:31 Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 0 replies; 2+ messages in thread
From: Alvaro Herrera @ 2024-03-25 15:31 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Allow specifying an access method for partitioned tables
It's now possible to specify a table access method via
CREATE TABLE ... USING for a partitioned table, as well change it with
ALTER TABLE ... SET ACCESS METHOD. Specifying an AM for a partitioned
table lets the value be used for all future partitions created under it,
closely mirroring the behavior of the TABLESPACE option for partitioned
tables. Existing partitions are not modified.
For a partitioned table with no AM specified, any new partitions are
created with the default_table_access_method.
Also add ALTER TABLE ... SET ACCESS METHOD DEFAULT, which reverts to the
original state of using the default for new partitions.
The relcache of partitioned tables is not changed: rd_tableam is not
set, even if a partitioned table has a relam set.
Author: Justin Pryzby <pryzby@telsasoft.com>
Author: Soumyadeep Chakraborty <soumyadeep2007@gmail.com>
Author: Michaël Paquier <michael@paquier.xyz>
Reviewed-by: The authors themselves
Discussion: https://postgr.es/m/CAE-ML+9zM4wJCGCBGv01k96qQ3gFv4WFcFy=zqPHKeaEFwwv6A@mail.gmail.com
Discussion: https://postgr.es/m/20210308010707.GA29832%40telsasoft.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/374c7a2290429eac3217b0c7b0b485db9c2bcc72
Modified Files
--------------
doc/src/sgml/catalogs.sgml | 10 +-
doc/src/sgml/ref/alter_table.sgml | 18 +++-
doc/src/sgml/ref/create_table.sgml | 4 +
src/backend/commands/tablecmds.c | 165 ++++++++++++++++++++++++++------
src/backend/utils/cache/lsyscache.c | 22 +++++
src/backend/utils/cache/relcache.c | 7 ++
src/bin/pg_dump/pg_dump.c | 3 +-
src/bin/pg_dump/t/002_pg_dump.pl | 35 +++++++
src/include/catalog/pg_class.h | 4 +-
src/include/utils/lsyscache.h | 1 +
src/test/regress/expected/create_am.out | 158 ++++++++++++++++++++++++++++--
src/test/regress/sql/create_am.sql | 91 +++++++++++++++++-
12 files changed, 469 insertions(+), 49 deletions(-)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-03-25 15:31 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-04-05 20:55 pgfouine - pgfouine: applied a patch from Steve Woodcock to fix a long User Gsmet <gsmet@pgfoundry.org>
2024-03-25 15:31 pgsql: Allow specifying an access method for partitioned tables Alvaro Herrera <alvherre@alvh.no-ip.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