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