FAQ

Search Discussions

159 discussions - 2,025 posts

  • This is a follow up to my old proposal here: http://archives.postgresql.org/pgsql-hackers/2008-06/msg00404.php Top pointed out a few problems here: ...
    Jeff DavisJeff Davis
    Jul 6, 2009 at 12:28 am
    Mar 11, 2010 at 7:02 pm
  • Hello, this is first public version of our DefaultACLs patch as described on http://wiki.postgresql.org/wiki/DefaultACL . It allows GRANT/REVOKE permissions to be inherited by objects based on schema ...
    Petr JelinekPetr Jelinek
    Jul 14, 2009 at 9:10 pm
    Oct 7, 2009 at 1:47 am
  • OK, here's the updated version of my machine-readable explain output patch. This needed heavy updating as a result of the changes that Tom asked me to make to the explain options patch, and the ...
    Robert HaasRobert Haas
    Jul 30, 2009 at 3:06 am
    Aug 13, 2009 at 7:00 am
  • I think we should try to do something about join_collapse_limit, from_collapse_limit, and geqo_threshold for 8.5. http://archives.postgresql.org/message-id/9134.1243289706@sss.pgh.pa.us ...
    Robert HaasRobert Haas
    Jul 7, 2009 at 5:30 am
    Jul 14, 2009 at 11:08 am
  • Here is the initial draft of SE-PostgreSQL specifications: http://wiki.postgresql.org/wiki/SEPostgreSQL_Draft I've described it from the scratch again with paying attention for the people knowing ...
    KaiGai KoheiKaiGai Kohei
    Jul 24, 2009 at 5:54 am
    Aug 4, 2009 at 11:05 pm
  • Per Dave Page's request of this morning, my CommitFest management application now has a real hostname (see subject line). I have also sent Dave an email with details of the install process and ...
    Robert HaasRobert Haas
    Jul 3, 2009 at 4:57 am
    Jul 13, 2009 at 5:11 am
  • Hello. Here's a patch(WIP) that implements INSERT .. RETURNING inside a CTE. Should apply cleanly against CVS head. The INSERT query isn't rewritten so rules and default values don't work. Recursive ...
    Marko TiikkajaMarko Tiikkaja
    Jul 7, 2009 at 8:37 pm
    Oct 10, 2009 at 8:43 am
  • This is a feature I would find useful, and I wanted to learn more about the database internals, so I thought I would give it a go as an exercise. I added 2 new index insert modes to support ...
    Dean RasheedDean Rasheed
    Jul 7, 2009 at 6:40 pm
    Jul 30, 2009 at 7:45 am
  • I'd like to return to the project I suggested here: http://archives.postgresql.org/message-id/18653.1239741426@sss.pgh.pa.us of getting rid of plpgsql's private lexer and having it use the core lexer ...
    Tom LaneTom Lane
    Jul 2, 2009 at 2:25 pm
    Jul 23, 2009 at 2:43 pm
  • How can a record be neither NULL or NOT NULL? try=# select ROW(1, NULL) IS NULL; ?column? ---------- f (1 row) try=# select ROW(1, NULL) IS NOT NULL; ?column? ---------- f (1 row) This makes it ...
    David E. WheelerDavid E. Wheeler
    Jul 23, 2009 at 10:19 pm
    Jul 28, 2009 at 7:22 pm
  • Rebased to correct for pg_indent changes. Applies cleanly. Compiles cleanly. Passes regression tests. Comments and format look good. No documentation changes needed. No regression test changes ...
    Kevin GrittnerKevin Grittner
    Jul 17, 2009 at 2:43 am
    Aug 7, 2009 at 8:30 pm
  • Hi, as asked by Michael Meskes, I have split up our ECPG patchset: 1. dynamic cursorname (DECLARE :cursorname ..., etc) 2. SQLDA support in Informix compat mode (C structure used for descriptor and ...
    Böszörményi ZoltánBöszörményi Zoltán
    Jul 15, 2009 at 5:18 pm
    Aug 17, 2009 at 9:31 am
  • I started looking at this patch and it looks pretty good as far as it goes. But I think we can do a lot more. It seems to me the cases where foreign key relationships exist are likely to be really ...
    Greg StarkGreg Stark
    Jul 17, 2009 at 1:02 am
    Mar 29, 2010 at 8:33 am
  • Howdy Hackers, Is there a published maintenance policy somewhere? Something that says for how long the project supports minor releases of PostgreSQL. For example, does 7.4 still get bug fixes and ...
    David E. WheelerDavid E. Wheeler
    Jul 6, 2009 at 7:37 pm
    Jul 13, 2009 at 1:57 pm
  • For a very long time I have thought that it would be useful to have some sort of navigation menu for the docs similar to what you get with doxygen. I had a brief look at it today but I am lost for a ...
    Andrew DunstanAndrew Dunstan
    Jul 14, 2009 at 8:24 pm
    Dec 11, 2009 at 2:07 pm
  • Folks, There's been a lot of discussion/argument around how to handle the last commitfest, but there seems to be a total consensus that we want to have the first CF on July 15th. I'd like Robert Haas ...
    Josh BerkusJosh Berkus
    Jul 2, 2009 at 12:21 am
    Jul 12, 2009 at 2:40 am
  • Tsutomu YamadaTsutomu Yamada
    Jul 14, 2009 at 11:02 am
    Aug 11, 2009 at 3:14 pm
  • Since I didn't get completely shot out of the water and a couple people seemed to think it was helpful, I'm submitting this patch for consideration in the next commitfest. This patch changes plpgsql ...
    Steve PrenticeSteve Prentice
    Jul 30, 2009 at 8:37 pm
    Sep 21, 2009 at 4:11 am
  • For reasons that can only be described as masochistic, I took it upon myself to merge the Hot Standby patch up to CVS HEAD during my vacation last week. Here's what I did: 1. Downloaded ...
    Robert HaasRobert Haas
    Jul 15, 2009 at 1:12 am
    Aug 27, 2009 at 7:16 pm
  • Andrew GierthAndrew Gierth
    Jul 16, 2009 at 2:35 pm
    Aug 24, 2009 at 9:46 pm
  • Pgbench is a famous tool to measure postgres performance, but nowadays it does not work well because it cannot use multiple CPUs. On the other hand, postgres server can use CPUs very well, so the ...
    Itagaki TakahiroItagaki Takahiro
    Jul 8, 2009 at 5:25 am
    Jul 30, 2009 at 9:28 am
  • Friendly greetings ! I'd like to have a higher compression ratio on our base. From pg 8.3 documentation : The TOAST code is triggered only when a row value to be stored in a table is wider than ...
    Laurent LabordeLaurent Laborde
    Jul 17, 2009 at 8:17 am
    Jul 29, 2009 at 5:11 pm
  • [ CC to hackers.] Wow, that is also surprising. I am going to have to run some tests to find the cause, but it certainly is not intended. -- Bruce Momjian <bruce@momjian.us http://momjian.us ...
    Bruce MomjianBruce Momjian
    Jul 13, 2009 at 10:30 pm
    Jul 20, 2009 at 7:02 pm
  • Hi Robert, Hi all, The patch applies cleanly and works as intended - no surprise here. After the changes the documentation is at least as easy to understand as before and the code changes look ...
    Andres FreundAndres Freund
    Jul 16, 2009 at 8:49 am
    Jul 16, 2009 at 8:23 pm
  • I updated Sampling profiler patch to be applied to HEAD cleanly. Basic concept of the patch is same as DTrace probes: Call pgstat_push_condition(condition) before a operation and call ...
    Itagaki TakahiroItagaki Takahiro
    Jul 14, 2009 at 9:47 am
    Jul 23, 2009 at 7:56 am
  • Hi, one of our clients wants to port their application suite from Informix to PostgreSQL, they use constructs like SELECT * INTO :tablerec FROM table ... where "tablerec" mirrors the table fields in ...
    Boszormenyi ZoltanBoszormenyi Zoltan
    Jul 17, 2009 at 11:31 am
    Aug 14, 2009 at 7:53 pm
  • Our manual says we can use pgcrypto functions or encrypted filesystems for data encryption. http://www.postgresql.org/docs/8.4/static/encryption-options.html However, they are not always the best ...
    Itagaki TakahiroItagaki Takahiro
    Jul 7, 2009 at 8:35 am
    Jul 13, 2009 at 7:16 pm
  • Thank you to everyone who commented in the parent thread. Robert feels we're ready to go ahead and commission the new commitfest app for the upcoming 'fest beginning 15 July, and he's asked me to do ...
    Brendan JurdBrendan Jurd
    Jul 9, 2009 at 4:06 pm
    Jul 18, 2009 at 2:04 am
  • For those of you who weren't involved in the Ottawa developer meeting, I think we should start by explaining that beginning with the 8.5 development cycle, we are planning to make regular alpha ...
    Peter EisentrautPeter Eisentraut
    Jul 13, 2009 at 7:37 pm
    Jul 14, 2009 at 8:29 pm
  • Oleg BartunovOleg Bartunov
    Jul 14, 2009 at 7:13 pm
    Aug 14, 2009 at 10:52 am
  • Hi, On Fri, Jul 3, 2009 at 1:32 PM, Fujii Masaowrote: Here is the updated version of Synch Rep patch. I adjusted the patch against CVS HEAD, fixed some bugs and updated the documents. The attached ...
    Fujii MasaoFujii Masao
    Jul 14, 2009 at 3:08 pm
    Jul 17, 2009 at 9:37 am
  • Implementing index-only scans requires a few changes: 1. indexam API changes There's currently no way to return data from an index scan. You only get TID pointers to heap tuples. 2. Make visibility ...
    Heikki LinnakangasHeikki Linnakangas
    Jul 13, 2009 at 7:40 am
    Jan 9, 2010 at 8:05 am
  • All, Gabrielle of PDXPUG volunteered that PUG to hold a "code sprint" in coordination with a commitfest sometime soon. For that event, the PDXPUG members would take on a dozen or so patches, compile ...
    Josh BerkusJosh Berkus
    Jul 10, 2009 at 11:09 pm
    Sep 14, 2009 at 11:42 pm
  • All, Well, after an hour of tinkering with docbook DTDs and openjade I've given up on building docs for the patch I was reviewing on my Mac. If I'm encountering this difficulty building docs, so are ...
    Josh BerkusJosh Berkus
    Jul 16, 2009 at 6:48 pm
    Aug 9, 2009 at 1:10 am
  • Sorry to bring this up, I know you've been fighting about XML for a while. Currently, I am using XML2 functionality and have tried to get the newer XPath function to work similarly, but can't quite ...
    Mark L. WoodwardMark L. Woodward
    Jul 28, 2009 at 7:42 pm
    Jul 31, 2009 at 3:14 am
  • [ Email moved to hackers list.] Wow, I didn't test large objects specifically, and I am confused why there would be a count discrepancy. I will need to do some research unless someone else can guess ...
    Bruce MomjianBruce Momjian
    Jul 13, 2009 at 10:27 pm
    Jul 20, 2009 at 10:07 pm
  • Hi folks, Today I got bitten a bit, trying to write C function for postgresql, that also includes some of company's internal stuff. Needles to say, our stuff defines BOOL, as well as postgresql's c.h ...
    Grzegorz JaskiewiczGrzegorz Jaskiewicz
    Jul 16, 2009 at 11:03 am
    Jul 16, 2009 at 10:45 pm
  • Hi, While trying to build a custom error reporting function for one of our clients we came across the fact that PL/Perl doesn't set errcontext that we relied on to get the traceback of running ...
    Alexey KlyukinAlexey Klyukin
    Jul 21, 2009 at 2:39 pm
    Sep 16, 2009 at 1:58 pm
  • Is there a reason we force plpgsql IN parameters to constant? The reason I ask is because having them mutable would go a long way in easing a port from Informix's SPL. For better or worse, we have a ...
    Steve PrenticeSteve Prentice
    Jul 30, 2009 at 12:05 am
    Jul 30, 2009 at 11:59 pm
  • Hello, I did some test - median via window function - I found probably some bad optimised code. I found two methods - Celko and Itzik Ben-Gan. Ben-Gan methoud should to be faster - there is one sort ...
    Pavel StehulePavel Stehule
    Jul 15, 2009 at 11:30 am
    Jul 29, 2009 at 5:25 pm
  • On Win2k3 Std SP2, the service won't start once I've applied the patch. In the log, I get: %t LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall. ...
    Kevin FieldKevin Field
    Jul 29, 2009 at 6:20 pm
    Aug 6, 2009 at 7:30 am
  • Hi, http://archives.postgresql.org/pgsql-hackers/2009-07/msg00191.php In line with Robert's suggestion, I submit non-blocking pqcomm patch as a self-contained one. This patch provides support for ...
    Fujii MasaoFujii Masao
    Jul 3, 2009 at 7:37 am
    Jul 29, 2009 at 12:24 pm
  • My Cygwin buildfarm member started failing (hanging, in fact) recently. It seems to hang consistently in join.sql and the only way I can get it to complete is to kill the backend fairly violently. ...
    Andrew DunstanAndrew Dunstan
    Jul 23, 2009 at 12:29 am
    Jul 24, 2009 at 2:57 pm
  • Hi, This is a preliminary request for comments on obtaining a function call stack. I've been trying to dodge the issue by exporting elog.c internal state (errcontext), but that turns out to be ...
    Alvaro HerreraAlvaro Herrera
    Jul 13, 2009 at 6:57 pm
    Jul 14, 2009 at 3:24 am
  • Hello I have one idea, that should simplify string to char array transformation. The base is idea: between every char is empty string, so empty string is regular separator for string_to_array ...
    Pavel StehulePavel Stehule
    Jul 25, 2009 at 3:40 am
    Jul 27, 2009 at 6:00 pm
  • We just ran into a case where we were performing two concurrent index builds on two different tables in two different schemas in the same database (no relational constraints between them). One of the ...
    Theo SchlossnagleTheo Schlossnagle
    Jul 11, 2009 at 4:02 am
    Jul 12, 2009 at 3:52 pm
  • I've been wondering whether anyone else would want to use the functions we wrote to extract text from PDF documents stored in bytea columns. If so, I would need to sort out the problems I've been ...
    Kevin GrittnerKevin Grittner
    Jul 2, 2009 at 8:20 pm
    Jul 3, 2009 at 7:19 pm
  • On the admin list there was a request for an application name column in pg_stat_activity. http://archives.postgresql.org/pgsql-admin/2009-07/msg00095.php This is available in a lot of other DBMS ...
    Kevin GrittnerKevin Grittner
    Jul 16, 2009 at 7:08 pm
    Aug 10, 2009 at 9:52 am
  • Folks, At this point, SE-PostgreSQL has taken up a *lot* of community resources, not to mention an enormous and doubtless frustrating amount of Kohei-san's time and effort, thus far without a single ...
    David FetterDavid Fetter
    Jul 18, 2009 at 4:04 pm
    Jul 24, 2009 at 6:00 am
  • I took the 8.4.0 release tarball and tried to build it on one of our production servers which is currently running 8.3.7. We routinely build multiple versions of PostgreSQL on a machine, using ...
    Kevin GrittnerKevin Grittner
    Jul 17, 2009 at 10:50 pm
    Jul 20, 2009 at 3:53 am
Group Navigation
period‹ prev | Jul 2009 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions159
posts2,025
users156
websitepostgresql.org...
irc#postgresql

156 users for July 2009

Tom Lane: 320 posts Robert Haas: 208 posts Kevin Grittner: 99 posts Andrew Dunstan: 89 posts Peter Eisentraut: 85 posts Alvaro Herrera: 72 posts Bruce Momjian: 61 posts Greg Stark: 59 posts David E. Wheeler: 46 posts Jaime Casanova: 44 posts Jeff Davis: 43 posts Pavel Stehule: 43 posts Andres Freund: 40 posts Dimitri Fontaine: 40 posts Heikki Linnakangas: 36 posts KaiGai Kohei: 34 posts Fujii Masao: 31 posts Brendan Jurd: 29 posts Josh Berkus: 28 posts Magnus Hagander: 26 posts
show more
Archives