[Kamailio-Devel] another db schema generation problem

Dan Pascu dan at ag-projects.com
Fri Aug 1 17:15:49 CEST 2008


On Friday 01 August 2008, Henning Westerholt wrote:
> On Thursday 31 July 2008, Dan Pascu wrote:
> > It appears that the way indexes are generated has changed. Previously
> > they were intergrated in the table creation, now they are created
> > after the table is created. This breaks foreign key constrains, which
> > no longer find the index to use.
> > [..]
>
> Hi Dan,
>
> yes, i changed this three months ago during the preparations for
> oracle. It allowed me to use the same code for all the SQL databases,
> as postgres in 1.3 creates this already after the tables and also use
> the "CONSTRAINT" syntax. As foreign keys are not used in the trunk, i
> did not test this use cases.

Unfortunately that is the problem we also had in the past. Changes that 
add something or fix some issue in the dbschema, break something else. A 
fix somewhere is a regression elsewhere. That and the general attitude 
that if something is not directly used by trunk nobody cares.

-- 
Dan



More information about the Devel mailing list