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
0answers
2 views
Creating Users in PostGres
I am having trouble getting my head around setting up users in PostGres (with PostGIS extension) - well in all honesty I;ve been banging my head against a wall on this for the past week. I am ...
0
votes
0answers
13 views
Update lower/upper bound of range type
I have column of tstzrange type (timestamp with time zone range) and I need to update only upper or lower bound of this value (and keep inclusive/exclusive boundaries)
I managed to change
...
0
votes
1answer
8 views
unrecognized configuration parameter “custom_variable_classes”
I get this message after a system update:
unrecognized configuration parameter "custom_variable_classes" in file "/var/lib/pgsql/data/postgresql.conf" line 501
Are custom variable classes not ...
1
vote
0answers
10 views
Can't immediately receive multiple notifications in Npgsql
Today i wrote the following code that works with PostgreSQL C# library named Npgsql:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ...
0
votes
0answers
12 views
Exception in PostgreSQL function not catched in Java Hibernate
I am using the following PostgreSQL function to delete a record from a table in the DB.
CREATE OR REPLACE FUNCTION deletesegment(segid bigint) RETURNS integer AS
$BODY$
DECLARE
...
0
votes
1answer
16 views
Hibernate : Failed to create sessionFactory object.org.hibernate.InvalidMappingException
I am sorry if this is a duplicate of any existing question. Following is my employee bean.
public class Employee {
private int id;
private String firstName;
private String ...
0
votes
1answer
14 views
Convert PG_query to PDO statement
I'm a bit lost with this statement. I am trying to convert this PG_query script into PDO. The Idea is that I can then use this example, to pull other values from the database and display in a form.I ...
0
votes
1answer
22 views
Postgres : No suitable Driver found for jdbc
I know this might be a possible duplicate of question posted here. Sorry for that.Here is the code i wrote for Database connection
try{
Class.forName("org.postgresql.Driver");
...
0
votes
0answers
32 views
Rails Mysql to Postgresql Float
I'm transferring my database from mysql to postgresql.
I have a latitude and longitude column for one of my models:
t.float :latitude
t.float :longitude
I'm using mysql2psql gem to load the ...
0
votes
0answers
24 views
PostgreSQL large single transaction slower than multiple transaction
On Postgres, I recently saw a case where there was a huge amount of selects being handled in a single transaction. This was really slow, so the solution was to break the selects into multiple ...
0
votes
0answers
23 views
Do prepared statements persist between requests?
If I want to execute the same query on two different requests, and I use prepared statements with Doctrine2... Will the prepared statement be sent only the first time and be stored by the database for ...
0
votes
1answer
22 views
PostgresSQL rank query
I have data in postgreSQL table as follows,
pkid id timestamp isactive
-----------------------------------------
1 1 "2013-08-08 10:10:10" 0
2 1 "2013-08-08 10:11:10" 0
...
1
vote
0answers
19 views
Why does autovacuum: VACUUM ANALYZE (to prevent wraparound) run?
I have an autovacuum VACUUM ANALYZE query running on a table, and it always takes many hours, even a couple of days to finish. I know Postgres runs autovacuum jobs occasionally to perform cleanup and ...
-1
votes
0answers
10 views
PostgreSQL 8.0 - Windows Server 2008 R2 install - Service won't start
I am trying to install postgreSQL 8.0 on a windows server 2008 R2 machine. After the installation, the service does not start. When I try to start it manually, I get a message saying that the service ...
2
votes
1answer
12 views
Running pg_dump while insert queries are still running?
If I run pg_dump to dump a table into a SQL file, does it take a snapshot of the last row in the table, and dump all the rows up to this row?
Or does it keep dumping all the rows, even those that ...
Related Tags
sql × 4942ruby-on-rails × 1833
database × 1716
php × 993
mysql × 925
java × 913
python × 879
django × 755
heroku × 719plpgsql × 696
ruby-on-rails-3 × 651
postgresql-9.1 × 505
ruby × 488
hibernate × 471
postgis × 427
activerecord × 409
jdbc × 364
performance × 354
database-design × 292
triggers × 285
postgresql-9.2 × 261
stored-procedures × 250
c# × 242
psycopg2 × 242
arrays × 226
