[Gambas-user] Database manager Save Table problem

[Benoît Minisini]

> > Benoît Minisini a écrit :
> > ...
> >
> > > Apparently on other database systems, two index can have the same name
> > > provided they are on different tables.
> >
> > ? strange (and I'm not sure this fit in SQLs standards)
> >
> > However, in PG, you can't have a doublon, either it is from tables,
> >  indexes, sequences (exception for functions, unless args are the same)
> >  unless your items are in different schemas.
> >
> > > I will modify the postgresql driver to add the table name before each
> > > index, it should solve the problem.
> >
> > Be careful because this is PG's standard naming system; an index is
> > automatically named as:
> > tablename_columnname_key (..._pkey for primary keys)
> 
> Yep. Modifying the driver is not the solution at all. I must modify the IDE
> instead...
> 

I modified the algorithm used by the database manager to save table definition 
so that index names do not conflict. The fix is in revision 2330 for Gambas 2.

I will make a 2.16.1 release soon.

Regards,

-- 
Benoît Minisini