Project

General

Profile

Actions
Copy link

Bug #93223

open

Wrong syntax for ALTER INDEX on PostgreSQL

Added by Jörn Wagner over 3 years ago. Updated over 1 year ago.

Status:
Accepted
Priority:
Should have
Assignee:
Stefan Bürk
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2021-01-05
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
7.4
Tags:
postgresql
Complexity:
Is Regression:
Sprint Focus:

Description

Database compare generates statements like ALTER INDEX public_index_phash_freeindexuid2_idx RENAME TO "freeIndexUid_65098221". This results in an error:

/* ERROR:  relation "public_index_phash_freeindexuid2_idx" does not exist */

The first argument needs to be quoted and case-sensitive like ALTER INDEX "public_index_phash_freeIndexUid2_idx" RENAME TO "freeIndexUid_65098221".

My PostgreSQL version is 12.5.

Related issues 1 (1 open — 0 closed)

Related to TYPO3 Core - Epic #90719: PostgreSQL related issuesAccepted2020-03-10

Actions
Actions
Copy link

Also available in: Atom PDF