U++ forum: Welcome to the forum

Search on this site

Search in forums

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

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Multiple DUAL_UNIQUE generate conflicting statements [message #49869]

Wed, 23 May 2018 11:36

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

Report message to a moderator

Re: Multiple DUAL_UNIQUE generate conflicting statements [message #50047 is a reply to message #49869]

Wed, 27 June 2018 10:35

mirek
Messages: 14255
Registered: November 2005

Ultimate Member

What about using UNIQUE_LIST instead?

Report message to a moderator

Re: Multiple DUAL_UNIQUE generate conflicting statements [message #50048 is a reply to message #49869]

Wed, 27 June 2018 15:50

busiek
Messages: 70
Registered: February 2011
Location: Poland

Member

Thanks, in UNIQUE_LIST you can name a constraint. I wasn't aware of that. I will use it.

Until now, I simply run A_script.sql manually, by editing the name of conflicting constraint.

Report message to a moderator

Re: Multiple DUAL_UNIQUE generate conflicting statements [message #52066 is a reply to message #50048]

Sun, 14 July 2019 02:30

zsolt
Messages: 702
Registered: December 2005
Location: Budapest, Hungary

Contributor

Fix:

-#define DUAL_UNIQUE(k1, k2)        ATTRIBUTE("alter table @t add constraint DQ_@t unique "\
+#define DUAL_UNIQUE(k1, k2)        ATTRIBUTE("alter table @t add constraint DQ_@t$" #k1 #k2 " unique "\
                                              "(" #k1 ", " #k2 ");",\
-                                             "alter table @t drop constraint DQ_@t;")
+                                             "alter table @t drop constraint DQ_@t$" #k1 #k2 ";")

Report message to a moderator

Re: Multiple DUAL_UNIQUE generate conflicting statements [message #52084 is a reply to message #52066]

Wed, 17 July 2019 10:42

mirek
Messages: 14255
Registered: November 2005

Ultimate Member

Thanks, applied, with a small addition:

#define DUAL_UNIQUE(k1, k2)        ATTRIBUTE("alter table @t add constraint DQ_@t$" #k1 "$" #k2 " unique "\
                                             "(" #k1 ", " #k2 ");",\
                                             "alter table @t drop constraint DQ_@t$" #k1 "$" #k2 ";")

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Apr 29 01:47:51 CEST 2025

Total time taken to generate the page: 0.01688 seconds