Welcome to mirror list, hosted at ThFree Co, Russian Federation.

gitlab.com/gitlab-org/gitlab-foss.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGitLab Bot <gitlab-bot@gitlab.com>2021-11-18 16:16:36 +0300
committerGitLab Bot <gitlab-bot@gitlab.com>2021-11-18 16:16:36 +0300
commit311b0269b4eb9839fa63f80c8d7a58f32b8138a0 (patch)
tree07e7870bca8aed6d61fdcc810731c50d2c40af47 /db/migrate/20201019161924_add_partitioned_table_view.rb
parent27909cef6c4170ed9205afa7426b8d3de47cbb0c (diff)
Add latest changes from gitlab-org/gitlab@14-5-stable-eev14.5.0-rc42
Diffstat (limited to 'db/migrate/20201019161924_add_partitioned_table_view.rb')
-rw-r--r--db/migrate/20201019161924_add_partitioned_table_view.rb44
1 files changed, 0 insertions, 44 deletions
diff --git a/db/migrate/20201019161924_add_partitioned_table_view.rb b/db/migrate/20201019161924_add_partitioned_table_view.rb
deleted file mode 100644
index 45bbfda40ff..00000000000
--- a/db/migrate/20201019161924_add_partitioned_table_view.rb
+++ /dev/null
@@ -1,44 +0,0 @@
-# frozen_string_literal: true
-
-class AddPartitionedTableView < ActiveRecord::Migration[6.0]
- DOWNTIME = false
-
- def up
- execute(<<~SQL)
- CREATE OR REPLACE VIEW postgres_partitioned_tables AS
- SELECT
- pg_namespace.nspname::text || '.'::text || pg_class.relname::text AS identifier,
- pg_class.oid AS oid,
- pg_namespace.nspname AS schema,
- pg_class.relname AS name,
- CASE partitioned_tables.partstrat
- WHEN 'l' THEN 'list'
- WHEN 'r' THEN 'range'
- WHEN 'h' THEN 'hash'
- END as strategy,
- array_agg(pg_attribute.attname) as key_columns
- FROM (
- SELECT
- partrelid,
- partstrat,
- unnest(partattrs) as column_position
- FROM pg_partitioned_table
- ) partitioned_tables
- INNER JOIN pg_class
- ON partitioned_tables.partrelid = pg_class.oid
- INNER JOIN pg_namespace
- ON pg_class.relnamespace = pg_namespace.oid
- INNER JOIN pg_attribute
- ON pg_attribute.attrelid = pg_class.oid
- AND pg_attribute.attnum = partitioned_tables.column_position
- WHERE pg_namespace.nspname = current_schema()
- GROUP BY identifier, pg_class.oid, schema, name, strategy;
- SQL
- end
-
- def down
- execute(<<~SQL)
- DROP VIEW IF EXISTS postgres_partitioned_tables
- SQL
- end
-end