FAQ

PostgreSQL > pgsql-hackers > April 2008

Search Discussions

146 discussions - 1,908 posts

  • 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. DrakeJoshua 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 MomjianBruce 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 MomjianBruce 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 MomjianBruce 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 RiggsSimon 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 MuellerThomas 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 EisentrautPeter 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 MomjianBruce 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 LaneTom 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 DunstanAndrew 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 ...
    PFCPFC
    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. DrakeJoshua 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 KotalaZdenek 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. DrakeJoshua 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 HaganderMagnus 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. HarrisJonah 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 FontaineDimitri 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 MomjianBruce 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 HerreraAlvaro 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 LinnakangasHeikki 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 LaneTom 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 KuroczkoDawid 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 JurdBrendan 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 HelmleBernd 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 ChernowAndrew 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 LaneTom 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 DeolaseePavan 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 JacquotRaphaë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 DunstanAndrew 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 MomjianBruce 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 EisentrautPeter 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 OliveiraEuler 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 LaneTom 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 MomjianBruce 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 LaneTom 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 LaneTom 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 KotalaZdenek 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 MansionJames 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 DunstanAndrew 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 HerreraAlvaro 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 JurdBrendan 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 ...
    PFCPFC
    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 JurdBrendan 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 SmetGuillaume 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 LaneTom 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 laylandStephen 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 LaneTom 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 HerreraAlvaro 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öhrerAlexander 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 OosterhoutMartijn van Oosterhout
    Apr 16, 2008 at 8:45 pm
    Jun 23, 2008 at 10:43 pm
Apr 2008
123
Group Navigation
period‹ prev | Apr 2008 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions146
posts1,908
users146
websitepostgresql.org...
irc#postgresql

146 users for April 2008

Tom Lane: 316 posts Bruce Momjian: 200 posts Alvaro Herrera: 140 posts Joshua D. Drake: 115 posts Gregory Stark: 111 posts Andrew Dunstan: 86 posts Brendan Jurd: 59 posts Magnus Hagander: 54 posts Andrew Chernow: 46 posts Heikki Linnakangas: 46 posts Peter Eisentraut: 42 posts Simon Riggs: 36 posts Martijn van Oosterhout: 34 posts Decibel!: 29 posts Aidan Van Dyk: 28 posts PFC: 28 posts Merlin Moncure: 24 posts Tom Dunstan: 24 posts Greg Smith: 17 posts Zdenek Kotala: 17 posts
show more
Archives