Tagged Questions

62
votes
9answers
29k 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 ...
1
vote
0answers
9 views

“No handler found” while loading OpenERP 7 on localhost

I have been working on a custom module of OpenERP 7 on localhost:8069, but today when I try to load the OpenERP7 on localhost it is giving me the error "no handler found". I dont' understand the ...
-1
votes
0answers
15 views

Installing skytools on RH4 linux [closed]

I am trying to install skytools on linux The error I receive during make/make clean is: make: execvp: /usr/local/src/skytools-3.1.3/python/: Permission denied I have configured the installation ...
1
vote
2answers
45 views

web2py webserver - Best way to keep connection to external SQL server?

I have a simple web2py server that we use to visualize data from our PostgreSQL Server. The following functions are all part of the global models in web2py. The current solution to fetch data is very ...
1
vote
1answer
38 views

Can Redis write out to a database like PostgreSQL?

I've been using PostgreSQL for the longest time. All of my data lives inside Postgres. I've recently looked into redis and it has a lot of powerful features that would otherwise take a couple of lines ...
3
votes
3answers
249 views

Python psycopg2 - Logging events

I'm using psycopg2, and I have a problem with logging events(executed queries, notifications, errors) to a file. I want to get effect like in PgAdmin history window. For example I'm executing this ...
1
vote
1answer
54 views

Postgresql: Query 10x slower in a different client

Looking at the postgres server log, I see that the exact same query on the same postgres server takes much longer (about 10x longer) when invoked from a Linux client or from a Windows client. The ...
0
votes
0answers
13 views

Web2py - Key/constraint issue when using separate SQL database for archiving

In a web2py application, I've got a primary postgresql database (db1), and I've set up a separate postgresql database (db1_archive) used for archiving several of the tables from db1. This ...
0
votes
1answer
37 views

Postgresql performance and Django

My question is something in general as I am looking for a suggestion on the best way to work with a query on PostgreSQL with the characteristics: Interval from client side of 5 seconds More than ...
1
vote
1answer
40 views

Remove module install queue from OpenErp

I was installing a custom module that requires the decimal_precision module, however, this module has been updated, so i downloaded and installed the brand new from apps.openerp.com Now is giving me ...
0
votes
1answer
39 views

(OpenERP 6.0.4) KeyError: 'id' When calling osv_memory wizard

I'm having a little problem in OpenERP 6.0.4, I want to call a wizard using python function, but it keeps giving me this error : Environment Information : System : Windows-Vista-6.1.7601-SP1 ...
0
votes
1answer
37 views

Combining PostgreSQL Enum with a TypeDecorator

Is there a way to have an Enum class that will both get created automatically when creating a new DB, like the standard Enum, but also connect it to a TypeDecorator that runs process_bind_param? This ...
0
votes
1answer
31 views

sqlalchemy multiple foreign keys to same table

I have a postgres database that looks something like this: Table "public.entities" Column | Type | Modifiers ...
20
votes
6answers
17k views

Postgres: INSERT if does not exist already

I'm using Python to write to a postgres database: sql_string = "INSERT INTO hundred (name,name_slug,status) VALUES (" sql_string += hundred + ", '" + hundred_slug + "', " + status + ");" ...
1
vote
1answer
36 views

can't publish page on django-cms due to “IntegrityError: duplicate key value violates unique constraint”

In my django-cms website I am having some trouble when publishing pages via admin interface. Below the stacktrace: DEBUG 2013-06-07 14:09:31,562 util 32222 140056576640768 (0.000) SELECT DISTINCT ...

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