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.
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 ...