[Gambas-user] Database manager Save Table problem

Richard Frost dickfrost at ...2291...
Thu Sep 10 18:08:01 CEST 2009


I m a new Gambas2 user, and I am not sure where "little things" like 
this should be posted, so if it should be somewhere else, please let me 
know.

My system is Ubuntu Jaunty 9.04, Gambas2-2.15.2, Postgresql

In the Database Manager, when I save changes to a table which has an 
index defined, I get an error message that the index already exists.

Looking at the code, in FTable.class, function WriteTable,  there are 
two WriteTableDef  calls, the first which creates a temporary table 
(which it deletes afterward), and then a call to write the actual table.

Postgres evidently requires index names to be unique within the 
database, so the create of the temporary table fails as it tries to 
create another index with the same name, and which of course then it 
does not process the write of the actual table.

It works fine if I delete the indexes first, then save the table, then 
add the indexes back (until I save it again).

My guess is that the write of the temporary table exists to ensure there 
aren't any problems in the table definition before the actual table is 
written.

Anyone have any good ideas about a way around this (changing 
FTable.class) ?

And, how does a user "ask" if the changes could be incorporated in Gambas ?

Thanks for the help, Dick




More information about the User mailing list