Tagged Questions

69
votes
9answers
32k views

DatabaseError: current transaction is aborted, commands ignored until end of transaction block

I got a lot of "DatabaseError: current transaction is aborted, commands ignored until end of transaction block" errors after changed from python-psycopg to python-psycopg2 as Django project's database ...
67
votes
2answers
4k views

How do you get PyPy, Django and PostgreSQL to work together?

What fork, or combination of packages should one to use to make PyPy, Django and PostgreSQL play nice together? I know that PyPy and Django play nice together, but I am less certain about PyPy and ...
44
votes
4answers
18k views

Django connection to PostgreSQL: “Peer authentication failed”

OperationalError at /admin/ FATAL: Peer authentication failed for user "myuser" This is the error I am receiving when I try to get to my Django admin site. I had been using MySQL database no ...
33
votes
9answers
8k views

MySQL vs PostgreSQL? Which should I choose for my Django project?

My Django project is going to be backed by a large database with several hundred thousand entries, and will need to support searching (I'll probably end up using djangosearch or a similar project.) ...
28
votes
5answers
11k views

Django+Postgres: “current transaction is aborted, commands ignored until end of transaction block”

I've started working on a Django/Postgres site. Sometimes I work in manage.py shell, and accidentally do some DB action that results in an error. Then I am unable to do any database action at all, ...
22
votes
1answer
3k views

Error Saving geodjango PointField

I have a geo model with a PointField property. Everything works perfectly locally, but when I try to save an instance on the server, I get the following error: django.db.utils.DatabaseError: invalid ...
22
votes
4answers
2k views

Migrating existing auth.User data to new Django 1.5 custom user model?

I'd prefer not to destroy all the users on my site. But I want to take advantage of Django 1.5's custom pluggable user model. Here's my new user model: class SiteUser(AbstractUser): site = ...
21
votes
4answers
3k views

Different db for testing in Django?

DATABASES = { # 'default': { # 'ENGINE': 'postgresql_psycopg2', # ... # } # for unit tests 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': ...
18
votes
1answer
1k views

Which Postgres value should I use in Django's DATABASE_ENGINE?

It's my first time using PostgreSQL 8.4.2 with Django(I have always used MySQL or sqlite3 in the past). Which value should I use for DATABASE_ENGINE in settings.py, postgresql_psycopg2 or postgresql? ...
15
votes
4answers
31k views

How to setup PostgreSQL Database in Django?

I'm new to Python and Django. I'm configuring a Django project using PostgreSQL database engine backend, But I'm getting errors on each database operations, for example when i run manage.py syncdb, ...
15
votes
7answers
11k views

Error: No module named psycopg2.extensions

I am trying to set up a PostgreSQL database for my django project, which I believe I have done now thanks to the replies to my last question Problems setting up a postgreSQL database for a django ...
14
votes
1answer
11k views

Use Django ORM as standalone [duplicate]

Possible Duplicates: Use only some parts of Django? Using only the DB part of Django I want to use the Django ORM as standalone. Despite an hour of searching Google, I'm still left with ...
14
votes
2answers
2k views

Data Mining in a Django/Postgres application

I need to build in a analytics (reporting, charting & graphing) system into my Django application. In an ideal world I could just query my Postgres DB and get the data I want but when the amount ...
12
votes
8answers
5k views

Choose test database?

I'm trying to run ./manage.py test But it tells me Got an error creating the test database: permission denied to create database Obviously it doesn't have permission to create the database, ...
12
votes
5answers
3k views

Unique model field in Django and case sensitivity (postgres)

Consider the following situation: - Suppose my app allows users to create the states / provinces in their country. Just for clarity, we are considering only ASCII characters here. In the US, a user ...

1 2 3 4 5 … 51
15 30 50 per page