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
0answers
19 views

Easy way of re-indexing my table

Good Day, I'm currently using posgresql as my backend and I have to make huge changes on my table fields. I will be using two tables. Table 1 Table 2 Old Index New Index Product Id ...
0
votes
1answer
10 views

Wrong path to a Pomm map file

I'm building a website with Symfony2 and PostgreSQL (for the first time). I've recently discovered the database layer called Pomm, I decided to use it instead of Doctrine2. However I get a Fatal ...
0
votes
1answer
25 views

Postgresql recursive self join

My table in postgres looks like below, Table stores a chain sort of relation between IDs and I want to have a query which can produce the result like "vc1" -> "rc7" or "vc3"->"rc7", I will only query ...
0
votes
0answers
7 views

How to sum the values of specific key in rails, postgres, store

How do I sum all the values that have a matching key? For example, I have a flight and duty log where users store times they have flown or worked. I am storing these k/v pairs using hstore. One duty ...
0
votes
1answer
7 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
29 views

Fill zeros for missing values in range

I'd like to list a set of numbers within a range with their respective counts, but include a zero where the value does not appear a table row. For example, create table score ( n int ); insert ...
1
vote
2answers
25 views

Query Plan of postgres with indexes

I have a postgres table having the following schema Table "public.myTable" Column | Type | Modifiers ----------- ...
0
votes
3answers
49 views

Subquery for fetching table name

I have a query like this : SELECT * FROM (SELECT linktable FROM adm_linkedfields WHERE name = 'company') as cbo WHERE group='BEST' Basically, the table name for the main query is fetched through ...
1
vote
1answer
11 views

Cannot get Postgres.app connection

I'm using Mountain Lion and want to switch my rails app from SQLIte to Postgres so I can deploy on Heroku. I have installed Postgres.app and it's working fine if I open it with the path suggested: ...
0
votes
1answer
11 views

DateTime is not being saved when TImeZone is set in application.rb

I ran across an issue today, that leaves me a bit confused. Whenever I try to save a DateTime to the Database, it seems to work - but as soon as I try to retrive it again, I'm getting back nil. This ...
0
votes
0answers
8 views

Configuration in Deploying MediaGoblin

I'm trying to deploy mediagoblin on ubuntu in this website, http://mediagoblin.org/ , and following the guide in this page, http://docs.mediagoblin.org/siteadmin/deploying.html . What I don't ...
0
votes
0answers
16 views

Rails named scope for left joined model

I have a table named acts, and I'll like to run a query that rolls up act values for a whole week. I'd like to make sure the query always returns one row for each day of the week, even if there are no ...
0
votes
0answers
6 views

Is there a complete example/tutorial (or at least an alternative to wxODBC) for CodeBlocks + Postgres

I am just starting to program Code::Blocks with Postgres. I haven't tried any other DB platform either with it. So far I've found that DB connections and coding can be done using wxODBC. wxWidgets is ...
0
votes
1answer
13 views

Finding records based on no returned records from a related table

Dealing with two tables in Postgres: Members and Memberships. Memberships have an end_date column that can be NULL if the membership is still running. As soon as it has ended, or the end date is known ...
0
votes
0answers
15 views

Discourse won't restart after a server reboot. [migrated]

I had an instance of Discourse up and running on my Virtual Private Server. I'm configuring the application and all of a sudden mails stop working. In attempt to get mail working I get the bright ...

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