Hi, it doesn't seem to be possible to define an index like this:
CREATE INDEX location_trgm_idx ON location USING gist (address gist_trgm_ops); http://www.postgresql.org/docs/current/static/pgtrgm.html After a quick look at index.py it should be possible to patch it to accept a new parameter for example "using" and insert it into the sql creation in: def sqliteCreateIndexSQL(self, soClass): [...] ret = 'CREATE %s %s_%s ON %s (%s)' % \ (uniqueOrIndex, self.soClass.sqlmeta.table, self.name, self.soClass.sqlmeta.table, ', '.join(spec)) return ret should get something like: def sqliteCreateIndexSQL(self, soClass): [...] ret = 'CREATE %s %s_%s ON %s %s (%s)' % \ (uniqueOrIndex, self.soClass.sqlmeta.table, self.name, self.soClass.sqlmeta.table, self.using, ', '.join(spec) ) return ret I don't know if this is a postgresql specific thing or not and should therefore only be inserted for postgresql. Is such a patch welcomed? -- Greg ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
