Hello all,
By accident I have ended up with a mixed Django 1.1.1 and Django 1.2.1
environment, on different machines.
I am currently considering whether to downgrade the 1.2 installations, or
upgrade the older ones, or keep the current setup, but this depends on
finding a solution to an apparent incompatibility between 1.1 and 1.2, and
whether or not the upgrade can cause other problems.
The current applications, including the configuration of the Postgresql
8.3, have all been developed in v1.1.1
While this have not caused problems for one of my applications (AFAICT),
I've discovered that v1.2 is apparently not compatible with the ManyToMany
relations used in a second application, causing an exception to be thrown
when adding to the many to many field:
File "/usr/lib/pymodules/python2.5/django/db/models/fields/related.py",
line 490, in add
self._add_items(self.source_field_name, self.target_field_name, *objs)
File "/usr/lib/pymodules/python2.5/django/db/models/fields/related.py",
line 574, in _add_items
'%s_id' % target_field_name: obj_id,
File "/usr/lib/pymodules/python2.5/django/db/models/query.py", line 352,
in create
obj.save(force_insert=True, using=self.db)
File "/usr/lib/pymodules/python2.5/django/db/models/base.py", line 435,
in save
self.save_base(using=using, force_insert=force_insert,
force_update=force_update)
File "/usr/lib/pymodules/python2.5/django/db/models/base.py", line 528,
in save_base
result = manager._insert(values, return_id=update_pk, using=using)
File "/usr/lib/pymodules/python2.5/django/db/models/manager.py", line
195, in _insert
return insert_query(self.model, values, **kwargs)
File "/usr/lib/pymodules/python2.5/django/db/models/query.py", line
1479, in insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File "/usr/lib/pymodules/python2.5/django/db/models/sql/compiler.py",
line 789, in execute_sql
self.query.model._meta.db_table, self.query.model._meta.pk.column)
File
"/usr/lib/pymodules/python2.5/django/db/backends/postgresql/operations.py",
line 57, in last_insert_id
cursor.execute("SELECT CURRVAL('\"%s_%s_seq\"')" % (table_name,
pk_name))
File
"/usr/lib/pymodules/python2.5/django/db/backends/postgresql_psycopg2/base.py",
line 44, in execute
return self.cursor.execute(query, args)
django.db.utils.DatabaseError: relation "model_bar_foo_id_s" does not exist
A condensed example of my code (not tested independently) is the following:
class foo(models.Model):
#declarations
class bar(models.Model):
foo_list = models.ManyToManyField(foo, null=True)
def update_foo(x):
self.foo_list.add(x)
The call to "self.foo_list.add()" is what triggers the above exception.
AFAICT the SQL code generated by sqlall by v1.1.1 is equivalent to the
code generated by 1.2.1 (in v1.2.1 there is a use of ALTER in the
bar-reference of the many-to-many table). There is however no mention in
the sqlall output of an identifier with the name reported by the
exception, though it is possible that it may be an identifier generated
server-side, or that it would be generated in a resetdb situation.
I have not been able to discover any mention of such a problem in the v1.2
release notes.
While there will be no significant problem replacing this particular
application's set of tables after an upgrade, since the application is
currently not in production and I had just wiped the tables anyway, I am
concerned that there may be issues in the currently working application
that I have not yet discovered.
Is there a setting in v1.2 that I can use to tell the database handler
that the tables were generated by v1.1? Or is there another reason for
this problem?
For reference:
- the psycopg2 version on the 1.1 installation is 2.0.13 (windows and
Linux), the one on the 1.2 installation is 2.0.14 (linux)
- the names of the classes are much longer than used here (63 characters
for the id_s name).
- There are many more ManyToMany uses in the model used by this
application, including the class implicated in the exception.
--
Sincerely,
Yngve N. Pettersen
********************************************************************
Senior Developer Email: yn...@opera.com
Opera Software ASA http://www.opera.com/
Phone: +47 23 69 32 60 Fax: +47 23 69 24 01
********************************************************************
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
