> > 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 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
