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
10 views

How to create this file “/var/run/postgresql/.s.PGSQL.5432”?

By mistake, I deleted the .s.PGSQL.5432 file in folder /var/run/postgresql because of that , I cant able to add server in pgAdmin , Instead i am getting error like below An error has occurred: ...
2
votes
4answers
49 views

Dynamic input to database

I'm working on an app that lets a user create projects custom to the users needs, the project is basically a form that can be submitted by another user. I want to allow the user to dynamically create ...
0
votes
0answers
16 views

Bulk Insert from Select PostgreSQL

Fastest way to do insert in a table Aexample with same structure of a table Bexample: INSERT INTO Aexample SELECT * FROM Bexample I can't rename table because in table Aexample there are indexes ...
0
votes
1answer
13 views

setseed() and random() behaviour

Why this returns different random numbers in every column? I thought that I will get always the same random numbers if I use setseed(). But it looks like there is new constant vector of random numbers ...
0
votes
0answers
8 views

CakePHP SELECT CASE WHEN - Not Working

I've tried to follow the instructions in these pages: https://groups.google.com/forum/?fromgroups#!topic/cake-php/rUXgKrCbKMo Cakephp CASE WHEN argument in find conditions In order to get my query, ...
1
vote
2answers
14 views

Querying by range in your B-tree index's leading edge, PostgreSQL

If you query for a range of dates and another thing, is having the date column as a leading edge in your index a bad thing? I'm using PostgreSQL, but assume this applies to all B-tree indexes. Let's ...
0
votes
1answer
20 views

PostgreSQL Stock Update Trigger

I have 2 tables in PostgreSQL: lines(idlines,iditems,quantity) and items(iditems,stock). iditems is a foreign key in lines. I need a trigger that updates the stock field from the items table when a ...
1
vote
0answers
23 views

Large array in database won't load in rails view

I am trying to pull in data from an array into a view to form a chart. The array is stored in a database field and is very large. The array contains around 70k+ smaller arrays that look like this, ...
0
votes
0answers
6 views

PREPARE TRANSACTION releasing locks?

I must be missing something about PostgreSQL and two pahse commit with PREPARE TRANSACTION. The following SQL : BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; UPDATE acperson.tcities set ...
1
vote
2answers
17 views

Postgres update with previous row

I have a table that records values from electrical meters The table looks like this SELECT created_at, value, delta FROM metervalues ORDER BY created_at 2013-05-28 07:59:00 | 752105,6 | null ...
0
votes
1answer
19 views

How to use AND operator in statement

I am using JDBC in JSP with PostGreSQL. I want to read all values of a row with the given titel and interpret from a text field but the AND operator doesn't work. // some code stmt = ...
1
vote
1answer
16 views

Issues with NpgsqlDatareader when trying to integrate Vb.net with PostgreSQL database

So I am fairly new (read just starting) to PostgreSQL and VB.net. I have done research and am using the Npgsql.dll and Mono.Security.Protocol.Tls.dll as references to connect to the database. ...
-1
votes
0answers
16 views

Uninstalling Request Tracker 4.0.13 [closed]

I'm currently running Request Tracker with a CentOS Linux distro and need to uninstall the software. I'm new to linux system administration and could not find documentation to uninstall Request ...
1
vote
2answers
22 views

Adding a multi-column primary key to a table with 40 million records

I'm working on maintaining a database which stores data transfer information between different networks. Essentially, each data transfer is logged and at the end of each month I run a perl script that ...
2
votes
1answer
16 views

Array aggregation for all columns in a table in Postgres

WITH Dept(DName, HeadCount) AS ( VALUES ('D1', 5), ('D2', 6), ('D3', 7) ) Select array_agg(DName), array_agg(HeadCount) from Dept The above query will yield. "{D1,D2,D3}";"{5,6,7}" Is there ...

1 2 3 4 5 1169
15 30 50 per page