/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/modules/test_ddl_deparse/expected/alter_table.out
153 строки
8 KB
Alexander Korotkov
Implement ALTER TABLE ... SPLIT PARTITION ... command
14 дек 2025, 14:29
14 дек 2025, 14:29
4b3d173
Код
Авторство
О чём код?
CREATE TABLE parent ( a int ); NOTICE: DDL test: type simple, tag CREATE TABLE ALTER TABLE parent SET (fillfactor = 50); NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SET RELOPTIONS desc <NULL> ALTER TABLE parent RESET (fillfactor); NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type RESET RELOPTIONS desc <NULL> ALTER TABLE parent SET UNLOGGED; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SET UNLOGGED desc <NULL> ALTER TABLE parent SET LOGGED; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SET LOGGED desc <NULL> CREATE INDEX parent_index ON parent(a); NOTICE: DDL test: type simple, tag CREATE INDEX ALTER TABLE parent CLUSTER ON parent_index; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type CLUSTER desc index parent_index DROP INDEX parent_index; CREATE TABLE child () INHERITS (parent); NOTICE: DDL test: type simple, tag CREATE TABLE CREATE TABLE grandchild () INHERITS (child); NOTICE: DDL test: type simple, tag CREATE TABLE ALTER TABLE parent ADD COLUMN b serial; NOTICE: DDL test: type simple, tag CREATE SEQUENCE NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type ADD COLUMN (and recurse) desc column b of table parent NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint parent_b_not_null on table parent NOTICE: DDL test: type simple, tag ALTER SEQUENCE ALTER TABLE parent RENAME COLUMN b TO c; NOTICE: DDL test: type simple, tag ALTER TABLE -- Constraint, no recursion ALTER TABLE ONLY grandchild ADD CONSTRAINT a_pos CHECK (a > 0); NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type ADD CONSTRAINT desc constraint a_pos on table grandchild -- Constraint, with recursion ALTER TABLE parent ADD CONSTRAINT a_pos CHECK (a > 0); NOTICE: merging constraint "a_pos" with inherited definition NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint a_pos on table parent ALTER TABLE parent ALTER COLUMN a SET NOT NULL; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SET NOT NULL (and recurse) desc constraint parent_a_not_null on table parent ALTER TABLE parent ALTER COLUMN a DROP NOT NULL; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type DROP NOT NULL (and recurse) desc column a of table parent ALTER TABLE parent ALTER COLUMN a SET NOT NULL; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SET NOT NULL (and recurse) desc constraint parent_a_not_null on table parent ALTER TABLE parent ALTER COLUMN a ADD GENERATED ALWAYS AS IDENTITY; NOTICE: DDL test: type simple, tag CREATE SEQUENCE NOTICE: DDL test: type simple, tag ALTER SEQUENCE NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type ADD IDENTITY (and recurse) desc column a of table parent ALTER TABLE parent ALTER COLUMN a SET GENERATED BY DEFAULT; NOTICE: DDL test: type simple, tag ALTER SEQUENCE NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SET IDENTITY (and recurse) desc column a of table parent ALTER TABLE parent ALTER COLUMN a DROP IDENTITY; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type DROP IDENTITY (and recurse) desc column a of table parent ALTER TABLE parent ALTER COLUMN a SET STATISTICS 100; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SET STATS desc column a of table parent NOTICE: subcommand: type SET STATS desc column a of table child NOTICE: subcommand: type SET STATS desc column a of table grandchild ALTER TABLE parent ALTER COLUMN a SET STORAGE PLAIN; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SET STORAGE desc column a of table parent NOTICE: subcommand: type SET STORAGE desc column a of table child NOTICE: subcommand: type SET STORAGE desc column a of table grandchild ALTER TABLE parent ENABLE ROW LEVEL SECURITY; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type ENABLE ROW SECURITY desc <NULL> ALTER TABLE parent NO FORCE ROW LEVEL SECURITY; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type NO FORCE ROW SECURITY desc <NULL> ALTER TABLE parent FORCE ROW LEVEL SECURITY; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type FORCE ROW SECURITY desc <NULL> ALTER TABLE parent DISABLE ROW LEVEL SECURITY; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type DISABLE ROW SECURITY desc <NULL> CREATE STATISTICS parent_stat (dependencies) ON a, c FROM parent; NOTICE: DDL test: type simple, tag CREATE STATISTICS ALTER TABLE parent ALTER COLUMN c TYPE numeric; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type ALTER COLUMN SET TYPE desc column c of table parent NOTICE: subcommand: type ALTER COLUMN SET TYPE desc column c of table child NOTICE: subcommand: type ALTER COLUMN SET TYPE desc column c of table grandchild NOTICE: subcommand: type (re) ADD CONSTRAINT desc constraint parent_b_not_null on table parent NOTICE: subcommand: type (re) ADD STATS desc statistics object parent_stat ALTER TABLE parent ALTER COLUMN c SET DEFAULT 0; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type ALTER COLUMN SET DEFAULT desc column c of table parent NOTICE: subcommand: type ALTER COLUMN SET DEFAULT desc column c of table child NOTICE: subcommand: type ALTER COLUMN SET DEFAULT desc column c of table grandchild CREATE TABLE part ( a int ) PARTITION BY RANGE (a); NOTICE: DDL test: type simple, tag CREATE TABLE CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100); NOTICE: DDL test: type simple, tag CREATE TABLE CREATE TABLE part2 (a int); NOTICE: DDL test: type simple, tag CREATE TABLE ALTER TABLE part ATTACH PARTITION part2 FOR VALUES FROM (101) to (200); NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type ATTACH PARTITION desc table part2 ALTER TABLE part DETACH PARTITION part2; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type DETACH PARTITION desc table part2 DROP TABLE part2; CREATE TABLE part2 PARTITION OF part FOR VALUES FROM (100) to (200); NOTICE: DDL test: type simple, tag CREATE TABLE ALTER TABLE part MERGE PARTITIONS (part1, part2) INTO part1; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type MERGE PARTITIONS desc <NULL> ALTER TABLE part SPLIT PARTITION part1 INTO (PARTITION part1 FOR VALUES FROM (1) to (100), PARTITION part2 FOR VALUES FROM (100) to (200)); NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SPLIT PARTITION desc <NULL> ALTER TABLE part ADD PRIMARY KEY (a); NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint part_a_not_null on table part NOTICE: subcommand: type ADD INDEX desc index part_pkey CREATE TABLE tbl ( a int generated always as (b::int * 2) stored, b text ); NOTICE: DDL test: type simple, tag CREATE TABLE ALTER TABLE tbl ALTER COLUMN a SET EXPRESSION AS (b::int * 3); NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SET EXPRESSION desc column a of table tbl ALTER TABLE tbl ALTER COLUMN a DROP EXPRESSION; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type DROP EXPRESSION desc column a of table tbl ALTER TABLE tbl ALTER COLUMN b SET COMPRESSION pglz; NOTICE: DDL test: type alter table, tag ALTER TABLE NOTICE: subcommand: type SET COMPRESSION desc column b of table tbl CREATE TYPE comptype AS (r float8); NOTICE: DDL test: type simple, tag CREATE TYPE CREATE DOMAIN dcomptype AS comptype; NOTICE: DDL test: type simple, tag CREATE DOMAIN ALTER DOMAIN dcomptype ADD CONSTRAINT c1 check ((value).r > 0); NOTICE: DDL test: type simple, tag ALTER DOMAIN ALTER TYPE comptype ALTER ATTRIBUTE r TYPE bigint; NOTICE: DDL test: type alter table, tag ALTER TYPE NOTICE: subcommand: type ALTER COLUMN SET TYPE desc column r of composite type comptype NOTICE: subcommand: type (re) ADD DOMAIN CONSTRAINT desc type dcomptype