Page 1 of 1

Alternative way of creating indexes

Posted: Fri May 16, 2008 5:09 pm
by patrickc
Hello,

after trying to install S9Y, there was an error message saying that the indexes in the MySQL database could not be created because of a permission problem.

After looking at phpMyAdmin, I noticed that it was possible to create indexes using the ALTER TABLE command. Would that be an option for future versions of S9Y to use this command?

Regards
Patrick

Re: Alternative way of creating indexes

Posted: Fri May 16, 2008 8:03 pm
by garvinhicking
Hi!

That ALTER TABLE is really a strange workaround. Since the MYSQL files are used for pgsql in most cases (which does not support that syntaX) it would mean some trouble to alter all files and introduce new ones just for pgsql.

IMHO the better way is to fix the permission setup on the database.

Regards,
Garvin