id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
6233	fixture fails to load on inet field	Michael P. Soulier <msoulier@…>	nobody	"Using the admin interface I entered a couple of records for my model. 

{{{
class TugInstance(models.Model):
    """"""This class represents a single instance of TUG in the multi-instance
    case.""""""

    enabled = models.BooleanField(default=False)
    public_ip = models.IPAddressField(unique=True)
    wan_ip = models.IPAddressField(unique=True, blank=True, null=True)
    lan_ip = models.IPAddressField(unique=True)
    ready_for_calls = models.BooleanField(default=True)
    calls_in_progress = models.PositiveIntegerField()
    default_icp = models.ForeignKey(Icp)

    def __str__(self):
        return str(self.id)

    class Admin:
        pass
}}}

I am using postgresql-7.4.13-2.RHEL4.1 on CentOS 4.4. 

I used the json serializer to dump json format of these records. 

{{{
[root@vmware-espresso teleworker]# cat sample_data.json
[{""pk"": ""1"", ""model"": ""top.tuginstance"", ""fields"": {""default_icp"": 1,
""wan_ip"": """", ""ready_for_calls"": true, ""lan_ip"": ""192.168.1.55"", ""enabled"":
true, ""public_ip"": ""216.191.234.111"", ""calls_in_progress"": 5}}, {""pk"": ""2"",
""model"": ""top.tuginstance"", ""fields"": {""default_icp"": 2, ""wan_ip"":
""216.191.234.112"", ""ready_for_calls"": true, ""lan_ip"": ""10.33.15.145"",
""enabled"": false, ""public_ip"": ""216.191.234.112"", ""calls_in_progress"": 0}}]
}}}

I then cleared the table manually, and tried to load this json as a fixture.

{{{
[root@vmware-espresso teleworker]# python manage.py --pythonpath=.. loaddata sample_data.json
Loading 'sample_data.json' fixtures...
Installing json fixture 'sample_data' from absolute path.
Problem installing fixture 'sample_data.json': invalid input syntax for type inet: """"
}}}

Seems that there are issues translating the json to sql that postgres will accept. "	Bug	closed	Core (Serialization)	0.96	Normal	duplicate			Accepted	0	0	0	0	0	0