Re: Problem loading integer data into database using fixture

2012-02-17 Thread Bill Freeman
Also, see pg_hba.conf in the postgres documentation. There can be rules as to who can connect at all, let alone who needs a password. On 2/17/12, Sebastian Goll wrote: > On Thu, 16 Feb 2012 22:18:03 -0800 (PST) > Gchorn wrote: > >> Unfortunately, that doesn't seem to be the case. I have the d

Re: Problem loading integer data into database using fixture

2012-02-17 Thread Sebastian Goll
On Thu, 16 Feb 2012 22:18:03 -0800 (PST) Gchorn wrote: > Unfortunately, that doesn't seem to be the case. I have the database > user and password in my settings.py file, but I still have to do a > "sudo su postgres" to switch to postgres in the terminal before I can > access my PostgreSQL databa

Re: Problem loading integer data into database using fixture

2012-02-17 Thread Gchorn
I figured it out the answer to my original question. One of the fields was a ForeignKey field and I was just giving it the string representation of the foreignkey object, rather than its primary key (which is an integer and not a string). Thanks for the help though, Bill! cheers, Guillaume On F

Re: Problem loading integer data into database using fixture

2012-02-16 Thread Gchorn
Unfortunately, that doesn't seem to be the case. I have the database user and password in my settings.py file, but I still have to do a "sudo su postgres" to switch to postgres in the terminal before I can access my PostgreSQL database through the Django database API. Otherwise when I try to acces

Re: Problem loading integer data into database using fixture

2012-02-16 Thread Bill Freeman
The database user and *nix user are (typically) unrelated. The database user is specified in settings.py and there is also a password if necessary. Since one usually communicates with database servers using network connections (even on the same box), it doesn't really know what user a connection

Re: Problem loading integer data into database using fixture

2012-02-16 Thread Gchorn
Thanks very much for the reply. I went ahead and created a model instance using the API, and then tried to get a yaml dump of this. However, I'm running into another (newb) problem. The database I'm using is under a different username (I'm doing all of this in Ubuntu Linux 11.10), which I underst

Re: Problem loading integer data into database using fixture

2012-02-16 Thread Bill Freeman
Well, I don't know yaml, but if you are in a place where you don't have to quote: Arron then I'd expect everything to be strings. Is there a yaml.dump that you can apply to a model with strings and integers to see how it thinks they are distinguished? On 2/16/12, Gchorn wrote: > Hello All,