On Tue, 2007-02-20 at 02:27 +0100, Lawrence Oluyede wrote: > > All I can think of is to create a new model, say Poll1, with the > > correct fields, do a syncdb, write and execute a python function to > > transfer the data from Poll to Poll1, do a DROP TABLE on Poll, create > > a new table named Poll, do a syncdb transfer the data from Poll1 to > > Poll with a python fct. and DROP TABLE Poll1. > > Can't you simply use "ALTER TABLE ADD COLUMN" on the db?
Yes, that's the standard way. If you want to see what the column should be in the database, use "manage.py sql app_name", which will print out the necessary SQL on the screen. You then find the column you are adding and put the necessary "ALTER TABLE..." preamble in front of it. The precise syntax might vary depending upon the database server you are using. You will also need to add a default value for the column if it cannot be NULL, otherwise existing rows won't know what to put in that column and the database will return an error. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
