Postgres schema doesn't support keylength on a unique index

The Needs Review Queue Bot → tested this issue. It either no longer applies to Drupal core, or fails the Drupal core commit checks. Therefore, this issue status is now "Needs work".

Apart from a re-roll or rebase, this issue may need more work to address feedback in the issue or MR comments. To progress an issue, incorporate this feedback as part of the process of updating the issue. This helps other contributors to know what is outstanding.

Consult the Drupal Contributor Guide → to find step-by-step guides for working with issues.

Re-roll.

The Needs Review Queue Bot → tested this issue. It no longer applies to Drupal core. Therefore, this issue status is now "Needs work".

Apart from a re-roll or rebase, this issue may need more work to address feedback in the issue or MR comments. To progress an issue, incorporate this feedback as part of the process of updating the issue. This helps other contributors to know what is outstanding.

Consult the Drupal Contributor Guide → to find step-by-step guides for working with issues.

Oops, wrong patch file.

My bad, the postgres test failures need addressing.

This should do it.
Escaping of the field names already happens in createPrimaryKeySql(), so no need to call escapeField(), too.

Changes looks good and covered with yesrs, queued tests for pgsql and sqlite

Updating issue credits

Committed to 10.1.x and 10.0.x

Doesn't apply to 9.5.x, marking as patch to be ported.

Thanks folks!

Rolled this back from 10.0.x, ::getPrefix doens't exist there so HEAD was broken

Since we don't have the ::getPrefix method in 10.0.x, I think we should leave this in 10.1.x - makes it not a straight backport.

Given the conditional

   protected function supportsPrefixLength(): bool {
	
    return $this->connection->driver() === 'mysql';
	
  } 

the test should have been a DriverSpecificDatabaseTestBase extending test, no?

Sorry for late feedback

@mondrake: I have created the followup for extending DriverSpecificDatabaseTestBase. See: 3351886