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

Apache Felix not able to access Postgres JDBC

I downloaded Postgresql-9.2-1003.jdbc3.jar and put it in felix\bundle directory. My program accesses Postgres table EMP and prints it. I am trying to do it in Felix OSGi server. There are two parts ...
1
vote
1answer
15 views

Slow Hibernate/C3P0 handling of non-slow Postgres SELECT

A certain indexed SELECT query against a Postgres database takes a highly variable amount of time - from 50 msecs to multiple seconds, and very occasionally minutes, even under the lightest load. Our ...
0
votes
3answers
27 views

How to insert many records excluding some on Postrgesql

I want to create a table with a subset of records from a master table. for example, i have: id name code ref 1 peter 73 2.5 2 carl 84 3.6 3 jack 73 1.1 I want to store peter ...
0
votes
1answer
13 views

find set of values that have max occurrence in column in postgresql

Print the name(s) and sid(s) of the student(s) enrolled in the most classes Enroll sid class number 1 23 2 54 1 54 3 43 1 43 2 43 student sid sname 1 sagar ...
3
votes
1answer
38 views

SQL: Select a list of numbers from “nothing”

What is a fast/readable way to SELECT a relation from "nothing" that contains a list of numbers. I want to define which numbers by setting a start and end value. I am using Postgres SQL and SQLite, ...
2
votes
0answers
16 views

Convert Postgresql query to Rails

I'm new in programming but here's the thing: I'm trying to make rails app which takes data from postgresql database and shows summary in jqPlot chart, but I am having trouble with my queries. For the ...
3
votes
0answers
16 views

Proper way to organize diagnostic tests in Java EE

I am working on a Spring-based web-application that uses several components, including PostgreSQL, raw filesystem and more.. I want to make a small admin-page, where an admin will be able to test, if ...
0
votes
1answer
32 views

MySQL - SELECT DISTINCT ON

I've been using PostgreSQL and now migrating to mySQL. In my queries, I'm using PostgreSQL's SELECT DISTINCT ON (col1,col2,col3). I was wondering if there is any counterpart of this statement in ...
0
votes
1answer
25 views

Date is coming differently in local and live environments in Postgres

I have date like "9999-12-30 18:30:00+00" in database. When i am accessing from local machine it is coming as 9999-12-31 00:00:00.0(In India) When i am accessing from live it is coming as 9999-12-30 ...
0
votes
0answers
10 views

Jetty authentication JDBC

I'm using jetty with BASIC authentication and I need to authenticate my client in my unit tests but I got this : WARN: AUTH FAILURE: user admin Failed : HTTP error code : 401 I don't understand ...
1
vote
3answers
29 views

PostgreSQL: SELECT integers as DATE or TIMESTAMP

I have a table where I have multiple integer columns: year, month and day. Unfortunately, while the three should have been grouped into one DATE column from the beginning, I am now stuck and now need ...
0
votes
0answers
15 views

“Could not create IPv6 socket” postgresql standby error [on hold]

I'm trying to create Postgresql hot-standby using following steps: Configured 2 virtual linux machines. Master's ip: 10.10.10.1, Standby's ip: 10.10.10.2. Ping test passed. Restored the same db ...
0
votes
1answer
33 views

Postgresql command execution in bash script

I have written a shell script to execute postgresql commands . Problem is when I am executing this script it is showing an error : line 17: psql: command not found my script is as follows: export ...
0
votes
0answers
14 views

Returned type character varying(70)[] does not match expected type

I need help to review following query, I have table as follow : CREATE TABLE "MasterDivision" ( "DivisionID" bigserial NOT NULL, "DivisionName_EN" character varying(70) NOT NULL, ...
0
votes
0answers
21 views

SQL EXISTS in Search Query - Postgres

I have a complex query where I'm passing a variety of different values into using the EXISTS subquery expression to generate search results . i.e. // This is Postgres 9.2 btw // First Schema CREATE ...

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