Search Discussions
-
Howdy, [N.B.: I tried to send this a while ago but it didn't get delivered, I'm assuming because, with the uncompressed patch, the email was too big for -hackers. So this is a re-send with the patch ...
David E. Wheeler
Jun 28, 2008 at 1:22 am
Jul 9, 2008 at 4:49 pm -
Hi, This is a small patch I posted a few months back, and then kinda forgot about / got distracted with other things. Is there any interest in this? If so I am willing to put more work into it, if ...
Dean Rasheed
Jun 30, 2008 at 12:34 pm
Nov 19, 2008 at 3:00 am -
pg_dump restore times can be high when they include many ALTER TABLE ADD FORIEGN KEY statements, since each statement checks the data to see if it is fully valid in all cases. I've been asked "why we ...
Simon Riggs
Jun 5, 2008 at 6:20 am
Jun 10, 2008 at 12:55 am -
Hi, attached are two patches against HEAD. The smaller one is meant to be commited - it adds some functions that manipulate double-linked lists, namely inserting a new cell after or before another ...
Jan Urbański
Jun 27, 2008 at 7:12 am
Jul 14, 2008 at 12:38 pm -
Howdy, I'm sure I'm just showing off my ignorance here, but here goes… I really need case-insensitive string comparison in my database. Ideally there'd be a nice ITEXT data type (and friends, ichar, ...
David E. Wheeler
Jun 2, 2008 at 3:53 am
Jun 5, 2008 at 4:38 pm -
Folks, With lots of help from Greg Sabino Mullane, I've set up a git repository for the WITH RECURSIVE patches on <http://git.postgresql.org/ . What other patches would people like to try maintaining ...
David Fetter
Jun 24, 2008 at 4:38 am
Jul 7, 2008 at 5:48 pm -
Could someone using the pgcrypto extension please verify this? SELECT encode(digest(null, 'md5'::text), 'hex'); or SELECT digest(null, 'md5'); Takes a few seconds, and then crashes the server with a ...
Mario Weilguni
Jun 16, 2008 at 10:46 am
Jun 18, 2008 at 2:01 am -
This thread http://archives.postgresql.org/pgsql-hackers/2008-01/msg00134.php kind of wandered off into the weeds after identifying a semi-related bug in CLUSTER, but the original problem still ...
Tom Lane
Jun 27, 2008 at 3:45 pm
Jul 12, 2008 at 4:49 pm -
Hi all, There is a TODO Item to allow pg_hba.conf to specify host names along with IP addresses. I'd like to work on this feature, if nobody is working too and no objection exists. Thanks. -- []s ...
Dickson S. Guedes
Jun 12, 2008 at 7:24 pm
Jun 26, 2008 at 9:19 pm -
Currently eqsel assumes that, except for the values stored as mcv's, the number of times that a value appears in a table column is independent of it's value. Unfortunately, this often yields ...
Nathan Boley
Jun 8, 2008 at 6:24 pm
Jun 12, 2008 at 6:07 pm -
We have written a FAQ, where are common issues collected, there are also discussion about design decisions and why concentrating only to functions is good idea. ...
Marko Kreen
Jun 28, 2008 at 1:36 pm
Jul 24, 2008 at 4:05 pm -
Howdy, I just wanted to report the latest on my pet project: implementing a new case-insensitive text type, "citext", to be locale-aware and to build and run on PostgreSQL 8.3. I'm not much of a C ...
David E. Wheeler
Jun 25, 2008 at 6:47 pm
Jul 1, 2008 at 4:08 pm -
I was thinking a bit about how we pad columns of type NAME to fixed-width, even though they're semantically equivalent to C strings. The reason for wasting that space is that it makes it possible to ...
Tom Lane
Jun 23, 2008 at 7:53 pm
Jul 1, 2008 at 2:35 pm -
Folks, I forgot to post the fact that I'd put up a <http://wiki.postgresql.org/wiki/How_to_sponsor_a_feature , per my TODO from the developers' meeting in Ottawa. Sorry about that. Anyhow, Jignesh ...
David Fetter
Jun 11, 2008 at 7:34 pm
Jun 16, 2008 at 6:41 pm -
Is it desirable that pg_dump doesn't dump config settings set via ALTER DATABASE? http://archives.postgresql.org/pgsql-novice/2008-04/msg00016.php I just got bitten by a DateStyle not being restored ...
Richard Huxton
Jun 27, 2008 at 1:50 pm
Aug 22, 2008 at 2:31 pm -
Hello There was more time questions about array's initialisation. I propose function array_init. CREATE OR REPLACE FUNCTION array_init(sizes int[], v anyelement) RETURNS anyarray; First parameter is ...
Pavel Stehule
Jun 2, 2008 at 4:04 pm
Jun 5, 2008 at 4:01 am -
Hello, Postgres 8.4 has pg_stat_user_functions view to track number of calls of stored functions and time spent in them. Then, I'm thinking a "sql statement" version of similar view -- ...
ITAGAKI Takahiro
Jun 13, 2008 at 8:33 am
Jun 24, 2008 at 7:03 am -
I would like to request a change to the PGBE_ACTIVITY_SIZE #define in the pgstat.h file. This value determines the max length of the SQL query contained in the PgBackendStatus structure. By ...
David Miller
Jun 19, 2008 at 2:54 pm
Jun 22, 2008 at 6:34 pm -
Attached is a worked-out patch for the approach proposed here: http://archives.postgresql.org/pgsql-hackers/2008-06/msg00777.php namely, that cache management for de-TOASTed datums is handled by ...
Tom Lane
Jun 29, 2008 at 8:57 pm
Aug 26, 2008 at 1:10 am -
I found this error message in my log files repeatedly: Error: failed to re-find parent key in "ledgerdetail_2008_03_idx2" for deletion target page 64767 I though "hmm, that index looks broken. I'd ...
Andrew Hammond
Jun 25, 2008 at 7:40 am
Jul 7, 2008 at 10:04 pm -
Hi, After pondering on the problem for quite some time and discussing it on IRC with RhodiumToad I thought the most sensible thing is to post the problem here (as RhodiumToad suggested as well). The ...
Andres Freund
Jun 25, 2008 at 3:10 pm
Jun 27, 2008 at 4:14 pm -
1) Overview This proposal is part of inplace upgrade project. PostgreSQL should be able to read any page in old version. This is basic for all possible upgrade method. 2) Background We have several ...
Zdenek Kotala
Jun 11, 2008 at 2:15 pm
Jun 13, 2008 at 4:18 pm -
I have a VIEW that consists of two tables, of which contain a POINT column. When trying to select from the view I get an error... ERROR: could not identify an ordering operator for type point HINT: ...
Nick
Jun 25, 2008 at 6:08 pm
Jun 26, 2008 at 11:33 am -
Marc Munro wrote: -- Start of PGP signed section. Yes, I can confirm this behavior on CVS HEAD, and it is odd: test= CREATE SCHEMA internal; CREATE SCHEMA test= CREATE VIEW internal.all_objects AS ...
Bruce Momjian
Jun 30, 2008 at 10:39 pm
Aug 23, 2008 at 8:33 pm -
The way I read it, the current btree index stores the index value and the TID of every tuple having that value. When you have a table with three columns, you index one of them and you get an index ...
Jeffrey Baker
Jun 24, 2008 at 8:34 pm
Jun 25, 2008 at 8:51 am -
Hi, I'm getting following error while envoking psql: $ psql psql: symbol lookup error: /usr/lib/libreadline.so.5: undefined symbol: BC This is Linux glibc 2.3.4 and readline 5.1. -- Tatsuo Ishii SRA ...
Tatsuo Ishii
Jun 25, 2008 at 7:42 am
Jul 28, 2008 at 10:12 pm -
12
sh -> pl
Folks, I've noticed that a big hunk of our build system has gratuitous dependencies on some variety of shell and on tools like sed, none of which makes Windows developers feel welcome. I know people ...David Fetter
Jun 17, 2008 at 2:04 pm
Jun 19, 2008 at 3:57 am -
Hello, I am trying to compile libpq.dll with MSVC 2003 on windows, using postgresql-8.3.3, but I get the following compile error: Creating library .\Release\libpqdll.lib and object .\Release ...
Jeff McKenna
Jun 24, 2008 at 6:45 pm
Jun 27, 2008 at 4:33 pm -
Recent discussions with the PostGIS hackers led me to think about ways to reduce overhead when the same TOAST value is repeatedly detoasted. In the example shown here ...
Tom Lane
Jun 16, 2008 at 7:35 pm
Jun 18, 2008 at 4:01 pm -
Howdy, Possibly showing my ignorance here, but as I'm working on updating citext to be locale-aware and to work on 8.3, I've run into this peculiarity: try=# \encoding UTF8 try=# select setting from ...
David E. Wheeler
Jun 16, 2008 at 5:46 am
Jun 17, 2008 at 3:09 am -
In my .psqlrc I have: \pset format wrapped and this outputs this on psql startup: $ psql test -- Output format is wrapped. psql (8.4devel) Type "help" for help. Is this desirable? \set QUIET at the ...
Bruce Momjian
Jun 11, 2008 at 11:24 pm
Jul 20, 2008 at 6:15 am -
Is there anyway to bind a cursor with SCROLL and WITH HOLD at the protocol level? Or perhaps configuring it so after binding it? I know you can use DECLARE, but I believe that this inhibits the ...
James William Pye
Jun 12, 2008 at 4:42 pm
Jun 14, 2008 at 12:59 am -
Hi there, I'm currently looking at a bug report in PostGIS where we are getting extremely long index scan times querying an index in one case, but the same scan can take much less time if the input ...
Mark Cave-Ayland
Jun 9, 2008 at 2:00 pm
Jun 10, 2008 at 9:15 am -
There are common cases where we want to remove unwanted joins from queries, especially with view and Object Relational Mapping systems such as Hibernate etc.. (I've mentioned this before on -hackers ...
Simon Riggs
Jun 26, 2008 at 10:52 am
Aug 16, 2008 at 12:40 am -
I would like to add the flags given to pg_dump into the output of the pg_dump file. For text dumps, the output would go on a line below the current header, so output would look like: -- -- PostgreSQL ...
Robert Treat
Jun 2, 2008 at 8:54 pm
Jul 16, 2008 at 1:22 am -
Buildfarm bobcat is broken running the pltcl regression tests - see http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=bobcat&dt=2008-06-15%2022:43:01 and I have reproduced this on Fedora 9 myself. ...
Andrew Dunstan
Jun 16, 2008 at 12:54 am
Jun 17, 2008 at 11:43 am -
One of the areas where libpq seems to be severely lacking is in handling arrays and composites in query results. I'd like to set about rectifying that. Ideally this would mean that drivers using ...
Andrew Dunstan
Jun 8, 2008 at 11:59 pm
Jun 10, 2008 at 3:29 pm -
I have attached a patch for phrase search with respect to the cvs head. Basically it takes a a phrase (text) and a TSVector. It checks if the relative positions of lexeme in the phrase are same as in ...
Sushant Sinha
Jun 1, 2008 at 2:26 am
Jul 22, 2008 at 6:59 pm -
It is impossible to dump (with pg_dump -Ocx) and restore (with psql) a database which contains sequences in any of 8.1, 8.2, or 8.3: [...] -- -- Name: transaction_transaction_id_seq; Type: SEQUENCE ...
Jeffrey Baker
Jun 17, 2008 at 4:53 pm
Jun 18, 2008 at 2:36 pm -
So while tagging the upcoming releases, I got annoyed once again about what a tedious, error-prone bit of donkeywork it is. You've got to find and update the sub-version numbers, and *not* any chance ...
Tom Lane
Jun 9, 2008 at 1:12 am
Jun 12, 2008 at 3:54 pm -
I would like to consider adding constraints to GiST indexes. I think it is possible to add constraints that are more sophisticated than just UNIQUE. My use case is a non-overlapping constraint, but I ...
Jeff Davis
Jun 9, 2008 at 4:16 pm
Jun 10, 2008 at 9:30 pm -
Hello I found following bug - using explain in stored procedures like: CREATE OR REPLACE FUNCTION test(int) RETURNS void AS $$ DECLARE s varchar; BEGIN FOR s IN EXECUTE 'EXPLAIN SELECT * FROM o WHERE ...
Pavel Stehule
Jun 1, 2008 at 9:30 am
Jun 1, 2008 at 6:59 pm -
One of our guys in Pakistan noticed a problem with Slony that seems to have manifested itself since the last zic update. Slony uses timeofday() as the default value for a timestamp column: -- ...
Dave Page
Jun 10, 2008 at 1:23 pm
Jun 10, 2008 at 4:04 pm -
Hi, We've been making noises about dealing with TOAST tables as separate entities in autovacuum for some time now. So here's a proposal: Let's do it. That's about it :-) The only change of some ...
Alvaro Herrera
Jun 8, 2008 at 11:04 pm
Jun 9, 2008 at 7:14 pm -
Currently there are two modes of LWLock : SHARED and EXCLUSIVE Mostly you need to have EXCLUSIVE lock mode to make any changes, add, delete and SHARED if you are just reading it. Multiple backends ...
Jignesh K. Shah
Jun 6, 2008 at 4:22 pm
Jun 6, 2008 at 8:25 pm -
Hi, I keep seeing these files show up in the source tree in a VPATH build: ? src/interfaces/ecpg/compatlib/libecpg_compatddll.def ? src/interfaces/ecpg/ecpglib/libecpgddll.def ? ...
Alvaro Herrera
Jun 18, 2008 at 11:16 pm
Jul 17, 2008 at 9:18 pm -
[ after recovering from choking... ] Tom "spot" Callaway presents a vivid new image in this line: https://www.redhat.com/archives/fedora-devel-list/2008-June/msg01501.html So is that a "golf club ...
Tom Lane
Jun 30, 2008 at 4:57 am
Jul 1, 2008 at 11:13 pm -
Folks, I'm doing some analysis of PostgreSQL site traffic, and am being frequently hung up by the compile-time-fixed size of our regex cache (32 regexes, per MAX_CACHED_RES). Is there a reason why it ...
Josh Berkus
Jun 18, 2008 at 1:22 am
Jun 18, 2008 at 10:32 pm -
looking in my freshly installed 8.3.3, I see this in the postgresql.conf #client_encoding = sql_ascii # actually, defaults to database # encoding Now, certainly initdb can't know for sure what ...
Robert Treat
Jun 12, 2008 at 9:30 pm
Jun 13, 2008 at 4:15 pm -
I believe i have found a math bug/rounding problem with Money type when its used with SUM()... Postgresql 8.3.1 --------------- Background on the Problem-------------------- We have gl_trans table ...
Justin
Jun 7, 2008 at 10:08 pm
Jun 11, 2008 at 2:04 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 113 |
posts | 1,149 |
users | 145 |
website | postgresql.org... |
irc | #postgresql |
145 users for June 2008
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)