Tagged Questions

0
votes
0answers
4 views

Field default timestamp set to table creation time instead of row creation time

Using SQLAlchemy, alembic and postgres, when trying to set a column to the row creation time what I finally get is a field that defaults to the time when the table itself was created, instead of the ...
0
votes
1answer
8 views

Execute .sql schema in psycopg2 in Python

I have a PostgreSQL schema stored in .sql file. It looks something like: CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY, facebook_id TEXT NOT NULL, name TEXT NOT NULL, ...
0
votes
1answer
16 views

How do SQLAlchemy Connections relate to Session-based transactions?

I am currently working on a new web application that needs to execute an SQL statement before giving a session to the application itself. In detail: I am running a PostgreSQL database server with ...
0
votes
1answer
33 views

Mac OSX Lion Postgres does not accept connections on /tmp/.s.PGSQL.5432

I'm getting a common Mac OSX error for Homebrew installations of Postgres, No such file or directory Is the server running locally and accepting connections on Unix domain socket ...
1
vote
2answers
31 views

logging values from arduino to postgres db

I have a temperature sensor ([LM35][1]) interfaced with an Arduino board and my [sketch][2] is able to log values to the serial port, say /dev/ttyACM0 in Ubuntu, and I was able to install pySerial and ...
0
votes
1answer
12 views

Can copy_to query by using binding arguments?

>>> cur.copy_to(sys.stdout, 'test', sep="|") 1|100|abc'def 2|\N|dada ... I review the document of psycopg2 , I want to use copy_to function to select large data, But I could not find the way using ...
1
vote
1answer
36 views

psycopg2 leaking memory after large query

I'm running a large query in a python script against my postgres database using psycopg2 (I upgraded to version 2.5). After the query is finished, I close the cursor and connection, and even run gc, ...
0
votes
2answers
25 views

Iteratively insert rows into a postgreSQL database using SQLAlchemy in python

I am writing a script that reads data from excel files and writes into a postgresql database. I have read data from the excel file and stored each row data as an array of strings. I tried a couple ...
0
votes
1answer
22 views

txpostgres return last insert from a stored procedure

I am using TxPostgres for insert a row into a postgresql, my stored procedure is CREATE OR REPLACE FUNCTION gps_open_connection( _ip character varying(15), _port integer ) RETURNS integer AS ...
1
vote
1answer
16 views

Can Alembic Autogenerate column alterations?

I was able to use alembic --autogenerate for when adding / removing columns. However, when I wanted to modify for example a "url" column from 200 characters to 2000 characters, it doesn't detect the ...
1
vote
1answer
29 views

psycopg2 equivalent to R dbWriteTable command and getting more performance from python code

I just did a time test on loading a data array from a csv, creating a database on Postgres and writing the table to it in python and R. I was surprised that the times were very similar: The python ...
0
votes
1answer
29 views

Python psycopg2 postgres select columns including field names

Hi I'd like to get a table from a database, but include the field names so I can use them from column headings in e.g. Pandas where I don't necessarily know all the field names in advance so if my ...
1
vote
0answers
20 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
1answer
62 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 ...

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