[Gambas-user] Database manager Save Table problem

Charlie Reinl Karl.Reinl at ...9...
Thu Sep 10 19:59:14 CEST 2009


Am Donnerstag, den 10.09.2009, 12:08 -0400 schrieb Richard Frost:
> 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
Salut Dick,

for your pb I'v no answer, but

but for your Q: here you are right, 
you found it, ...had you hints ?


-- 
Amicalment
Charlie





More information about the User mailing list