Re: Indexes with primary key
Oleg Broytman <[email protected]> Tue, 26 Aug 2014 00:21:12 +0200
| Newsgroups | gmane.comp.python.sqlobject |
|---|---|
| Message-ID | <[email protected]> |
Hi! On Mon, Aug 25, 2014 at 10:22:32AM +0200, Gert Burger <[email protected]> wrote: > Is it possible to create indexes using SQLO that include the current > 'Table's primary key? > eg DatabaseIndex(col1, col2, col3, 'id') > > Currently SQLO is complaining that the column doesn't exist. It seems you're right -- SQLObject creates indices that can only include explicitly declared columns, and id is and implicit column. On the other hand why do you want to create and index with id at all? Isn't an index with a unique non-null column equivalent to index with exactly that column? Oleg. -- Oleg Broytman http://phdru.name/ [email protected] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------------ Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/