Tagged Questions

PostgreSQL is an open-source, object-relational database management system (ORDBMS) available for many platforms including Linux, UNIX, MS Windows and Mac OS X. Please mention your PostgreSQL version when asking questions.

learn more… | top users | synonyms (3)

0
votes
1answer
13 views

handle crash of flask app on database restart

Currently have made a flask application which crashes when I do a postgres database restart, because the cursor which was opened is stale ... How do I handle this situation. Currently connecting the ...
0
votes
2answers
30 views

Why I can't install postgresql with rails 4.0.0.rc1 (ruby 2.0)

first time on forum so i will try to be as specific as one can be, sorry for any possible typos ok? I am relatively new to rails (less than a year), and i want to make a default project to work with ...
0
votes
0answers
7 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
0answers
35 views

finding the path to start postgres [migrated]

On my local machine, when I want to start the postgres server (postgres was installed via Homebrew), I do this pg_ctl -D /usr/local/var/postgres -l logfile start I just installed postgres on a ...
0
votes
2answers
32 views

Collaborating On Local Machines with Rails/Postgres

I'm working on a project with two other remote coders. I'm setting up most of the models/DBs. We're going to be working off of github, so I'll post my basic backend infrastructure, then they'll add ...
0
votes
1answer
23 views

Rails fails creating migration with NOW() default value to postgres

Common way I use it is psql > ALTER TABLE transactions ALTER COLUMN date SET DEFAULT CURRENT_TIMESTAMP\g it works fine. In my RoR app I've tried to create migrations in two ways. Tried to ways ...
0
votes
0answers
13 views

why back up and restore for table doesn't work in pgAdmin [closed]

Hello I've made thousands of back ups for a whole database and thenI was able to restore this backups in pgAdmin. But when i want to make a back up of only one table - (right click on the table -> ...
-6
votes
0answers
32 views

which is better according to memory performance regular tables or temp tables in postgresql [closed]

which is better for memory performance regular tables or temp tables in postgresql and mySQL? and I tried Table vs Temp Table Performance but I couldn't find the needed solution.
0
votes
1answer
24 views

Neo4j vs (Neo4j + Postgres)

I am developing an recommendation engine and was thinking of saving actual data (email, name, password, etc) in Postgres and saving relationship in Neo4j. But was wondering if this gives any advantage ...
0
votes
1answer
14 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 ...
1
vote
1answer
43 views

PostgreSQL query is slow when using NOT IN

I have a PostgreSQL function that returns a query result to pgadmin results grid REALLY FAST. Internally, this is a simple function that uses a dblink to connect to another database and does a query ...
0
votes
1answer
19 views

pqxx column names in multi table request

This question is specific to libpqxx. Given an SQL statement like the following: string s = "SELECT a.foo, b.bar FROM tableOne a, tableTwo b WHERE a.X=b.X" and sending it to a pqxx transaction: ...
1
vote
1answer
16 views

Function returns “query has no destination for result data”

I'm trying to create a function that will effectively function as an UPSERT and return either 0 for a successful UPDATE or the id of the new record for a successful INSERT. While the function will ...
1
vote
3answers
34 views

SQL: couple people who assisted to the same event

create table people( id_pers int, nom_pers char(25), d_nais date, d_mort date, primary key(id_pers) ); create table event( id_evn int, primary key(id_evn) ); create table assisted_to( ...
2
votes
1answer
19 views

PostgreSQL Locale Language

I'm running Debian 3.2 w/ PostgreSQL 9.2 installed. A co-worker of mine initialized the database cluster with japanese. So now, every single database created with createdb, no matter who the user is, ...

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