Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Build command fails when using Postgres (MetadataLoader index naming convention is not portable) #252

Open
ajdinmore opened this issue Jun 6, 2023 · 0 comments
Open

Build command fails when using Postgres (MetadataLoader index naming convention is not portable) #252

ajdinmore opened this issue Jun 6, 2023 · 0 comments
Labels
Bug Error or unexpected behavior of already existing functionality

Comments

@ajdinmore
Copy link
Contributor

Schema-Tool failed with Error 'An exception occurred while executing a query: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "idx_dimension" already exists' while executing DDL: CREATE INDEX idx_dimension ON by_store_content (stage, locale)

MetadataLoader adds indexes to the mapping metadata using the same set of names for every entity. Postgres stores almost everything in one big table, making duplicate index name across tables invalid.
ajdinmore added a commit to ajdinmore/SuluContentBundle that referenced this issue Jun 6, 2023
@ajdinmore
Update index naming for compatibility (sulu#252)
dee03eb
@alexander-schranz alexander-schranz added the Bug Error or unexpected behavior of already existing functionality label Aug 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug Error or unexpected behavior of already existing functionality
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@alexander-schranz @ajdinmore