Search Discussions
-
Tom lane said over on the concurrent psql thread: If we do split them then there is going to be some added effort to maintain the commit fest queue. Bruce has made it pretty clear that he doesn't ...
Joshua D. Drake
Apr 9, 2008 at 2:29 am
Apr 16, 2008 at 6:41 pm -
There has been talk of the lessons we learned during this commit fest, but exactly what lessons did we learn? I am not clear on that so I assume others are not as well. What are we going to do ...
Bruce Momjian
Apr 14, 2008 at 4:29 pm
Jun 23, 2008 at 10:38 pm -
I have moved this discussion to hackers in hopes of getting more feedback, and moved the patch to a static URL: ftp://momjian.us/pub/postgresql/mypatches/wrap This patch adds a new '\pset format ...
Bruce Momjian
Apr 23, 2008 at 10:31 pm
May 8, 2008 at 5:08 pm -
I know there has been lots of versions and technical feedback related to this proposed feature. However, I have talked to Tom and neither of us see sufficient user request for this capability to add ...
Bruce Momjian
Apr 8, 2008 at 5:00 pm
Apr 10, 2008 at 7:58 pm -
The following two files specify the behaviour of the MERGE statement and how it will work in the world of PostgreSQL. In places, this supercedes my recent commentary on MERGE, particularly with ...
Simon Riggs
Apr 21, 2008 at 8:07 pm
Aug 15, 2010 at 7:57 am -
Hi, As you know, "SQL injection" is the main security problem of databases today. I think I found a solution: 'disabling literals'. Or you may call it 'enforcing the use of parameterized statements'. ...
Thomas Mueller
Apr 28, 2008 at 6:55 pm
May 5, 2008 at 8:00 pm -
Around <http://archives.postgresql.org/pgsql-patches/2008-01/msg00089.php it was proposed to truncate the psql welcome screen. What do you think about that? Personally, I'd get rid of it all, because ...
Peter Eisentraut
Apr 17, 2008 at 12:39 pm
Apr 22, 2008 at 3:04 pm -
I am impressed at the state of the May wiki patch queue: http://wiki.postgresql.org/wiki/CommitFest:May It is even tracking the psql wrap patch I am working on now. Magnus has started moving the ...
Bruce Momjian
Apr 19, 2008 at 3:40 pm
Jun 9, 2008 at 12:38 pm -
I just finished looking through the various threads about index AM changes that Bruce has been holding onto in the commit-fest queue. There seem to be the following issues: * Proposed change to have ...
Tom Lane
Apr 10, 2008 at 12:42 am
Apr 24, 2008 at 4:39 pm -
OK, I have spent some time generating and filtering typdefs via objdump on various platforms. I filtered them and Bruce's list to eliminate items not actually found in the sources thus: while read ...
Andrew Dunstan
Apr 20, 2008 at 9:37 pm
Mar 30, 2009 at 10:45 pm -
Well, I realized the idea of global prepared statements actually sucked, so I set on another approach thanks to ideas from this list, this is caching query plans. First, let's see if there is low ...
PFC
Apr 11, 2008 at 4:30 pm
Apr 15, 2008 at 7:58 am -
Hello, Attached is a patch for the default message from psql. Couple of things of note: 1. I removed the force wrapping, instead allowing the terminal to do it. This seems to work in X and well as on ...
Joshua D. Drake
Apr 21, 2008 at 8:17 pm
Apr 24, 2008 at 3:25 pm -
I compiled postgreSQL with 1kB block size and regresion test fails. Main problem is that output is correct but in different order. See attachment. I think affected test should contain order by ...
Zdenek Kotala
Apr 21, 2008 at 12:02 pm
May 2, 2008 at 8:07 am -
Hello, Could someone break out exactly what the process is "now" for submitting a patch? Last month I sent a patch for pg_dump which never got feedback (at least on thread). I just asked and alvaro ...
Joshua D. Drake
Apr 16, 2008 at 5:50 pm
Apr 19, 2008 at 6:40 pm -
It seems my fix for stat() broke cygwin, because it doesn't have dosmaperr() available. The way I see it there are two ways to fix this: 1) Don't apply the stat fix for cygwin. 2) Make our ...
Magnus Hagander
Apr 11, 2008 at 11:43 am
Jun 28, 2009 at 1:40 pm -
Hey all, I've run into a couple cases now where it would be helpful to easily assign an already-existing unique index as a primary key. Unless I completely missed something, there's no way to do this ...
Jonah H. Harris
Apr 9, 2008 at 12:00 am
May 12, 2008 at 5:25 pm -
Hi, Here's a proposal for COPY to support the T part of an ETL, that is adding the capability for COPY FROM to Transform the data it gets. The idea is quite simple: adding to COPY FROM the option to ...
Dimitri Fontaine
Apr 3, 2008 at 1:17 pm
Apr 8, 2008 at 5:08 pm -
I don't understand. If we call proc_exit(0) instead, it is the same as someone exiting the backend via PQfinish(). Well, with no movement on this TODO item since it was removed in 8.0, I am willing ...
Bruce Momjian
Apr 15, 2008 at 8:33 pm
Apr 17, 2008 at 8:58 pm -
We already support rewriting tables ... (albeit only one at a time, I admit. Doing it for more than one can cause deadlocks). Still, if the user wants to pay the cost, why should we prohibit it? ...
Alvaro Herrera
Apr 25, 2008 at 6:27 pm
Apr 28, 2008 at 11:49 am -
The last thread about Free Space Map evolved into discussion about whether the FSM and other kinds of auxiliary data should be stored within the heap pages, in "map forks", or auxiliary relfilenodes ...
Heikki Linnakangas
Apr 8, 2008 at 8:33 am
Apr 12, 2008 at 1:02 pm -
[ redirecting to -hackers since -patches isn't the place for general discussion of feature specifications ] Gregory Stark <stark@enterprisedb.com writes: This is still the latest API suggestion for ...
Tom Lane
Apr 8, 2008 at 9:11 pm
May 7, 2008 at 11:04 am -
Hi! I have sent a patch to pgsql-patches: http://archives.postgresql.org/pgsql-patches/2008-04/msg00050.php ...which adds \G command to psql client. The idea of \G command is to perform the query, ...
Dawid Kuroczko
Apr 3, 2008 at 12:45 pm
Apr 7, 2008 at 6:50 pm -
Moving to -hackers ... As far as i know, this behaviour isn't documented anywhere. In fact, the manual denies its existence: "The format of a psql command is the backslash, followed immediately by a ...
Brendan Jurd
Apr 3, 2008 at 6:04 pm
Apr 12, 2008 at 8:58 am -
It seems changes to the commit fest wiki pages are going to be overwritten accidently when editing the page concurrently. At least, this occured to me as i accidently removed entries done by Laurenz ...
Bernd Helmle
Apr 22, 2008 at 1:36 pm
Apr 22, 2008 at 6:01 pm -
This patch has been lingering around since Aug 2007. It has matured a lot and now calls libpq home. Unfortunately, ISTM that there is limited support for our proposal. We either pitched to the wrong ...
Andrew Chernow
Apr 15, 2008 at 1:31 pm
Apr 16, 2008 at 11:07 am -
[ Changing subject to draw people's attention ... ] Teodor Sigaev <teodor@sigaev.ru writes: Hmm, that's slightly more radical than I was considering, but it would simplify matters wouldn't it? The ...
Tom Lane
Apr 11, 2008 at 5:41 pm
Apr 14, 2008 at 8:31 pm -
Please see the attached patch. One change I made is to hold the SHARE lock on the page while ANALYZE is reading tuples from it. I thought it would be a right thing to do instead of repeatedly ...
Pavan Deolasee
Apr 1, 2008 at 7:37 am
Apr 7, 2008 at 8:11 am -
would seem like a good idea, no ? http://www.murrayc.com/blog/permalink/2008/04/25/postgresql-has-no-bugzilla/
Raphaël Jacquot
Apr 26, 2008 at 5:26 am
Apr 29, 2008 at 8:44 am -
I'm confused about the current state of the pgwin32_safestat stuff. Cygwin is now building happily, but MinGW is now broken on libpq. It looks like libpq now needs dirmod.o or maybe libpgport.a. What ...
Andrew Dunstan
Apr 13, 2008 at 5:10 pm
Apr 16, 2008 at 2:53 pm -
Right now it isn't possible to use file system snapshots a reliable backup if you are using multiple file systems for tablespaces because most systems don't allow the simultaneous snapshoting of ...
Bruce Momjian
Apr 7, 2008 at 6:45 pm
Apr 9, 2008 at 3:13 am -
I have now managed to investigate why some conversions of the PostgreSQL CVS repository to other formats are having trouble or are failing. Here, I am looking at git-cvsimport in particular. The ...
Peter Eisentraut
Apr 1, 2008 at 4:00 pm
Apr 2, 2008 at 11:20 pm -
Hi, One of the few parts of the core that is not localized is the ecpg. Attached is a patch that builds the basic infrastructure to make it possible. Besides that I worked on some strings to make ...
Euler Taveira de Oliveira
Apr 26, 2008 at 3:43 am
May 17, 2008 at 8:26 pm -
Over the last couple days I twice saw complaints like this during DROP DATABASE: WARNING: could not remove file or directory "base/80750/80825": No such file or directory WARNING: could not remove ...
Tom Lane
Apr 15, 2008 at 11:03 pm
Apr 18, 2008 at 6:53 am -
We are down to 12 feature freeze items (240 emails): http://momjian.us/cgi-bin/pgpatches Most are not ready to apply but require feedback to the author. -- Bruce Momjian <bruce@momjian.us ...
Bruce Momjian
Apr 7, 2008 at 3:34 pm
Apr 8, 2008 at 7:58 am -
I've been thinking about how to improve the planner's poor handling of variables in outer-join situations. Here are some past examples for motivation: ...
Tom Lane
Apr 16, 2008 at 1:21 am
Oct 17, 2008 at 5:35 pm -
For debugging the planner work I'm about to do, I'm expecting it will be useful to be able to get EXPLAIN to print the targetlist of each plan node, not just the quals (conditions) as it's ...
Tom Lane
Apr 17, 2008 at 4:34 pm
Jun 19, 2008 at 10:20 pm -
I attached patch which implemented page layout converter (PLC) hook. It is base stone for in-place upgrade. How it works: When PLC module is loaded, then for each page which does not have native page ...
Zdenek Kotala
Apr 15, 2008 at 10:48 am
May 17, 2008 at 8:43 pm -
I'm wondering if the mechanism used for sending signals between postmaster processes on Win32 is much more heavyweight that is necessary. Is there a reason not to call OpenThread on the target ...
James Mansion
Apr 20, 2008 at 1:22 pm
Apr 23, 2008 at 9:19 am -
From the "idle thoughts in the middle of the night" department: I don't know if this has come up before exactly, but is it possible that we could get a performance gain from building multiple indexes ...
Andrew Dunstan
Apr 1, 2008 at 12:21 pm
Apr 7, 2008 at 6:19 pm -
I think the agreement was that dblink_current_query was to be implemented on top of this. In fact I don't see any reason not to. Also, wasn't the name supposed to be client_query? -- Alvaro Herrera ...
Alvaro Herrera
Apr 4, 2008 at 6:48 pm
Apr 5, 2008 at 2:45 am -
Here's my attempt to remove the typename field from A_Const. There were a few places (notably flatten_set_variable_args() in guc.c, and typenameTypeMod() in parse_type.c) where the code expected to ...
Brendan Jurd
Apr 14, 2008 at 9:23 pm
Apr 28, 2008 at 9:07 pm -
It started with this query : EXPLAIN ANALYZE SELECT * FROM relations r JOIN nodes n ON (n.id=r.child_id) WHERE r.parent_id=16330; QUERY PLAN ...
PFC
Apr 22, 2008 at 10:09 am
Apr 24, 2008 at 4:08 pm -
I appreciate your positive comment Bruce. Credit must also go to Alvaro for supplying valuable feedback and encouragement offlist while I worked on those templates =) I wonder if we should namespace ...
Brendan Jurd
Apr 21, 2008 at 3:20 pm
Apr 21, 2008 at 6:46 pm -
-hackers, As I announced it a couple of months ago, apart from the boxes donated to PostgreSQLFr (affected to the web team IIRC), Continuent also donated 7 servers and a Gb/s switch to us for QA ...
Guillaume Smet
Apr 1, 2008 at 6:45 am
Apr 7, 2008 at 8:59 pm -
I tracked down the problem reported here: http://archives.postgresql.org/pgsql-admin/2008-04/msg00038.php What it boils down to is that equal() doesn't see these two Consts as equal: {CONST ...
Tom Lane
Apr 4, 2008 at 7:57 pm
Apr 4, 2008 at 10:57 pm -
Hey Postgres Hackers, this is my first time here, so... hi! I've written a quick patch against the head branch (8.4DEV, but it also works with 8.1.3 sources) to fix LDAP authentication support to ...
Stephen layland
Apr 26, 2008 at 1:10 am
Jun 26, 2008 at 2:54 am -
The buildfarm has shown several intermittent failures recently: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=heron&dt=2008-04-20%2000:06:01 ...
Tom Lane
Apr 27, 2008 at 6:15 am
Apr 28, 2008 at 2:26 pm -
I wonder if we could use this mechanism for cleaning up in case of failed CLUSTER, REINDEX or the like. I think these can leave dangling files around. -- Alvaro Herrera http://www.CommandPrompt.com/ ...
Alvaro Herrera
Apr 17, 2008 at 12:30 pm
Apr 18, 2008 at 7:09 am -
Dear PostGre developers, I'm working on Windows XP SP2 (stack limit set to 3500 kb) and deployed successfully my Java application (doing some external Web service calling) inside PostGre 8.3.0. ...
Alexander Wöhrer
Apr 12, 2008 at 6:56 pm
Apr 14, 2008 at 3:23 pm -
Hi, I notice that while doing bulk-loads that any errors detected by the backend arn't noticed by libpq until right at the end. Is this intentional? Looking at the code we have this comment in ...
Martijn van Oosterhout
Apr 16, 2008 at 8:45 pm
Jun 23, 2008 at 10:43 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 146 |
posts | 1,908 |
users | 146 |
website | postgresql.org... |
irc | #postgresql |
146 users for April 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)