Issue 107 in django-evolution: dropping primary key constraint with uppercase characters fails
codesite...@google.com
Owner: ----
New issue 107 by jan.ostrochovsky: dropping primary key constraint with
uppercase characters fails
http://code.google.com/p/django-evolution/issues/detail?id=107
What steps will reproduce the problem?
1. add attribute with at least one uppercase character and unique=True;
evolve
2. remove unique=True; evolve
3.
What is the expected output?
Evolution successful.
What do you see instead?
Error applying evolution: constraint "core_businessunit_vat_id_key" does
not exist
What version of the product are you using? On what operating system? What
database backend?
Django 1.1, Django Evolution r166, Linux Ubuntu 9.04, PostgreSQL 8.3
Please provide any additional information below.
Evolution generates this SQL command:
ALTER TABLE "core_businessunit" DROP CONSTRAINT
core_businessunit_VAT_id_key;
and should be
ALTER TABLE "core_businessunit" DROP
CONSTRAINT "core_businessunit_VAT_id_key";
(double quotes should be added)
Reason: PostgreSQL converts names to lowercase, when not enclosed with
double quotes, but names are case sensitive.
--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings