[ignore] issue for testing patches

1. +++ b/core/modules/pgsql/src/Driver/Database/pgsql/Schema.php
   @@ -956,7 +956,7 @@ public function changeField($table, $field, $field_new, $spec, $new_keys = []) {
          // not when altering. Because of that, the sequence needs to be created
   ...
   +      $this->connection->query("CREATE SEQUENCE " . $seq . " OWNED BY {" . $table . "}." . $field_new);
   

   Can we put the $field_new in normal brackets. The brackets will be replaced by quotes by Drupal.

2. +++ b/core/modules/pgsql/src/Driver/Database/pgsql/Schema.php
   @@ -1062,6 +1062,80 @@ public function extensionExists($name): bool {
   +    $table_name = $this->connection->prefixTables('{' . $table . '}');
   +    $this->connection->query('ALTER SEQUENCE IF EXISTS ' . $seq . ' OWNED BY ' . $table_name . '.' . $column);
   

   Can we change this into a single line. Like:'ALTER SEQUENCE IF EXISTS ' . $seq . ' OWNED BY {' . $table_name . '}.[' . $column . ']'

3. +++ b/core/modules/pgsql/src/Driver/Database/pgsql/Schema.php
   @@ -1062,6 +1062,80 @@ public function extensionExists($name): bool {
   +    $args = [
   +      ':table' => $this->connection->getPrefix() . $table,
   +      ':column' => $column,
   +    ];
   +    return $this->connection
   +        ->query("SELECT pg_get_serial_sequence(:table, :column)", $args)
   +      ->fetchField();
   

   Can we change this to:

     return $this->connection
       ->query("SELECT pg_get_serial_sequence(:table, :column)", 
         ':table' => $this->connection->getPrefix() . $table,
         ':column' => $column,
       )
       ->fetchField();
   

4. +++ b/core/modules/pgsql/tests/src/Functional/Database/PostgreSqlSequenceUpdateTest.php
   @@ -0,0 +1,45 @@
   +    // Run the updates.
   +    $this->runUpdates();
   

   Can we check that the table does not own the sequence before we run the updates.

5. +++ b/core/modules/system/system.install
   @@ -1755,5 +1756,124 @@ function system_update_10100(&$sandbox = NULL) {
   +function system_update_10101(&$sandbox) {
   

   This function needs to be moved to the pgsql module.

6. +++ b/core/modules/pgsql/tests/src/Kernel/pgsql/SchemaTest.php
   @@ -243,4 +243,49 @@ public function testPgsqlExtensionExists(): void {
   +  public function  testPgsqlSequences(): void {
   

   This does not test what we need to test. What we need to test are the methods: getSequenceName() and sequenceExists().

@daffie i forgot to add the new files in this patch, so here they are.

Also a interdiff for issue #3028706 comparing this one with the #70 from andypost.

Big serial test

Updating the title per Special issue titles → .