Stack Overflow
Stack Overflow

Questions tagged [postgresql-9.1]

for PostgreSQL questions specific to version 9.1.

PostgreSQL 9.1 is the version of PostgreSQL released in September of 2011, with expected end-of-life in September of 2016.

While the generic tag should probably be used with all PostgreSQL-related questions, this tag should also be used if the question pertains to features added in version 9.1, or if the question is about a problem seen while running version 9.1.

1821 questions
0
votes
1 answer

delete rows from a table that are not present in another

I have two tables table1- --- file_id ,est_edit_id,cal_head_code,cal_spec_code,cal_item_head_code table 2-- file_id ,est_edit_id,cal_head_code,cal_spec_code,cal_item_head_code,cal_item_code i want to delete rows from table 2 that does not match …
user3811246
  • 3
  • 3
0
votes
0 answers

Call JSON-functions on PostgreSQL 9.1

I've got a query which works on PostgreSQL 9.3, due to the fact that it supports JSON types etc. I would like to call this query on a remote API, which only runs PostgreSQL 9.1, with no such support. These are the needed things: ROW_TO_JSON,…
user809829
  • 1,179
  • 3
  • 14
  • 33
0
votes
1 answer

How to get the url from a string

** Hi , I have string like below. '{"","",https://www.facebook.com/bluecsushi/photos/pb.10007642612.-2207520000.1403730752./10151966146267613/?type=3,1780830_10151966146267613_759424320_n.jpg}' and i want get the result: www.facebook.com can u…
user2793872
  • 299
  • 1
  • 5
  • 14
0
votes
0 answers

value for postgresql double precision column

Can anyone please guide me how to use jstl sql param to populate a double precision column in the postgresql db? I wanna feed the data which is there in my html input tag, inside the jsp file. Thx Zia
Zia
  • 277
  • 4
  • 13
0
votes
2 answers

How to creating dynamic columns using data PostgreSQL 9.1?

So first off, I am completely new to databases and learning as I go. I have a table that comes from puppetdb in which I use postgresql as the backend. There are approximately 65 to 70 values for each certname (which can grow with custom facts) and…
user990951
  • 1,469
  • 5
  • 26
  • 36
0
votes
1 answer

.execute('INSERT ...') does not actually insert data into table

warning: brain fart imminent I've been at this for a bit now, and I'm guessing this is just a "I'm tired, can't get it through my head" type of issue so I'm hoping you will break this down for me.. I'll explain this backwards because it makes more…
Torxed
  • 22,866
  • 14
  • 82
  • 131
0
votes
1 answer

Translating MySQL query to Postgres

I have this MySQL query which works perfectly for what i need it to do. However, I need to translate this across to a postgres installation, and seem to be having some trouble. The query is as follows: SELECT r.studno, r.sdate,r.subject, …
Zy0n
  • 810
  • 2
  • 14
  • 33
0
votes
2 answers

Display Join Records Data in order of they created in Postgresql and Ruby On Rails

I have three tables in postgresql database: Members id first_name last_name created_at Payments (Like Debit) id member_id amount created_at type Fees (Like Credit) id member_id amount created_at type I would like to show them in a single…
Dinesh Saini
  • 2,917
  • 2
  • 30
  • 48
0
votes
0 answers

Rails3 partial index with postgresql

In a migration, a partial index is defined as follows to have only column price_1 where its value is greater than zero. add_index :products, :price_1, where: "(price_1 > '0')" the schema states add_index "products", ["price_1"], :name =>…
Jerome
  • 5,583
  • 3
  • 33
  • 76
0
votes
1 answer

Postgresql - COPY FROM value omitted after 64 characters

I'm trying to insert data from a textfile into a Postgres table. However, some data seems to be missing after copying. The textfile: TRUE|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbb|4096|%2Ftest%2F|2013-03-12 …
cpb2
  • 798
  • 1
  • 9
  • 17
0
votes
2 answers

function makepoint postgresql 9.1 error postgis

Migrating postgres 8.4 to 9.1 and moving my project to a new server I get this error ERROR: function makepoint(unknown, unknown) does not exist LINE 4: distance_sphere(makepoint('14.2995419','41.0310868'),mak... ^ HINT: No function matches the…
user2437305
  • 53
  • 1
  • 9
0
votes
2 answers

Rails, PG: Query returns one record per distinct attribute value, sorts by association attribute

I have not been having luck writing a Rails query that returns what I'm looking for. Suggested, posted solutions do not allow me to sort by a different attribute than I am selecting for DISTINCT. In my situation: each user can purchase multiple…
steel
  • 11,883
  • 7
  • 72
  • 109
0
votes
1 answer

Debugging postgresql over pgadmin displays the wrong line

When debugging postgresql over pgadmin, the pgadmin debugger display always a line to low, i.e. if line 10 is going to be executed the marking will stay in line 11. The problem is that the breaking points must also be set on a lower line, sometimes…
estani
  • 24,254
  • 2
  • 93
  • 76
0
votes
2 answers

Why can't I connect to a Postgres database?

I've installed and started a Postgres 9.1 instance on a DigitalOcean droplet. When I try to connect to it using my PgAdmin III client (settings see below), I get the message that the server is not listening at the specified port. The output netstat…
Glory to Russia
  • 17,289
  • 56
  • 182
  • 325
0
votes
1 answer

Dblink Insert Update Delete - Number of rows affected always zero

I'm using dblink to do some data manipulation (insert, update or delete) on a remote database. Specifically I am using views, and rules on the views to do the insert, update or delete. For example: -- SQL -- Note: get_remote_db() is a function…
ADTC
  • 8,999
  • 5
  • 68
  • 93
1 2 3
…
99
100