Benoît Minisini wrote: >> 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. >> > > Apparently on other database systems, two index can have the same name > provided they are on different tables. > > I will modify the postgresql driver to add the table name before each index, > it should solve the problem. > > And, as usual, someone finds a bug just after a new version is released. :-) > > Regards, > > Thanks Benoît,
Sorry about the timing of finding this (relative to the new release), I am a very new Gambas user. So far it is very impressive ... thanks for your's and everyone's hard work. I also made another post which disappeared, so I'll mention it here in case it helps someone else. When I first installed, and tried to edit tables with the database manager, it appeared to do nothing. Eventually I discovered that the workspace area of the window where the table edit forms are was sized so narrow that it didn't show up (I had a hard time even noticing that it was there until I looked at the form design). By dragging it back towards the tree view part of the window, everything was just fine. Thanks again, 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