Home » U++ Library support » U++ SQL » Multiple DUAL_UNIQUE generate conflicting statements
| Multiple DUAL_UNIQUE generate conflicting statements [message #49869] |
Wed, 23 May 2018 11:36  |
busiek
Messages: 64
Registered: February 2011
Location: Poland
|
Member |
|
|
This is a problem for PostgreSQL backend for sure.
TABLE(T)
...
DUAL_UNIQUE(A, B)
DUAL_UNIQUE(C, D)
END_TABLE
will generate A_script.sql containing:
...
alter table T add constraint DQ_T unique (A, B);
alter table T add constraint DQ_T unique (C, D);
Constraint names should be unique. The way to fix it is to add column names to the constraint name separated by some special symbol.
|
|
|
|
Current Time: Tue Apr 16 09:07:46 CEST 2024
Total time taken to generate the page: 0.01221 seconds
|
Members
Pages
Help
Register
Login
Home
