Messages

1

Suggestions and Requests / Re: set a combination of columns of a table as uni

« on: January 12, 2006, 01:16:19 am »

Ah, this way it works...

Thanks alot!

2

Suggestions and Requests / set a combination of columns of a table as unique

« on: January 11, 2006, 04:08:43 am »

Is it possible in EA to set a combination of columns as unique?
So the generated ddl output will look like this:
----------------------------------------------------------
CREATE TABLE uniquetest
(
 a int4 ,
 b int4 ,
 c int4,
 CONSTRAINT uniquetest_pkey PRIMARY KEY (a, b),
 CONSTRAINT uniquetest_mandant_key UNIQUE (a, c)
)
----------------------------------------------------------
When i set the columns in EA separately as UNIQUE the
ddl script declares the columns separately as UNIQUE as well.

Any ideas?    

3

General Board / Re: Probs or Bug /w FKs referencing  group of

« on: January 23, 2006, 03:35:26 am »

Cool it works! The problem with the lost foreign keys seems also to be vanished. ( I also had the problem that not all
fk's has been generated, and I forgot to tell about this)  

Thanks alot ;-)

   Joshua
 

4

General Board / Probs or Bug /w FKs referencing  group of col

« on: January 12, 2006, 03:16:47 am »

Hi!

I have a Problem within the generated ddl code when it comes to foreign keys referencing a group of columns
(here's an example):



As you can see, I want to create a foreign key relationsship
for sonID and fatherID, each referencing the columngroup
(maleID, familyID). So here it is for the father FK:

Up to here everything seems fine.
But when I generate the ddl code I get this result:
-----------------------------
ALTER TABLE isFatherOf ADD CONSTRAINT FK_isFatherOf_maleMembersOfFamily_father

FOREIGN KEY (fatherID, familyID) REFERENCES maleMembersOfFamily (, familyID)
;
------------------------------

But instead it should be
-----------------------------
ALTER TABLE isFatherOf ADD CONSTRAINT FK_isFatherOf_maleMembersOfFamily_father

FOREIGN KEY (fatherID, familyID) REFERENCES maleMembersOfFamily (maleID, familyID)
;
------------------------------
Is it up to me, do I anything wrong, or does it seem to be a bug of EA?
(btw I'm using Program version 6.0.781)

thanks ahead

   joshua