Search Discussions
-
With 9.0 there is the new hex encoding for BYTEA, which is activated by default. libpq BEFORE 9.0 are not able to decode that encoding. I am programming with Python, using psycopg2. When psycopg2 is ...
Massa, Harald Armin
Oct 5, 2010 at 7:33 am
Dec 14, 2010 at 4:56 pm -
For reasons I do not understand, the Slackware start-up file for postgres (/etc/rc.d/rc.postgresql) fails to work properly after I reboot the system. (Reboots normally occur only after a kernel ...
Rich Shepard
Oct 20, 2010 at 10:53 pm
Oct 21, 2010 at 8:20 pm -
My production server is running Postgres 9.0 on Ubuntu Server, and I'm getting some errors in sprocs that call uuid_generate_v1().. This is because the function is missing. On my Windows box, this ...
Mike Christensen
Oct 7, 2010 at 1:18 am
Oct 25, 2010 at 12:26 pm -
I have a very simple update query. update cu set screenshot_file_name = tu.screenshot_file_name, screenshot_content_type = tu.screenshot_content_type, screenshot_file_size = tu.screenshot_file_size, ...
Tim Uckun
Oct 21, 2010 at 2:24 am
Oct 22, 2010 at 10:03 pm -
Hello Postgres users, to mimic the MySQL-REPLACE statement I need to try to UPDATE a record and if that fails - INSERT it. But how can I detect that the UPDATE has failed in my SQL procedure? begin ...
Alexander Farber
Oct 31, 2010 at 8:22 am
Nov 2, 2010 at 5:14 pm -
I have MinGW installed and I've unpacked the pg 9.0 source files which now reside in the following path: * C:\Program Files\postgresql-9.0.0 In Chapter 15.5 of the 9.0 manual, the installation ...
Turner, John J
Oct 15, 2010 at 9:13 pm
Oct 25, 2010 at 3:43 pm -
OK so I have read the docs and Google to try and find a way to add a new column to an existing table. My problem is I need this new column to be created 3rd rather than just dumping this new column ...
Carlos Mennens
Oct 13, 2010 at 10:09 pm
Oct 14, 2010 at 3:09 pm -
Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. -Carlos
Carlos Mennens
Oct 11, 2010 at 11:46 pm
Oct 19, 2010 at 5:48 pm -
Hi, today I noticed that in the documentation there is DROP INDEX CASCADE. I've got one question: what is that for? What can depend on index? regards Szymon
Szymon Guz
Oct 26, 2010 at 8:13 am
Nov 3, 2010 at 10:15 am -
Hello, I'm trying to create a table, where md5 strings will serve as primary keys. So I'd like to add a constraing that the key length should be 32 chars long (and contain [a-fA-F0-9] only): create ...
Alexander Farber
Oct 16, 2010 at 4:20 pm
Oct 17, 2010 at 4:43 pm -
I know I've seen posts on how to do this, but i can't seem to find them. I've got a data set A, B A, C A, D [...] and so on and i'd like to be able to wite a query that would result in 1,A,B 2,A,C ...
David Kerr
Oct 20, 2010 at 10:22 pm
Oct 22, 2010 at 12:36 am -
I know that MySQL uses MyISAM storage engine by default and was just trying to look on Google to try and see if I could understand what storage engine does PostgreSQL use by default when I generate a ...
Carlos Mennens
Oct 8, 2010 at 9:30 pm
Oct 13, 2010 at 2:39 pm -
I have a web application with a Postgres backend. In my initial prototype, I decided not to have a Postgres database user created for each application user, opting instead to use my own users table. ...
Tony Cebzanov
Oct 21, 2010 at 4:02 pm
Oct 27, 2010 at 10:15 am -
Folks, Postgree is the most amazing DB, even more it will be the only one that will remain free (the good ones) as MySQL has been taken. In order to move on with this project, as an Java Senior ...
Mauricio Chamati
Oct 19, 2010 at 2:13 pm
Oct 20, 2010 at 6:29 pm -
A customer was reviewing the database that supports the application we have provided. One of the tables is very simple, but has over 16 million records. Here is the table's definition: CREATE TABLE ...
Rob Richardson
Oct 29, 2010 at 8:52 pm
Oct 31, 2010 at 6:22 am -
Hello Postgres Hackers, We have a simple 'event log' table that is insert only (by multiple concurrent clients). It has an integer primary key. We want to do incremental queries of this table every 5 ...
Karl Pickett
Oct 29, 2010 at 2:04 am
Oct 31, 2010 at 3:27 am -
Okay my required n00b question of the week, hopefully this'll be an easy one.. I decided to give pgAgent a shot, because there's this stored sproc (sorry, function) I need to run nightly and I think ...
Mike Christensen
Oct 17, 2010 at 2:39 pm
Oct 18, 2010 at 10:45 am -
CHAR(20) columns in 8.4 database may contains spaces and - signs like 13-333-333 12 3-44 33 33 333 12345 User enters code to search without spaces and - signs, like 12344 How to search for product ...
Andrus
Oct 13, 2010 at 8:42 pm
Oct 14, 2010 at 11:23 am -
Hi all, We're currently testing a new javascript change on the PostgreSQL docs. This is to make sure monospaced fonts still appear at a reasonable size between browsers. I'd appreciate it if some of ...
Thom Brown
Oct 4, 2010 at 6:41 pm
Oct 6, 2010 at 2:49 pm -
Some one know how to solve the problem of db that became huge from 700 Mbyte to 16 Gbyte in 10 days and grow... Vacuum doesn't solve the problem. Only vacuum full is too invasive, the only way to ...
Hfe80
Oct 26, 2010 at 9:22 pm
Oct 28, 2010 at 1:38 pm -
Hi, The quick question is: How (if possible) can I do to get data (maybe through xlogs) from two separate databases and merge them into one? For those that want to know my situation, here it is: I ...
Daniel Crespo
Oct 27, 2010 at 2:00 pm
Oct 28, 2010 at 8:03 pm -
Hello everyone. I have been investigating the PG async calls and trying to determine whether I should go down the road of using them. In doing some experiments I found that using ...
Michael Clark
Oct 27, 2010 at 9:02 pm
Oct 28, 2010 at 5:52 pm -
Defaulting bytea output from the backend to use hex mode encoding, which is incompatible with pre-9.0 interfaces, wasn't a friendly thing to do. The default should have been escape mode. Or else you ...
Ljb
Oct 13, 2010 at 1:05 am
Oct 22, 2010 at 10:24 pm -
Hi, I'm trying to require SSL for Postgres connections from certain IPs.. This is on Postgres 9.0. First, I've followed the directions at: http://www.postgresql.org/docs/9.0/static/ssl-tcp.html I've ...
Mike Christensen
Oct 10, 2010 at 3:53 am
Oct 11, 2010 at 6:34 pm -
Is there any tutorials or detailed instructions on how to set up HA postgresql & failover? The documentation (http://www.postgresql.org/docs/9.0/interactive/warm-standby-failover.html) on this topics ...
Andy
Oct 7, 2010 at 6:27 am
Oct 7, 2010 at 6:10 pm -
Hello Postgres users, I have a Linux website with phpBB serving a small Facebook game: # uname -a Linux XXXXX 2.6.18-194.17.1.el5 #1 SMP Wed Sep 29 12:50:31 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux # ...
Alexander Farber
Oct 4, 2010 at 9:20 am
Oct 4, 2010 at 7:08 pm -
We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5 Navigator, where one can enable logging of SQL statements and then it will recommed indexes that should/could be created to ...
Bjørn T Johansen
Oct 1, 2010 at 10:11 am
Oct 1, 2010 at 3:24 pm -
Hi there, I have a database with statistical tables which look like this: id | year_start | value 3 1960 736.1 3 1961 723.3 .... 4 1960 123.4 Years can cover 40 years for each of the countries (ID) ...
Stefan Schwarzer
Oct 19, 2010 at 10:15 am
Nov 4, 2010 at 7:00 am -
Composite Index question: I have composite index on 3 columns on a table, by mistake the composite index was created twice on the table. Will there any performance issues on this table because of the ...
DM
Oct 20, 2010 at 11:44 pm
Oct 21, 2010 at 6:08 pm -
Hello all, I'm experiencing a weird issue where my postgresql is creating strange files (all with the same size ~200MB) under /var/lib/pgsql. The filenames are like "?" and "?default". Anyone knows ...
Juan Sueiro
Oct 7, 2010 at 1:46 pm
Oct 8, 2010 at 12:14 pm -
I have two tables. Table C has about 300K records in it. Table E has about a million records in it. Today I tried to run this query. update C set result_count = X.result_count from C inner join ...
Tim Uckun
Oct 5, 2010 at 9:20 am
Oct 5, 2010 at 9:06 pm -
Dear List, Firstly thanks to the postgresql global development team for releasing postgresql with such a great enterprise feature of SR & HS. As an enduser i setup SR based on ...
Rajesh Kumar Mallah
Oct 2, 2010 at 4:02 pm
Oct 5, 2010 at 10:16 am -
Hi, I have some issue where SELECT * from pg_stat_activity WHERE current_query='<IDLE '; returns too many rows . What is the meaning of IDLE ? I suspect that the server is overloaded with idle ...
Georgi Ivanov
Oct 6, 2010 at 1:26 pm
Feb 12, 2011 at 11:36 pm -
Hi, i have very big XML documment which is larger than 50GB and want to import it into databse, and transform it to relational schema. When splitting this documment to smaller independent xml ...
Viktor Bojović
Oct 30, 2010 at 9:48 pm
Dec 29, 2010 at 8:58 am -
Dear All, I want to convert integer datatype to serial datatype.. is that possible.Please let me know. Thanks and Regards, Ven
Venkat
Oct 29, 2010 at 4:49 am
Oct 29, 2010 at 5:30 am -
Hello I have a master PG 8.1.11 sending WAL files to a cold-standby using rsync For some reason it failed recently with "return codes 32512" and I couldn't find this num. as a valid rsync exit code ...
Zhong ming wu
Oct 23, 2010 at 12:01 pm
Oct 26, 2010 at 1:29 am -
Is there a way to select the top 10% of the values from a column? For example the top 10% best selling items where number of sales is a column. Thanks.
Tim Uckun
Oct 17, 2010 at 11:34 pm
Oct 18, 2010 at 3:23 am -
I have a large Postgres DB (1100 GB) that I'd like to move to a new physical machine. In the past I've done this via pg_dump & restore, but the DB was much smaller then, and I'm concerned about how ...
EDH
Oct 13, 2010 at 4:30 pm
Oct 14, 2010 at 3:44 pm -
MayVACUUM FULL on a table improve perfromance of the system?
AI Rumman
Oct 7, 2010 at 11:38 am
Oct 7, 2010 at 2:23 pm -
Hi everyone, I'm trying to take a base backup of my primary DB ready for copying to my standby. I've followed the instructions to configure my postgresql.conf at ...
Dan.m.harris
Oct 28, 2010 at 11:42 am
Oct 28, 2010 at 2:38 pm -
Hi, Here is my problem: I have a postgresql C function that looks like this: Datum filter(PG_FUNCTION_ARGS); It takes identifiers and queries a bunch of tables and ends up returning true or false. So ...
Gabi Julien
Oct 21, 2010 at 12:04 am
Oct 21, 2010 at 5:58 pm -
Steps to reproduce: 1. Ran latest pgAdmin in windows server 2005 Standard x64 Edition 2. Restore data to Postgres 9.0 linux server from 450 MB backup file if only SSL connection is enabled After some ...
Andrus Moor
Oct 2, 2010 at 8:30 pm
Oct 21, 2010 at 2:05 pm -
Hi List, Is there any feature to drop the view with out cascading the dependents. Below is my requirement. I have a view which is dependent on the other view/table. I wanted to drop the view ...
Ravi Katkar
Oct 19, 2010 at 5:53 am
Oct 20, 2010 at 3:02 pm -
Hello, i'm using initdb of an PostgreSQL 8.4 installed over the port-system of FreeBSD: ===== --lc-ctype=de_DE.UTF-8 --lc-messages=de_DE.UTF-8 --lc-monetary=de_DE.UTF-8 --lc-numeric=de_DE.UTF-8 ...
Torsten Zühlsdorff
Oct 18, 2010 at 2:53 pm
Oct 19, 2010 at 2:03 pm -
Is it possible to get the results of this snip of a function without using a function? All tables include an id and title column. tables := ARRAY[table_one,table_two,table_three]::VARCHAR; CREATE ...
Nick
Oct 14, 2010 at 11:53 pm
Oct 16, 2010 at 4:10 am -
Hi, I have the following table: CREATE TABLE A ( a1 integer not null, a2 integer, a3 integer, a4 integer ) and have the following four indices: create index ind_a1 on A USING gist(a1); create index ...
Sunpeng
Oct 12, 2010 at 10:03 pm
Oct 13, 2010 at 3:31 pm -
While compiling PostgreSQL-9.0.0 on HP-UX/ia64 (B.11.23) gmake breaks up with the next errors: ..... gmake -C libpq all gmake[3]: Entering directory ...
Derk Jan Horstman
Oct 4, 2010 at 1:58 pm
Oct 12, 2010 at 9:25 am -
Hi all. I am trying to create two databases in two different machines connected over the lan. Both the databases have similar tables and fields in them. I will be updating database A always. I want ...
Sairam Krishnamurthy
Oct 4, 2010 at 8:02 pm
Oct 6, 2010 at 3:23 pm -
I'm trying to come up with an automated monitoring system to watch the WAL log progress and sound appropriate alarms if it gets too far behind for some reason (e.g. communications problems, etc.) - ...
Karl Denninger
Oct 3, 2010 at 3:50 am
Oct 3, 2010 at 9:27 pm -
Please, help me. Why the condition SELECT 5 NOT IN (NULL) returns NULL, but not FALSE (as I thought)? -- Paul
Paul
Oct 31, 2010 at 4:37 pm
Oct 31, 2010 at 5:19 pm
Group Overview
group | pgsql-general |
categories | postgresql |
discussions | 219 |
posts | 1,154 |
users | 278 |
website | postgresql.org |
irc | #postgresql |
278 users for October 2010
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)