Tagged Questions
4
votes
1answer
3k views
Error: No module named psycopg2.extensions django postgresql
I want to Use PostgreSQl With Django . I referred this tutorial to install it and when I run this command
python manage.py syncdb
I get the following errors
Traceback (most recent call last):
...
3
votes
1answer
585 views
Django creates the test database for Postgresql with incorrect sequences start values
Using pyscopg2, as Django database default backend, and with very simple case for a test. It fails trying to create a user, with a IntegrityError exception
$ python manage.py test project.core.tests
...
3
votes
1answer
384 views
Avoid RETURN postgresql statment in django1.4 and postgresql 8.1 related to bug #10467
A few days ago I write a project in django1.4 using the admin capabilities with the intention to make a CRUD for debug data migrated from a legacy system to a new system (the migration wasn't entirely ...
1
vote
1answer
4k views
Postgres is ruining my life [closed]
Ive actually had this problem for a while but I've finally decided to take it on. Postgres was initially installed using Brew.
After my upgrade to OSX 10.8.2 to receive a
psql: could not connect to ...
1
vote
2answers
364 views
Point manage.py to a specific PostegreSQL schema
How can I tell manage.py to operate in a specific PostgreSQL schema?
My database is separated into multiple schema, one per client/deployment, to keep data separate.
However, it seems that Django ...
1
vote
2answers
64 views
order_by on Many-to-Many field results in duplicate entries in queryset
I am attempting to perform an order_by based a m2m field, but it ends up creating duplicate entries in my queryset. I have been searching through the django documentation and related questions on ...
1
vote
1answer
459 views
Django saving form strings in database with extra characters (u'string')
I've been having problems in django while trying to save the form.cleaned_data in a postgres database.
user_instance.first_name = form.cleaned_data['first_name']
the data is being saved this way ...
0
votes
0answers
13 views
Postgresql date_trunc called in custom function through Django's connection.cursor()
I created a custom Postgresql function that performs some calculations and determines the beginning of a month by using the date_trunc function. When developing the custom function, I checked it from ...
0
votes
1answer
148 views
Optimization of bulk update/insert
I'm writing a web application that is going to show player statistics for an online game, using Django 1.6 and PostgreSQL 9.1. I've created a script using django-extensions "runscript" which fetches ...
-1
votes
0answers
52 views
large performance difference when update
There is a large performance difference when I try to update data.
At first, I used the following query:
UPDATE klass SET value="data" WHERE klass.id=1234567;
It took 3.5s to execute.
...
