[Gambas-user] Database manager Save Table problem

Benoît Minisini gambas at ...1...
Thu Sep 10 21:32:52 CEST 2009


> 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...

-- 
Benoît Minisini




More information about the User mailing list