FAQ

PostgreSQL > pgsql-general > June 2013

Search Discussions

130 discussions - 644 posts

  • Hello, I have a win32 application. It uses gtk for GUI and postgres. Recently I upgraded to newer gtk and postgres 9.2. I'm now getting utf8 errors from postgres. The thing I don't understand that ...
    Jiří PavlovskýJiří Pavlovský
    Jun 25, 2013 at 7:18 pm
    Jun 28, 2013 at 9:42 am
  • Function in DB2: BLOB()Criteria:Size of character string targeted for cast is more than 1GBHow can I migrate this function into PostgreSQL with above mention criteria. -- View this message in ...
    Sachin kotwalSachin kotwal
    Jun 18, 2013 at 8:53 am
    Jun 22, 2013 at 1:10 am
  • We use Postgres for shared hosting; i.e. what most people use MySQL for. The biggest headache for us so far has been that we're unable to get group permissions set up effectively so that different ...
    Michael OrlitzkyMichael Orlitzky
    Jun 30, 2013 at 7:46 pm
    Jul 4, 2013 at 12:38 am
  • Hello, I was trying to figure out how does one recover server statistics to the same snapshot to which a database is restored after PITR. The steps i had in mind were 1.Set up WAL archiving 2.On ...
    Sameer ThakurSameer Thakur
    Jun 20, 2013 at 6:17 am
    Jun 26, 2013 at 9:25 am
  • I am trying to write a script that will create and populate a database. I don't want to enter a password every time so I want to use a .pgpass file. It has the correct permissions: $ ls -l ...
    Stephen RaskuStephen Rasku
    Jun 21, 2013 at 10:20 pm
    Jun 25, 2013 at 2:14 pm
  • Hello, I had the distinct displeasure of staying up entirely too late with a customer this week because they upgraded to 12.04 and immediately experienced a huge performance regression. In the ...
    Joshua D. DrakeJoshua D. Drake
    Jun 6, 2013 at 10:35 pm
    Jun 20, 2013 at 7:06 pm
  • Hi all, Can any one give me more suggestion, about this problem. Every time my os got restart, postmaster.pid is missing. After that createing postmaster.pid is also not helping to start the server ...
    Itishree suklaItishree sukla
    Jun 21, 2013 at 10:53 am
    Jun 25, 2013 at 1:41 pm
  • Hey All, This is a message to confirm my thoughts / validate a possible approach. In a situation where PGDATA and {XLOG, ARCHIVELOG} are on different SAN/NAS volumes and a backup is to be initiated ...
    James SewellJames Sewell
    Jun 20, 2013 at 6:45 am
    Jul 31, 2013 at 12:24 pm
  • I'm moving this discussion to -general. Dmitriy Igrishin wrote: Attempting to send a bind message over a closed connection will result in a PostgreSQL error. All you have to do is wrap that into an ...
    Albe LaurenzAlbe Laurenz
    Jun 24, 2013 at 11:00 am
    Jul 13, 2013 at 12:46 pm
  • Hi all I have a question about sync streaming replication. I have 2 postgresql 9.1 servers set up with streaming replication. On the master node the slave is configured as a synchronous standby. I've ...
    Mads TandrupMads Tandrup
    Jun 4, 2013 at 1:26 pm
    Jun 7, 2013 at 11:13 am
  • Hi everyone, I assume this is not easy with standard PG but I wanted to double check. I have a column that has a very uneven distribution of values. ~95% of the values will be the same, with some ...
    Steven SchlanskerSteven Schlansker
    Jun 18, 2013 at 7:17 pm
    Jun 18, 2013 at 10:00 pm
  • I've setup two 9.2.4 servers to serve as master-slave in a streaming replication scenario. I started with a fresh database on the master, setup the replication, then imported using pg_restore about ...
    David GrecoDavid Greco
    Jun 5, 2013 at 8:40 pm
    Jun 10, 2013 at 1:30 pm
  • Hi, guys I have met a problem that do confused me. I created a dump file by pg_dump from database named "DBRNWHSB" with parameters -b -o -Fc -Z 0. As you know, at the beginning of the dump file ...
    任洪彩任洪彩
    Jun 4, 2013 at 8:48 am
    Jun 6, 2013 at 1:55 am
  • I have a VIEW that does not appear to take advantage of the WHERE when given the opportunity: db=# explain select * from best_for_sale_layouts; QUERY PLAN ...
    Mike SummersMike Summers
    Jun 4, 2013 at 9:53 pm
    Jun 5, 2013 at 2:36 pm
  • Dear community Last week we upgraded our database from 8.4 to 9.1. The upgrade seemed to go fine and the database seems to have been working fine ever since (around a week now). However, today I ...
    Stuart FordStuart Ford
    Jun 24, 2013 at 11:13 am
    Jul 3, 2013 at 2:59 pm
  • Came across an interesting situation as part of our Oracle to PostgreSQL migration. In Oracle, it appears that immediate constraints are checked after the entire statement is run, including any AFTER ...
    David GrecoDavid Greco
    Jun 28, 2013 at 12:45 pm
    Jun 28, 2013 at 4:57 pm
  • While migrating my application from DB2 to PostgreSQL. I want to migrate TIMESTAMP() function of DB2 into PostgreSQL. Example in DB2: #SELECT TIMESTAMP('2013-01-01','12:13:14') FROM SYSIBM.SYSDUMMY1 ...
    Sachin kotwalSachin kotwal
    Jun 27, 2013 at 11:43 am
    Jun 28, 2013 at 4:30 am
  • Hi , Today i m creating a function that includes dynamic concatenation of a partitioned table name as below :- test=# CREATE OR REPLACE FUNCTION tmp_trigger_function() test-# RETURNS TRIGGER AS $$ ...
    Adarsh SharmaAdarsh Sharma
    Jun 26, 2013 at 5:07 am
    Jun 26, 2013 at 9:50 am
  • I am having some problems moving a column to another table and fixing some views that rely on it. I want to move the area_id column from t_offerprice_pipe to t_offerprice and then left join the ...
    Jason LongJason Long
    Jun 20, 2013 at 6:59 pm
    Jun 21, 2013 at 4:28 am
  • I'm trying to get a compass bearing (N,S,NW,etc) using earthdistance. I can successfully get the distance between 2 points using either the point or cube method, but I've been struggling with getting ...
    Jeff HerrinJeff Herrin
    Jun 18, 2013 at 6:17 pm
    Jun 18, 2013 at 7:39 pm
  • Hi all I'm looking for suggestions on the best way to track the updates to a function. We have two databases, Dev & Live, so I want to update Live with just the functions that have been modified in ...
    Rebecca ClarkeRebecca Clarke
    Jun 7, 2013 at 10:30 am
    Jun 7, 2013 at 4:56 pm
  • Hello: I have a PostgreSQL 9.0.3 database that has suddenly started exhibiting odd read behavior. The version number is: "PostgreSQL 9.0.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 ...
    Ray CoteRay Cote
    Jun 6, 2013 at 4:53 pm
    Jun 6, 2013 at 10:15 pm
  • Hello! I want to dynamically create partition tables that inherit a main table called "foo". The creation must occur when needed. For example, lets say that I want to insert 100000 entries and I want ...
    dafNi zafdafNi zaf
    Jun 26, 2013 at 1:47 pm
    Jul 10, 2013 at 2:28 pm
  • I have numeric values in a numeric column.the column has two parts.i want to split in 2 differnet column . The column value looks like this: Quantity 2000 -1000 both the quantity values are of a same ...
    JashasweeJashaswee
    Jun 19, 2013 at 10:51 am
    Jun 24, 2013 at 2:44 pm
  • Greetings, I'm trying to test out the new postgres-fdw support in postgresql-9.3 (beta) in preparation for an upgrade from 9.2 later this year. So far, everything is working ok, however one problem ...
    Lonni J FriedmanLonni J Friedman
    Jun 21, 2013 at 5:39 pm
    Jun 21, 2013 at 7:58 pm
  • I was given a dump of an existing remote schema and database, and the restore on my local system failed. Looking into it, I found a circular parent-child/child-parent relationship, and I don't ...
    Melvin CallMelvin Call
    Jun 21, 2013 at 1:21 am
    Jun 21, 2013 at 3:09 pm
  • Hello, All ! I am developing database. Initial scripts contains information in win1251 encoding. Now I have received problem c_db1=# \encoding WIN1251 WIN1251: invalid encoding name or conversion ...
    Yuriy RusinovYuriy Rusinov
    Jun 15, 2013 at 9:16 am
    Jun 21, 2013 at 8:25 am
  • Hello, all. In the PostgreSQL documentation I found "currval: Return the value most recently obtained by nextval for this sequence in the current session ...." In other documentations (pgpool, for ...
    Gustavo Amarilla SantacruzGustavo Amarilla Santacruz
    Jun 9, 2013 at 3:59 pm
    Jun 10, 2013 at 4:03 pm
  • Hello, I have been testing the differences between asynchronous and synchronous hot standby streaming replication on PostgreSQL 9.2.4. There is some push towards synchronous replication, but I am ...
    Colin SlossColin Sloss
    Jun 6, 2013 at 10:20 am
    Jun 7, 2013 at 7:59 pm
  • I observed the following behaviour (I tested the following statements in 9.0.4, 9.0.5 and 9.3beta1): $ psql template1 template1=# SELECT CASE WHEN 0=0 THEN 0 ELSE 1/0 END; case ------ 0 (1 row) ...
    Andrea LombardoniAndrea Lombardoni
    Jun 17, 2013 at 8:18 pm
    Jun 28, 2013 at 7:01 am
  • Hello, Today our standby instance stopped working with this error in the log: 2013-06-22 16:27:32 UTC [8367]: [247-1] [] WARNING: page 158130 of relation ...
    Dan KoganDan Kogan
    Jun 22, 2013 at 7:44 pm
    Jun 24, 2013 at 1:44 pm
  • Hi All, I am using coalesce(firstname,lastname), to get the result if first name is 'NULL' it will give me lastname or either way. I am having data like instead of NULL, blank null ( i mean something ...
    Itishree suklaItishree sukla
    Jun 20, 2013 at 4:15 pm
    Jun 21, 2013 at 3:20 pm
  • Hello: I have one question about prepared statement. I use Java via JDBC, then send prepared statement to execute. I thought that the pg_prepared_statments view will have one record after my ...
    高健高健
    Jun 17, 2013 at 2:52 am
    Jun 18, 2013 at 9:01 am
  • Hello, I'm working on two extensions, call them "foo" and "bar". bar depends on some of the functions defined in foo. They are both built from a single Makefile, just vanilla PGXS: MODULES = foo bar ...
    Stephen ScheckStephen Scheck
    Jun 12, 2013 at 5:45 pm
    Jun 13, 2013 at 7:24 pm
  • Hello, I'm creating a database and I have got a table with a "version" field. Can I update on structure changes (DDL) like create / update table increment this field automatically? I would like to ...
    Philipp KrausPhilipp Kraus
    Jun 10, 2013 at 7:52 am
    Jun 11, 2013 at 11:42 am
  • Hi All, I would like to ask for some suggestions regarding the following scenario. I have a cash drawer table and for each cash drawer I have a function that collects and transforms data from ...
    Ioana DanesIoana Danes
    Jun 5, 2013 at 6:34 pm
    Jun 6, 2013 at 8:18 pm
  • Hello list, I am playing around with views and INSTEAD OF triggers, and have run across an interesting problem that I can't seem resolve, so I figured it was time to expose my ignorance to the whole ...
    Melvin CallMelvin Call
    Jun 3, 2013 at 6:55 pm
    Jun 4, 2013 at 1:09 pm
  • We want to make sure no two examiners are working on the same case at the same time, where the cases are found by searching on certain criteria with limit 1 to get the "next case". A naive approach ...
    Kenneth TiltonKenneth Tilton
    Jun 28, 2013 at 5:16 pm
    Jul 5, 2013 at 5:48 pm
  • trying to install 9.1.9 64bit on a win2008 r2 server and getting a failure of the initdb phase, with no clue why. I've installed the application on C:\postgresql\9.1\ and the data on ...
    John R PierceJohn R Pierce
    Jun 26, 2013 at 7:37 pm
    Jun 27, 2013 at 6:49 pm
  • I'm trying to compile pg 9.3 beta 1 from source using microsoft visual studio on a computer running windows 7. When I build I run into around 1600 errors and around 36 warnings. I imagine I'm doing ...
    Jake SilvermanJake Silverman
    Jun 26, 2013 at 2:14 pm
    Jun 27, 2013 at 1:10 am
  • Has anyone played around with what I would call "Semi-Pseudo Data Types," in which a stored procedure may accept a sub-set of a Pseudo Data Types but not just any pseudo data-type, such as any type ...
    Joshua BurnsJoshua Burns
    Jun 26, 2013 at 5:51 am
    Jun 26, 2013 at 3:53 pm
  • Hello: I have question about PG's "create index concurrently". I think it is a bug perhaps. I make two tables tab01 and tab02, they have no relationships. I think "create index concurrently " on ...
    高健高健
    Jun 20, 2013 at 8:27 am
    Jun 25, 2013 at 9:33 am
  • Can someone suggest the easiest way to compare the results from two queries to make sure they are identical? I am rewriting a large number of views and I want to make sure that nothing is changes in ...
    Jason LongJason Long
    Jun 20, 2013 at 10:18 pm
    Jun 21, 2013 at 6:46 am
  • Hello everybody: Sorry for disturbing. I experience the prepared statement of postgresql via psql and have one question: In terminal A: I prepared: postgres=# prepare test(int) AS postgres-# select * ...
    高健高健
    Jun 14, 2013 at 8:49 am
    Jun 17, 2013 at 2:19 am
  • Hi I just installed an openSUSE 12.3 64Bit on an i5 box with 32GB RAM. Then I installed postgresql 9.2.4 from their repository. The pg service starts with default config. As default it has only 24 MB ...
    AndreasAndreas
    Jun 14, 2013 at 6:49 pm
    Jun 15, 2013 at 1:46 am
  • Hi : Sorry for disturbing. I don't know if it is ok to put this question here. I want to learn more about hash join's cost calculation. And I found the following function of PostgreSQL9.2.1. The hash ...
    高健高健
    Jun 13, 2013 at 10:17 am
    Jun 14, 2013 at 11:58 am
  • Hello: Would somebody please kindly tell why my function run but can't update table via cursor: I have table like this: create table course_tbl(course_number integer, course_name varchar(4), ...
    高健高健
    Jun 10, 2013 at 3:00 am
    Jun 13, 2013 at 9:58 am
  • Hello! In a PostgreSQL 8.4.13 why doesn't this please deliver a floating value (a quotient between 0 and 1): select id, count(nullif(nice, false)) - count(nullif(nice, true)) / count(nice) as rating ...
    Alexander FarberAlexander Farber
    Jun 11, 2013 at 9:51 am
    Jun 11, 2013 at 11:06 am
  • Hi, Yesterday we configured a new server with Fedora 17 64 bit and updated it's kernel to 3.8. I have to compile and install postgresql with python. So I executed commands ./configure --with-python ...
    C kC k
    Jun 7, 2013 at 6:05 am
    Jun 8, 2013 at 9:29 pm
  • Hi, I,ve got a clients table in PostgreSQL. Each client has different documents (more than 7.000 files in total in different extensions JPG, XLS,DOC,PDF...) stored in a bytea field in another ...
    Aitor Gil MartinAitor Gil Martin
    Jun 7, 2013 at 9:35 am
    Jun 8, 2013 at 4:14 pm
Jun 2013
123
Group Navigation
period‹ prev | Jun 2013 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions130
posts644
users187
websitepostgresql.org
irc#postgresql

187 users for June 2013

Tom Lane: 32 posts David Johnston: 28 posts Albe Laurenz: 24 posts Adrian Klaver: 23 posts Jeff Janes: 20 posts Pavel Stehule: 16 posts 高健: 16 posts Alban Hertroys: 15 posts Amit Langote: 15 posts John R Pierce: 14 posts Bhanu udaya: 10 posts David Greco: 10 posts Sachin kotwal: 10 posts Joshua D. Drake: 9 posts Adarsh Sharma: 8 posts Merlin Moncure: 8 posts François Beausoleil: 7 posts Jiří Pavlovský: 7 posts Melvin Call: 7 posts Sameer Thakur: 7 posts
show more
Archives