Author: ubernostrum Date: 2007-12-01 11:44:59 -0600 (Sat, 01 Dec 2007) New Revision: 6794
Modified: django/trunk/docs/install.txt Log: Fixed #5776: Added an explanation of when and why Django might need ALTER TABLE privileges to docs/install.txt Modified: django/trunk/docs/install.txt =================================================================== --- django/trunk/docs/install.txt 2007-12-01 17:33:14 UTC (rev 6793) +++ django/trunk/docs/install.txt 2007-12-01 17:44:59 UTC (rev 6794) @@ -73,14 +73,18 @@ If you plan to use Django's ``manage.py syncdb`` command to automatically create database tables for your models, you'll need to -ensure that Django has permission to create tables in the database -you're using; if you plan to manually create the tables, you can -simply grant Django ``SELECT``, ``INSERT``, ``UPDATE`` and ``DELETE`` -permissions. Django does not issue ``ALTER TABLE`` statements, and so -will not require permission to do so. If you will be using Django's -`testing framework`_ with data fixtures, Django will need permission -to create a temporary test database. +ensure that Django has permission to create and alter tables in the +database you're using; if you plan to manually create the tables, you +can simply grant Django ``SELECT``, ``INSERT``, ``UPDATE`` and +``DELETE`` permissions. On some databases, Django will need to have +``ALTER TABLE`` privileges during ``syncdb`` (in order to create +foreign key constraints properly on databases which do not allow them +to be deferred), but will not issue ``ALTER TABLE`` statements on a +table once ``syncdb`` has finished setting it up. +If you will be using Django's `testing framework`_ with data fixtures, +Django will need permission to create a temporary test database. + .. _PostgreSQL: http://www.postgresql.org/ .. _MySQL: http://www.mysql.com/ .. _Django's ticket system: http://code.djangoproject.com/report/1 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django updates" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-updates?hl=en -~----------~----~----~----~------~----~------~--~---
