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
1answer
8 views

Hibernate executeUpdate() on PostgreSQL function

I am using hibernate with a function in PostgreSQL to update a record in the DB. Following is the PostgreSQL function, CREATE OR REPLACE FUNCTION updatesegment(segid bigint, segname text, ...
0
votes
0answers
2 views

How to set superaccount when installing postgres 9.2 as extract-only

I am trying to install postgres enterprise db on windows. I give an option file with parameters for installation. But instead of installing as a windows application, I want to just extract the ...
0
votes
1answer
14 views

Saving timestamps in Postgres based on Java dates

I have a Postgres database with a table that contains a timestamp (timeOfProcessing TIMESTAMP). I have a Java datetime value (java.util.Date dateTime) and want to store its value in that ...
0
votes
3answers
44 views

Gradually migrate from SQL Server to PostgreSQL

Company has numerous applications running on SQL Server. The database is a bit of a mess. The goal is to gradually move from SQL Server to PostgreSQL (another SQL Server instance is not an option) ...
0
votes
2answers
36 views

Ruby on Rails: Duplicates with Join

I am working on part of an app that will sort a list of children based on their parent's other children's attributes. Here are the classes I'm working with: class SpecialChild belongs_to: Parent ...
0
votes
0answers
6 views

How to take backup of PostgreSQL database on my Ubuntu server ?

I want to do two things - I have PostgreSQL database on my Ubuntu server (hosted on RackSpace), how to download the database on my local ubuntu system ? How to automate this process on daily basis ...
0
votes
1answer
17 views

Django ORM delete

Ok so i have 2 models simplified Class A: name = charfield Class B: name = charfield linked = foreignkey(A) My question how I can delete A.name and B.linked but protecting B.name ...
0
votes
1answer
10 views

Tsquery return exact matched keyword

I have a query like select * from mytable where posttext @@ to_tsquery('Intelence'); I just want to return results with exact match of the keyword 'Intelence' rather than 'intel', how can I do ...
0
votes
1answer
26 views

ERROR: operator does not exist: integer = character varying, using Postgres 8.2

I have a Java EE web application developed in an old version of Eclipse (Ganymede if I remember correctly). I recently migrated to Kubuntu 12.04 LTS and migrated the application to Eclipse Kepler ...
1
vote
2answers
29 views

SQL insert into AND update

Is it possible in PostgreSQL to update a table and insert data into another table at the same time. Like UPDATE table1 SET column4=true AND INSERT into table2 SELECT column1, column2, column3 FROM ...
1
vote
2answers
41 views

How to get the Index column order(ASC, DESC, NULLS FIRST…) from Postgresql?

I have to retrieve the order of the columns involved in the index. Using the function pg_get_indexdef() I could get the definition of the index as shown below, "CREATE INDEX test ON ...
2
votes
1answer
40 views

How to get database size accurately in postgresql?

We are running on PostgreSQL version 9.1, previously we had over 1Billion rows in one table and has been deleted. However, it looks like the \l+ command still reports inaccurately about the actual ...
0
votes
1answer
15 views

Postgresql full text search tokenizer

Just run into an issue. I'm trying to set up full text search on localized content (Russian in particular). The problem is default configuration (as well as my custom) does not deal with letter cases. ...
25
votes
11answers
4k views

Error when pushing data to Heroku: time zone displacement out of range

I run the following command to push the contents of my local database to Heroku: heroku db:push --app my-app From my home computer this works flawlessly but from my work computer I get this error: ...
5
votes
2answers
142 views

Postgresql with postGIS and entity framework, CHECK constraint issue

I have a postgresql database with postGIS and I'm using entity framework with dotconnect 6.7 for postgreSQL. With the following table in my database: CREATE TABLE geo ( the_geom geometry, id ...

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