2.10.2012 14:06, George Silva kirjoitti:
This is puzzling. I'm on 1.4.1 and I have models with two geometric
columns, without a hitch.

The only interesting thing I can see is that you are using SRID =
settings.4326 on extent. Is that correct?

Nope. Normally it's something totally different depending on customer (and picked from settings file). I just tried qicly replace it by more common WGS84...

Maybe it's Oracle spesific or are you using Oracle as well?

On Tue, Oct 2, 2012 at 7:52 AM, Jani Tiainen <rede...@gmail.com
<mailto:rede...@gmail.com>> wrote:

    Hi,

    I've several models that contains two geometry fields (following is
    simplified example):

    class NetDiagram(models.Model):
         # Columns
         name = models.CharField(max_length=__60, blank=True, null=True)

         location = models.GeometryField(_("__Center"),
    db_column='location', srid=4326, null=True, blank=True)
         extent = models.GeometryField(_("__Extent"),
    db_column='extent', srid=settings.4326, null=True, blank=True)

         objects = models.GeoManager()


    Now when trying to save model like that I get:

    Traceback (most recent call last):
       File
    
"c:\users\jtiai\work\keycom-__dev-std\prj\keycom\keycom_net___diagram\diagram\entity___diagram_builder.py",
    line 134, in _save_to_database
         netdiagram.save()
       File
    
"C:\Users\jtiai\Work\keycom-__dev-std\lib\site-packages\__django\db\models\base.py",
    line 463, in save
         self.save_base(using=using, force_insert=force_insert,
    force_update=force_update)
       File
    
"C:\Users\jtiai\Work\keycom-__dev-std\lib\site-packages\__django\db\models\base.py",
    line 551, in save_base
         result = manager._insert([self], fields=fields,
    return_id=update_pk, using=using, raw=raw)
       File
    
"C:\Users\jtiai\Work\keycom-__dev-std\lib\site-packages\__django\db\models\manager.py",
    line 203, in _insert
         return insert_query(self.model, objs, fields, **kwargs)
       File
    
"C:\Users\jtiai\Work\keycom-__dev-std\lib\site-packages\__django\db\models\query.py",
    line 1576, in insert_query
         return query.get_compiler(using=__using).execute_sql(return_id)
       File
    
"C:\Users\jtiai\Work\keycom-__dev-std\lib\site-packages\__django\db\models\sql\compiler.__py",
    line 909, in execute_sql
         for sql, params in self.as_sql():
       File
    
"C:\Users\jtiai\Work\keycom-__dev-std\lib\site-packages\__django\db\models\sql\compiler.__py",
    line 886, in as_sql
         for val in values
       File
    
"C:\Users\jtiai\Work\keycom-__dev-std\lib\site-packages\__django\contrib\gis\db\__backends\oracle\compiler.py",
    line 25, in placeholder
         param_idx = self.query.columns.index(__field.column)
    AttributeError: 'InsertQuery' object has no attribute 'columns'


    Error is consistent and happens when there is two or more geometry
    fields on a single model.

    Same code worked on 1.3 flawlessly.

    --
    Jani Tiainen

    - Well planned is half done and a half done has been sufficient
    before...

    --
    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
    <mailto:django-users@googlegroups.com>.
    To unsubscribe from this group, send email to
    django-users+unsubscribe@__googlegroups.com
    <mailto:django-users%2bunsubscr...@googlegroups.com>.
    For more options, visit this group at
    http://groups.google.com/__group/django-users?hl=en
    <http://groups.google.com/group/django-users?hl=en>.




--
George R. C. Silva

Desenvolvimento em GIS
http://geoprocessamento.net
http://blog.geoprocessamento.net

--
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
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.


--
Jani Tiainen

- Well planned is half done and a half done has been sufficient before...

--
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 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to