U++ framework: U++ SQL » Multiple DUAL_UNIQUE generate conflicting statements

Home » U++ Library support » U++ SQL » Multiple DUAL_UNIQUE generate conflicting statements

Wed, 23 May 2018 11:36

busiek
Messages: 71
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.

		Multiple DUAL_UNIQUE generate conflicting statements By: busiek on Wed, 23 May 2018 11:36
		Re: Multiple DUAL_UNIQUE generate conflicting statements By: mirek on Wed, 27 June 2018 10:35
		Re: Multiple DUAL_UNIQUE generate conflicting statements By: busiek on Wed, 27 June 2018 15:50
		Re: Multiple DUAL_UNIQUE generate conflicting statements By: zsolt on Sun, 14 July 2019 02:30
		Re: Multiple DUAL_UNIQUE generate conflicting statements By: mirek on Wed, 17 July 2019 10:42

Previous Topic:	SQLite On delete cascade .sch ?
Next Topic:	BOOL in SQLite

Goto Forum:

] [

]

Current Time: Mon Sep 07 04:02:34 GMT+2 2026

Total time taken to generate the page: 0.00655 seconds