Re: [SQLObject] removing a unique constraint

[Oleg B. <ph...@ph...>]

On Wed, Jul 13, 2011 at 02:24:48AM +0100, Timothy W. Grove wrote:
> Thanks again for your time and help. I've been able to identify the 
> index, but it doesn't appear that sqlite will allow such an index to be 
> dropped:
> 
> raise OperationalError(ErrorMessage(e))
> sqlobject.dberrors.OperationalError: index associated with UNIQUE or 
> PRIMARY KEY constraint cannot be dropped
> 
> Reading further, it looks like I'll have to do things the hard way:
> http://stackoverflow.com/questions/1884787/how-do-i-drop-a-constraint-from-a-sqlite-3-6-21-table

   That's what I meant when I said "tricky SQL".

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.