Search Discussions
-
22
utf8 errors
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ý
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 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 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 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 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. 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 ...
Jashaswee
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 ...
Andreas
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 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 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 Martin
Jun 7, 2013 at 9:35 am
Jun 8, 2013 at 4:14 pm
Group Overview
group | pgsql-general |
categories | postgresql |
discussions | 130 |
posts | 644 |
users | 187 |
website | postgresql.org |
irc | #postgresql |
187 users for June 2013
Archives
- August 2013 (761)
- July 2013 (663)
- June 2013 (644)
- May 2013 (789)
- April 2013 (795)
- March 2013 (663)
- February 2013 (841)
- January 2013 (904)
- December 2012 (821)
- November 2012 (944)
- October 2012 (841)
- September 2012 (940)
- August 2012 (801)
- July 2012 (661)
- June 2012 (733)
- May 2012 (764)
- April 2012 (704)
- March 2012 (984)
- February 2012 (814)
- January 2012 (863)
- December 2011 (916)
- November 2011 (1,172)
- October 2011 (1,102)
- September 2011 (1,114)
- August 2011 (1,074)
- July 2011 (906)
- June 2011 (951)
- May 2011 (993)
- April 2011 (1,080)
- March 2011 (1,095)
- February 2011 (1,004)
- January 2011 (896)
- December 2010 (1,068)
- November 2010 (1,225)
- October 2010 (1,154)
- September 2010 (1,115)
- August 2010 (880)
- July 2010 (1,038)
- June 2010 (1,349)
- May 2010 (1,161)
- April 2010 (1,172)
- March 2010 (1,209)
- February 2010 (1,214)
- January 2010 (1,351)
- December 2009 (1,202)
- November 2009 (476)
- October 2009 (1,234)
- September 2009 (1,234)
- August 2009 (1,254)
- July 2009 (1,440)
- June 2009 (1,417)
- May 2009 (1,215)
- April 2009 (1,177)
- March 2009 (1,366)
- February 2009 (1,330)
- January 2009 (1,174)
- December 2008 (951)
- November 2008 (1,411)
- October 2008 (1,476)
- September 2008 (1,241)
- August 2008 (1,175)
- July 2008 (1,244)
- June 2008 (1,056)
- May 2008 (1,130)
- April 2008 (1,435)
- March 2008 (1,656)
- February 2008 (1,511)
- January 2008 (1,590)
- December 2007 (1,470)
- November 2007 (1,758)
- October 2007 (1,693)
- September 2007 (1,381)
- August 2007 (2,067)
- July 2007 (1,249)
- June 2007 (1,778)
- May 2007 (1,629)
- April 2007 (1,276)
- March 2007 (1,731)
- February 2007 (1,710)
- January 2007 (1,939)
- December 2006 (1,601)
- November 2006 (1,843)
- October 2006 (1,571)
- September 2006 (1,274)
- August 2006 (1,481)
- July 2006 (1,149)
- June 2006 (1,242)
- May 2006 (1,582)
- April 2006 (1,355)
- March 2006 (1,577)
- February 2006 (1,201)
- January 2006 (1,715)
- December 2005 (1,381)
- November 2005 (1,408)
- October 2005 (1,907)
- September 2005 (1,209)
- August 2005 (1,605)
- July 2005 (1,317)
- June 2005 (1,391)
- May 2005 (1,358)
- April 2005 (1,419)
- March 2005 (1,611)
- February 2005 (1,511)
- January 2005 (1,855)
- December 2004 (1,334)
- November 2004 (1,525)
- October 2004 (1,549)
- September 2004 (1,341)
- August 2004 (1,640)
- July 2004 (963)
- June 2004 (1,219)
- May 2004 (936)
- April 2004 (1,188)
- March 2004 (1,223)
- February 2004 (1,326)
- January 2004 (1,670)
- December 2003 (1,638)
- November 2003 (1,747)
- October 2003 (1,575)
- September 2003 (1,857)
- August 2003 (1,786)
- July 2003 (1,557)
- June 2003 (1,927)
- May 2003 (1,290)
- April 2003 (1,564)
- March 2003 (1,565)
- February 2003 (1,761)
- January 2003 (1,625)
- December 2002 (1,225)
- November 2002 (1,477)
- October 2002 (1,432)
- September 2002 (1,401)
- August 2002 (1,246)
- July 2002 (1,869)
- June 2002 (1,337)
- May 2002 (1,185)
- April 2002 (1,254)
- March 2002 (1,363)
- February 2002 (1,418)
- January 2002 (1,181)
- December 2001 (879)
- November 2001 (1,117)
- October 2001 (1,177)
- September 2001 (1,213)
- August 2001 (1,270)
- July 2001 (1,316)
- June 2001 (1,630)
- May 2001 (1,677)
- April 2001 (16)
- March 2001 (1,633)
- February 2001 (1,597)
- January 2001 (1,668)
- December 2000 (1,001)
- November 2000 (1,067)
- October 2000 (1,304)
- September 2000 (992)
- August 2000 (846)
- July 2000 (1,145)
- June 2000 (797)
- May 2000 (832)
- April 2000 (695)
- March 2000 (220)
- February 2000 (478)
- January 2000 (656)
- December 1999 (643)
- November 1999 (506)
- October 1999 (622)
- September 1999 (384)
- August 1999 (494)
- July 1999 (406)
- June 1999 (462)
- May 1999 (405)
- April 1999 (328)
- March 1999 (382)
- February 1999 (360)
- January 1999 (295)
- December 1998 (239)
- November 1998 (266)
- October 1998 (278)
- September 1998 (185)
- August 1998 (224)
- July 1998 (432)
- June 1998 (352)
- May 1998 (134)