Re: Partitioned tables and [un]loggedness

Nathan Bossart <nathandbossart@gmail.com>

View thread View on postgr.es

From: Nathan Bossart <nathandbossart@gmail.com>

To: Michael Paquier <michael@paquier.xyz>

Cc: "David G. Johnston" <david.g.johnston@gmail.com>, Postgres hackers <pgsql-hackers@lists.postgresql.org>

Date: 2024-09-18T15:58:34Z

Lists: pgsql-hackers

Attachments

add_constraint_using_index_on_part_table.patch (text/plain) patch

On Wed, Sep 18, 2024 at 10:17:47AM -0500, Nathan Bossart wrote:
> Could we also use ATT_PARTITIONED_TABLE to remove the partitioned table
> check in ATExecAddIndexConstraint()?

Eh, never mind.  That ends up being gross because you have to redo the
relation type check in a few places.

-- 
nathan

Commits

psql: Remove PARTITION BY clause in tab completion for unlogged tables
- 361499538c9d 18.0 landed
Remove support for unlogged on partitioned tables
- e2bab2d79204 18.0 landed
Remove ATT_TABLE for ALTER TABLE ... ATTACH/DETACH
- bbba59e69a56 18.0 landed
Introduce ATT_PARTITIONED_TABLE in tablecmds.c
- d69a3f4d70b7 18.0 landed
Refactor some code for ALTER TABLE SET LOGGED/UNLOGGED in tablecmds.c
- 9f87da1cffda 18.0 landed
Remove tab completion for CREATE UNLOGGED MATERIALIZED VIEW.
- 5c1ce1bbbe5f 18.0 cited