Re: removing a unique constraint
Oleg Broytman <[email protected]>
| Newsgroups | gmane.comp.python.sqlobject |
|---|---|
| Message-ID | <[email protected]> |
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/ [email protected]
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev