[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