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