Tagged Questions

0
votes
0answers
68 views

How to stop exception in open ERP 7 when setting up a hierarchy in the sales module?

I am using openERP V7 in ubuntu 12.04/ I have a manager M1 and under him 3 employees emp1, emp2 and emp3 in department d1 under sales and another manager M2, with under him emp4, emp5 and emp6 in ...
0
votes
0answers
35 views

Design for a calendar in postgreSQL?

Need to implement implement calendar application on postGreSQL. Some of the requirements : + several calendars (potentially big numbers) + each with a few recurring events + limited number of single ...
3
votes
1answer
67 views

How are import statements in plpython handled?

I have a plypython function which does some json magic. For this it obviously imports the json library. Is the import called on every call to the function? Are there any performance implication I ...
1
vote
1answer
71 views

Creating a continuous data set from irregular, dated rows

I have this table: Table "public.transaction" Column | Type | Modifiers ...
0
votes
0answers
83 views

Can't work python manage.py syncdb

When I run this command python manage.py syncdb, I got a list of errors : root@atul-ThinkPad-T42:~/Desktop/demo1# python manage.py syncdb Traceback (most recent call last): File "manage.py", line ...
1
vote
1answer
67 views

How to SELECT FOR SHARE using SQLAlchemy with PostgreSQL?

I am trying SELECT FOR SHARE a set of rows in a table so that they are locked until the end of the transaction. I am using SQLAlchemy 0.7.9 to do this in a PostgreSQL 9.1.6 database. This is the ...
4
votes
2answers
691 views

Efficient way to import a lot of csv files into PostgreSQL db

I see plenty of examples of importing a CSV into a PostgreSQL db, but what I need is an efficient way to import 500,000 CSV's into a single PostgreSQL db. Each CSV is a bit over 500KB (so grand total ...
1
vote
1answer
229 views

PostgreSQL ETL process on Heroku

I've been given the task of writing an ETL (Extract, Transform, Load) process between a PostgreSQL 9.1 database hosted on Heroku (we can call it the Master) to another, application-purposed copy of ...
0
votes
1answer
282 views

Django 1.4 + Apache WebServer + Mysql and PostgreSQL Connection Error

I have successfully followed the Django 1.4 Tutorial 1-4 (the poll system) and now its running until I deploy it in Apache Webserver 2.2 using Postgres Database. Everytime I access localhost I always ...
0
votes
2answers
58 views

Django error when converting OFTInteger to Decimal

I'm building a database with geo data in it using : PostgreSQL 9.1, Django 1.3.1, psycopg2 2.4.5 and using libraries GEOS 3.3.0, PostGIS 1.5.4 and ProJ 4.7.0. I have a command to load the shape files ...
0
votes
1answer
149 views

What do you think is the best approach for creating a data mapping layer in python?

I would appreciate hearing some opinions on the best approach to creating a light-weight data mapping layer between some python objects and a postgres database. I'm using the psycopg2 library, and ...
0
votes
0answers
317 views

Django 1.4 + Postgres 9.1 Integrity Error (sync works fine)

I'm having a problem here with my Django + PostgresSQL 9.1. When I make the sybcDB all the tables are created successfully, although, when I try to use them on my application it all goes wrong and my ...
2
votes
1answer
248 views

psycopg2 out of shared memory and hints of increase max_pred_locks_per_transaction

While inserting a lot of data into postgresql 9.1. using a Python script, we are getting the following error on this query: X: psycopg2.ProgrammingError in /home/hosting/apps/X X_psycopg.py:162 in : ...
0
votes
2answers
307 views

Importing postgres data to mysql

I have a requirement where I need to insert the postgres data into mysql. Suppose I have user table in postgres. I have user table also in mysql. I tried to do something like this: gts = 'cd ...
1
vote
2answers
1k views

setting up Postgresql 9.1 database in Django for ubuntu 11.10

I am trying to configure Postgresql 9.1 in Django 1.3 . Note: I am doing this in Ubuntu 11.10 (oneric). Also I have postgis 1.5 installed to work with Postgresql 9.1 To my best knowledge, I have ...

1 2
15 30 50 per page