drupal-9.pgsql-orphan-sequence.php

<?php

// @codingStandardsIgnoreFile
use Drupal\Core\Database\Database;
$connection = Database::getConnection();
$db_type = $connection->databaseType();
// Creates a table, then adds a sequence without ownership to simulate tables
// that were altered from integer to serial columns.
$connection->schema()
  ->createTable('pgsql_sequence_test', [
  'fields' => [
    'sequence_field' => [
      'type' => 'int',
      'not null' => TRUE,
      'unsigned' => TRUE,
    ],
  ],
  'primary key' => [
    'sequence_field',
  ],
]);
$seq = $connection->makeSequenceName('pgsql_sequence_test', 'sequence_field');
$connection->query('CREATE SEQUENCE ' . $seq);
// Enables the pgsql_test module so that the pgsql_sequence_test schema will
// be available.
$extensions = $connection->query("SELECT data FROM {config} where name = 'core.extension'")
  ->fetchField();
$extensions = unserialize($extensions);
$extensions['module']['pgsql_test'] = 1;
$connection->update('config')
  ->fields([
  'data' => serialize($extensions),
])
  ->condition('name', 'core.extension')
  ->execute();
$connection->delete('cache_config')
  ->condition('cid', 'core.extension')
  ->execute();