opengeodb-begin.sql conflicts DE.sql ?

[rupat]

Hi Guys !

After evaluating opengeodb i have some questions. But i will make an post for every question to keep it simple:

Looking at the opengeodb-begin.sql we see an constraint in the textdata table:

    check (
      (
        (
          (text_type = 500100000 or text_type = 500100004 or
           text_type = 500100002 or text_type = 500700000 or
           text_type = 500700001 or text_type = 500800000 or
           text_type = 500800000 or text_type = 500900000
          ) and
          text_locale like '__%' and
          is_native_lang is not null and
          is_default_name is not null
        ) or
        (
          (text_type = 500100001 or text_type = 500100003 or
           text_type = 500300000 or text_type = 500500000 or
           text_type = 500600000
          ) and
          text_locale is null and
          is_native_lang is null and
          is_default_name is null
        )
      ) and
        (
          (valid_since is null and date_type_since is null) or
          (valid_since is not null and date_type_since is not null)
        )
    )

We see that a check is performed like (A or B) and C
looking at A and B we see that both requires text_type to start with 500……..

ok so i think its only possible to add values with texttype like in this check no 4…. oder 3…. and so on

looking at the DE.sql we find:

INSERT INTO geodb_textdata VALUES(105,400100000,'104',null,null,null,null,null,'3000-01-01',300500000);
INSERT INTO geodb_textdata VALUES(105,400200000,'2',null,null,null,null,null,'3000-01-01',300500000);

at Line 3 and 4 ;)

Any ideas ? i think this will not work.