[Postgres] Sysntx error in database Script #22128
Labels
Affected/7.1.0-m6
Issues that get reported against IS7.1.0 M6 pack will get this label
DB/postgres
postgres DB related Issues will be tracked under this label.
Priority/Highest
QA-Reported
Issues reported by a QA
Severity/Blocker
Team/Identity Server Core
Type/Bug
Description
PostgreSQL throws a syntax error due to the improper placement of the UNIQUE constraint inside the PRIMARY KEY declaration in IDN_RULE table creation query.
https://github.com/wso2/carbon-identity-framework/blob/master/features/identity-core/org.wso2.carbon.identity.core.server.feature/resources/dbscripts/postgresql.sql#L1674
Steps to Reproduce
Execute the following SQL script on a PostgreSQL database:
Version
IS 7.1.0-M6
Environment Details (with versions)
Postgres 17
The text was updated successfully, but these errors were encountered: