Search Discussions

166 discussions - 2,476 posts

  • Hi, PFA version 3 of the ALTER EXTENSION PATCH, cleaned and merged against recent HEAD and extension's branch from which I just produced the v30 patch. It includes a way to upgrade "from null", that ...
    Dimitri FontaineDimitri Fontaine
    Feb 1, 2011 at 6:21 pm
    Feb 17, 2011 at 4:03 pm
  • Hello, Per: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=607109 It seems we may have a problem to consider. As far as I know, we are the only major platform that supports libedit but our default ...
    Joshua D. DrakeJoshua D. Drake
    Feb 10, 2011 at 10:45 pm
    Feb 19, 2011 at 8:07 pm
  • Well, good news all round. v17 implements what I believe to be the final set of features for sync rep. This one I'm actually fairly happy with. It can be enjoyed best at DEBUG3. The patch is very ...
    Simon RiggsSimon Riggs
    Feb 19, 2011 at 12:06 am
    Mar 3, 2011 at 1:19 pm
  • hello everbody, we have spent some time in finally attacking cross column correlation. as this is an issue which keeps bugging us for a couple of applications (some years). this is a WIP patch which ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Feb 22, 2011 at 7:49 pm
    Mar 2, 2011 at 12:30 pm
  • hi, it seems that PredicateLockTupleRowVersionLink sometimes create a loop of targets (it founds an existing 'newtarget' whose nextVersionOfRow chain points to the 'oldtarget') and it later causes ...
    YAMAMOTO TakashiYAMAMOTO Takashi
    Feb 10, 2011 at 8:48 am
    Apr 11, 2011 at 6:40 pm
  • Hello list, I split this out of the synchronous replication patch for independent review. I'm dashing out the door, so I haven't put it on the CF yet or anything, but I just wanted to get it out ...
    Daniel FarinaDaniel Farina
    Feb 11, 2011 at 6:29 pm
    Mar 31, 2011 at 7:21 am
  • Hello, I've been playing with 'native XML' for a while and now wondering if further development of such a feature makes sense for Postgres. (By not having brought this up earlier I'm taking the ...
    Feb 26, 2011 at 11:39 pm
    Mar 10, 2011 at 3:36 pm
  • I've run into a small infelicity that was introduced by our recent round of redesign of the extensions feature. Specifically, if we have an installation script that is named like hstore-1.0.sql.in, ...
    Tom LaneTom Lane
    Feb 12, 2011 at 4:14 pm
    Feb 16, 2011 at 11:03 pm
  • It just occurred to me that the extensions patch thoroughly breaks pg_upgrade, because pg_upgrade imagines that it can control the specific OIDs assigned to certain SQL objects such as data types. ...
    Tom LaneTom Lane
    Feb 8, 2011 at 4:54 pm
    Feb 10, 2011 at 4:59 pm
  • Why did you change the default to on? This would surprise people who are used to PITR. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
    Fujii MasaoFujii Masao
    Feb 9, 2011 at 3:50 am
    Mar 24, 2011 at 9:44 pm
  • New patch. All known TODO items are closed, although I should do a cleanup pass over the code and docs. Fixed in this patch: * Many documentation improvements * Added INT8RANGE * Renamed PERIOD[TZ] - ...
    Jeff DavisJeff Davis
    Feb 6, 2011 at 6:49 am
    Mar 11, 2011 at 5:48 pm
  • The CommitFest application currently reflects 17 remaining patches for CommitFest 2011-01. 1. Change pg_last_xlog_receive_location not to move backwards. We don't have complete consensus on what to ...
    Robert HaasRobert Haas
    Feb 18, 2011 at 10:47 pm
    Feb 27, 2011 at 3:23 am
  • Why do the extension load files need two dashes, like xml2--1.0.sql? Why isn't one enough?
    Peter EisentrautPeter Eisentraut
    Feb 14, 2011 at 1:45 pm
    Feb 17, 2011 at 2:03 pm
  • This discussion reveals that it's time to start making some discussions about what can be accomplished for 9.1 and what must be postponed to 9.2. The big ones I think we should postpone are: - Range ...
    Robert HaasRobert Haas
    Feb 8, 2011 at 3:37 am
    Feb 10, 2011 at 6:25 pm
  • This has broken the buildfarm :-( perl ppport.h reports: *** WARNING: Uses HeUTF8, which may not be portable below perl 5.11.0, even with 'ppport.h' Experimentation on a CentOS machine suggests we ...
    Andrew DunstanAndrew Dunstan
    Feb 7, 2011 at 1:02 am
    Nov 26, 2011 at 5:23 pm
  • Looks like the function get_actual_variable_range() was written with the knowledge that virtual/hypothetical indexes may exist, but the assumption seems wrong. One one hand ...
    Gurjeet SinghGurjeet Singh
    Feb 11, 2011 at 8:44 pm
    Feb 23, 2011 at 5:52 pm
  • Do we want empty ranges? The philosophy is that they are essentially the "zero" value of any range type. Like the number zero, it allows closure over operations that would otherwise return an error. ...
    Jeff DavisJeff Davis
    Feb 11, 2011 at 6:11 pm
    Feb 14, 2011 at 4:16 pm
  • I had what seems to me a remarkably good idea, though maybe someone else can spot a problem with it. Given that we've decided to run the modifying sub-queries all with the same command counter ID, ...
    Tom LaneTom Lane
    Feb 25, 2011 at 3:00 pm
    Feb 27, 2011 at 6:57 pm
  • I've been experimenting with dump/reload of 9.0 contrib-using databases into 9.1 and then applying CREATE EXTENSION FROM to update the contrib modules to extension style. There are some cases that ...
    Tom LaneTom Lane
    Feb 16, 2011 at 12:10 am
    Feb 18, 2011 at 8:23 pm
  • [this time from the right address - apologies if we get a duplicate] PostgreSQL Experts Inc has a client with a 9.0.2 streaming replication server that somehow becomes wedged after running for some ...
    Andrew DunstanAndrew Dunstan
    Feb 18, 2011 at 7:16 pm
    Apr 26, 2011 at 9:48 pm
  • The wCTE patch refers to the feature it's adding as "DML WITH". I'm still pretty unhappy with that terminology. In my view of the world, "DML" includes SELECT as well as INSERT/UPDATE/DELETE. The ...
    Tom LaneTom Lane
    Feb 24, 2011 at 4:22 pm
    Feb 28, 2011 at 10:13 am
  • Hi, I am (ab)using a PostgreSQL database (with PostGIS extension) in a large data processing job - each day, I load several GB of data, run a lot of analyses on it, and then throw everything away ...
    Frederik RammFrederik Ramm
    Feb 14, 2011 at 2:56 pm
    Apr 15, 2011 at 2:19 am
  • Hi, Actaully one more POD left it's aclitem :). In Java for e.g. it is used to obtain column priviliges, I assume some folks may want to use it too. I tested only recv :-( Acually I don't know if ...
    Radosław SmoguraRadosław Smogura
    Feb 22, 2011 at 9:33 pm
    Feb 24, 2011 at 8:01 pm
  • Revisiting this, it occurred to me that I could achieve what I need of we extend the proposed API a bit. Currently, it has: extern CopyState BeginCopyFrom(Relation rel, const char *filename, List ...
    Andrew DunstanAndrew Dunstan
    Feb 4, 2011 at 12:49 am
    Feb 9, 2011 at 6:30 pm
  • I find that pg_upgrade fails in HEAD when asked to do a 9.1-to-9.1 upgrade of the regression database. It gets to this bit of the restore script: CREATE TABLE test_tbl2 OF public.test_type2; -- For ...
    Tom LaneTom Lane
    Feb 9, 2011 at 11:43 pm
    Apr 27, 2011 at 7:52 pm
  • I'm investigating the possibility of developing a utility function for our C++ client library, libpqxx, that produces array literals that can be used in prepared statements. This problem appears to ...
    Peter GeogheganPeter Geoghegan
    Feb 23, 2011 at 4:17 am
    Feb 23, 2011 at 9:19 pm
  • If you see one, then I accept one was there. I didn't see one, and a full make distclean and re-compile doesn't show a compiler warning for that either. So I guess I'm doing something wrong, on this ...
    Simon RiggsSimon Riggs
    Feb 17, 2011 at 8:30 am
    Feb 17, 2011 at 9:02 pm
  • Better late than never (or?), here's the final cleanup of pg_streamrecv for moving into the main distribution, per discussion back in late dec or early jan. It also includes the "stream logs in ...
    Magnus HaganderMagnus Hagander
    Feb 18, 2011 at 10:02 am
    Aug 16, 2011 at 2:51 pm
  • Here's where I think we are with this CommitFest. We have committed 45 patches and returned with feedback or rejected 23. There are 30 remaining patches, every single one of which has been reviewed. ...
    Robert HaasRobert Haas
    Feb 14, 2011 at 4:28 pm
    Feb 18, 2011 at 5:35 am
  • There are some things that the current extensions patch leaves indeterminate during a dump and reload cycle, which strikes me as a bad thing. One is ownership. Since we don't record the identity of ...
    Tom LaneTom Lane
    Feb 7, 2011 at 4:01 pm
    Feb 8, 2011 at 9:25 am
  • WIP patch of statistics collection for arrays is attached. It generally copies statistics collection for tsvector, but there are following differencies: 1) Default comparison, hash and equality ...
    Alexander KorotkovAlexander Korotkov
    Feb 23, 2011 at 3:00 pm
    Nov 29, 2011 at 3:03 am
  • I've been thinking about the problem of $SUBJECT, and while I know it's too early to think seriously about any 9.2 development, I want to get my thoughts down in writing while they're fresh in my ...
    Robert HaasRobert Haas
    Feb 17, 2011 at 4:02 am
    Jun 9, 2011 at 4:38 pm
  • I've been poking at the FDW stuff and file_fdw, and I find myself dissatisfied with the way that the EXPLAIN support is designed, namely that we have to compute a string at plan time to be displayed ...
    Tom LaneTom Lane
    Feb 20, 2011 at 12:02 am
    Feb 21, 2011 at 8:19 pm
  • I think this patch missed the deadline for the current CommitFest. It's true that it was posted to the list in time, but it's just madness to think we can do review in a meaningful way and get done ...
    Robert HaasRobert Haas
    Feb 8, 2011 at 3:46 am
    Feb 17, 2011 at 9:43 pm
  • Hackers, With regard to this (very welcome) commit: I just want to emphasize that this needs to be highlighted as a compatibility change in the release notes. As an example, I currently have this ...
    David E. WheelerDavid E. Wheeler
    Feb 10, 2011 at 11:28 pm
    Feb 12, 2011 at 2:02 am
  • Recently two systems here have suffered severely with excessive temporary file creation during query execution. In one case it could have been avoided by more stringent qa before application code ...
    Mark KirkwoodMark Kirkwood
    Feb 18, 2011 at 3:17 am
    Mar 9, 2011 at 11:17 pm
  • As I work through the extensions patch, the aspect of it that I like the least is the NO USER DATA clause and related functions. I think it's badly designed, badly implemented, and doesn't solve the ...
    Tom LaneTom Lane
    Feb 6, 2011 at 6:23 pm
    Feb 7, 2011 at 5:58 pm
  • Hi, this is the first time that I post here, so if I wrong please don't kill me ... I see that pg_terminate_backend and pg_cancel_backend can be execute only by admin users. This approach seems to be ...
    Torello QuerciTorello Querci
    Feb 14, 2011 at 12:10 pm
    Jul 2, 2011 at 12:31 pm
  • Hackers, Is it possible to modify the default tsearch parser so that / doesn't get lexed as a "file" token? That is, instead of this: try=# select * from ts_debug('simple'::regconfig, 'w/d'); alias │ ...
    David E. WheelerDavid E. Wheeler
    Feb 14, 2011 at 10:45 pm
    Feb 17, 2011 at 7:57 pm
  • This is another bit of the syncrep patch split out. I will revisit the replication timeout one Real Soon, I promise -- but I have a couple things to do today that may delay that until the evening. ...
    Daniel FarinaDaniel Farina
    Feb 12, 2011 at 10:11 pm
    Feb 16, 2011 at 7:28 am
  • Perhaps we should see about putting something in .git/hooks/pre-commit so people can focus on more substantive matters. Is there some kind of cross-platform way to do this? I'm thinking that given ...
    David FetterDavid Fetter
    Feb 9, 2011 at 4:01 pm
    Mar 28, 2011 at 8:10 pm
  • psql has the ability to execute commands from a file, but if one wishes to develop and provide a modularized set of sql files, then psql is not very helpful because the \i command can open file paths ...
    Gurjeet SinghGurjeet Singh
    Feb 24, 2011 at 11:32 pm
    Mar 10, 2011 at 5:59 am
  • Hi, I believe we have a case where not holding off interrupts while doing a malloc() can cause a deadlock due to system or libc level locking. In this case, a pg_ctl stop in fast mode was resorted to ...
    Nikhil SontakkeNikhil Sontakke
    Feb 28, 2011 at 12:10 pm
    Mar 1, 2011 at 11:43 pm
  • [moving to -hackers with BC to -general] Dimitri Fontaine wrote: http://www.pgsql.cz/index.php/PL_toolbox_%28en%29#Record.27s_functions Thanks. In the absence of an earlier response, though, I went ...
    Kevin GrittnerKevin Grittner
    Feb 22, 2011 at 10:32 pm
    Feb 23, 2011 at 8:45 pm
  • Hi! The PostgreSQL Infrastructure Team will be performing scheduled maintenance on the server that is hosting gitmaster.postgresql.org the coming sunday, Feb 13th. While we expect this to only cause ...
    Magnus HaganderMagnus Hagander
    Feb 8, 2011 at 6:52 pm
    Feb 14, 2011 at 10:02 pm
  • Hi. Which operations invoke the sorting algorithms implemented in the sorting module (tuplesort.c) ? Of course, one of those operations invoking sorting is the ORDER BY clause and the DISTINCT too. ...
    Feb 10, 2011 at 10:48 pm
    Feb 12, 2011 at 7:05 pm
  • From what I have checked, all work on making postgresql compile on new platforms should be posted to this list, so here it goes. The attached patch (also available at ...
    Feb 27, 2011 at 8:25 pm
    Mar 3, 2011 at 12:14 pm
  • Thanks to Noah Misch's review of the keylock patch I noticed that pageinspect's heap_page_items(bytea) function returns infomask and infomask2 as smallint (signed). But the fields in the tuple header ...
    Alvaro HerreraAlvaro Herrera
    Feb 14, 2011 at 7:49 pm
    Feb 25, 2011 at 10:19 pm
  • Just patch for missing procedures for void send/recv Regards, Radek
    Radosław SmoguraRadosław Smogura
    Feb 20, 2011 at 10:20 am
    Feb 22, 2011 at 6:09 pm
  • There are two issues I'd like to discuss related to constructing range types from other values. 1. The obvious constructor would be: range(1, 10) But is that [1, 10), (1, 10], (1, 10), or [1, 10]? We ...
    Jeff DavisJeff Davis
    Feb 9, 2011 at 5:56 am
    Feb 10, 2011 at 7:45 pm
Group Navigation
period‹ prev | Feb 2011 | next ›
Group Overview
grouppgsql-hackers @

149 users for February 2011

Robert Haas: 396 posts Tom Lane: 337 posts Dimitri Fontaine: 106 posts Bruce Momjian: 105 posts Kevin Grittner: 95 posts Andrew Dunstan: 85 posts David E. Wheeler: 82 posts Stephen Frost: 76 posts Simon Riggs: 67 posts Heikki Linnakangas: 61 posts Peter Eisentraut: 60 posts Itagaki Takahiro: 58 posts Magnus Hagander: 57 posts Josh Berkus: 42 posts Alvaro Herrera: 41 posts Jeff Davis: 38 posts Noah Misch: 37 posts Fujii Masao: 36 posts Jan Urbański: 32 posts Alex Hunsaker: 28 posts
show more