FAQ

Search Discussions

156 discussions - 2,061 posts

  • It appears that the git conversion of the CVS repository is seriously screwed up. For example, if you look at this: ...
    Robert HaasRobert Haas
    Aug 17, 2010 at 7:11 pm
    Sep 10, 2010 at 5:04 pm
  • Attached is a WIP patch that allows enums to be extended with additional labels arbitrarily. As previously discussed, it works by adding an explicit sort order column to pg_enum. It keeps track of ...
    Andrew DunstanAndrew Dunstan
    Aug 23, 2010 at 9:35 am
    Nov 14, 2010 at 8:58 pm
  • Yes, it should. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
    Heikki LinnakangasHeikki Linnakangas
    Aug 27, 2010 at 8:15 am
    Sep 13, 2010 at 6:02 pm
  • Hello I am sending a prototype implementation of functions median and percentile. This implementation is very simple and I moved it to contrib for this moment - it is more easy maintainable. Later ...
    Pavel StehulePavel Stehule
    Aug 19, 2010 at 11:00 am
    Oct 14, 2010 at 12:23 pm
  • [moving to -hackers] Bruce pointed out yet another report of this problem to me: http://archives.postgresql.org/pgsql-general/2010-08/msg00550.php After some discussion with Magnus, I think what is ...
    Robert HaasRobert Haas
    Aug 23, 2010 at 2:04 pm
    Sep 29, 2010 at 2:24 pm
  • Hi Pavel, Currently your patch isn't applying to head, from the looks of things a function signature has changed. Can you update your patch please? Also, having had a read through the patch itself I ...
    Mike FowlerMike Fowler
    Aug 1, 2010 at 10:04 pm
    Feb 18, 2011 at 10:59 pm
  • Hackers, A while ago, I asked if .0 releases could be versioned with three digits instead of two. That is, it would be "8.4.0" instead of "8.4". This is to make the format consistent with maintenance ...
    David E. WheelerDavid E. Wheeler
    Aug 20, 2010 at 6:13 pm
    Aug 25, 2010 at 2:17 pm
  • Hello everyone, I'm interested in benchmarking synchronous replication, to see how performance degrades compared to asynchronous streaming replication. I browsed through the archive of emails, but ...
    Fazool meinFazool mein
    Aug 31, 2010 at 9:34 pm
    Sep 15, 2010 at 11:58 pm
  • Here is a patch for host name support in pg_hba.conf. I have reviewed various past threads about this, and there appeared to have been a 50/50 split of for and against reverse lookup. I went with the ...
    Peter EisentrautPeter Eisentraut
    Aug 9, 2010 at 6:49 pm
    Oct 15, 2010 at 8:03 pm
  • Hello I am returning back to string functions. For me, the most important function isn't commited still. There was discussion about "format" or "sprintf" fuction. So I'll do a small resume. goal: to ...
    Pavel StehulePavel Stehule
    Aug 30, 2010 at 11:02 am
    Oct 18, 2010 at 5:47 pm
  • Well, it'd take an initdb to get rid of it. In the past we've avoided forcing initdb post-beta1 unless it was Really Necessary. OTOH, we seem to be in the mode of encouraging beta testers to test ...
    Tom LaneTom Lane
    Aug 4, 2010 at 7:11 pm
    Aug 5, 2010 at 9:02 pm
  • (Magnus and pghackers, I've included you in this email, since it appears to be PostgreSQL bug. The example below is general, and not specific to Glue Finance database model. Feel free to share it ...
    Joel JacobsonJoel Jacobson
    Aug 20, 2010 at 1:40 pm
    Aug 26, 2010 at 9:19 am
  • At PGCon, we discussed the possibility that a minimal SE-PostgreSQL implementation would need little more than a hook in ExecCheckRTPerms() [which we've since added] and a security label facility ...
    Robert HaasRobert Haas
    Aug 6, 2010 at 3:03 pm
    Aug 28, 2010 at 9:48 am
  • There's an interesting buildfarm failure here: http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=polecat&dt=2010-08-10%2023:46:10 It appears to me that this was caused by the concurrent run of ...
    Tom LaneTom Lane
    Aug 11, 2010 at 4:42 am
    Aug 12, 2010 at 2:47 pm
  • All, This is something I'd swear we fixed around 8.3.2. However, I'm seeing it again in production, and was wondering if anyone could remember what the root cause was and how we fixed it. The problem ...
    Josh BerkusJosh Berkus
    Aug 16, 2010 at 6:25 pm
    Aug 24, 2010 at 1:33 pm
  • Looking through Pavel's string_to_array patch, I notice that the new version of string_to_array returns an empty (zero-element) array when the input string is of zero length, whereas the traditional ...
    Tom LaneTom Lane
    Aug 10, 2010 at 6:42 pm
    Aug 12, 2010 at 7:03 am
  • Attached is a ZIP file with the diffs generated when converting the cvs repo to git based off a cvs snapshot from this morning. It contains a diff file for every branch and every tag present. (If a ...
    Magnus HaganderMagnus Hagander
    Aug 16, 2010 at 5:27 pm
    Aug 17, 2010 at 6:16 pm
  • Here is a small prototype for a query progress indicator. Past discussions seemed to indicate that the best place to report this would be in pg_stat_activity. So that's what this does. You can try it ...
    Peter EisentrautPeter Eisentraut
    Aug 17, 2010 at 5:19 am
    Sep 20, 2010 at 6:14 am
  • Hello I still thinking about a "median" type functions. My idea is to introduce a new syntax for stype definition - like stype = type, or stype = ARRAY OF type [ ORDER [ DESC | ASC ]], or stype = ...
    Pavel StehulePavel Stehule
    Aug 18, 2010 at 12:09 pm
    Aug 19, 2010 at 11:37 pm
  • Hi, These days I am considering what else can be done for MERGE, And, I find inheritance tables in postgres is not supported by our MERGE command yet. Currently, MERGE command is only able to handle ...
    Boxuan ZhaiBoxuan Zhai
    Aug 10, 2010 at 9:38 am
    Aug 13, 2010 at 8:26 am
  • Here is a WIP patch implementing triggers on VIEWs, as outlined in the proof-of-concept here: http://archives.postgresql.org/pgsql-hackers/2010-08/msg00160.php The new triggers allowed on a VIEW are: ...
    Dean RasheedDean Rasheed
    Aug 15, 2010 at 5:38 pm
    Oct 11, 2010 at 7:54 am
  • Looks like MERGE is progressing well. At 2010 Dev Mtg, we put me down to work on making merge work concurrently. That was garbled slightly and had me down as working on predicate locking which is the ...
    Simon RiggsSimon Riggs
    Aug 5, 2010 at 3:43 pm
    Aug 6, 2010 at 7:42 am
  • I looked at making this happen, and noted that DropRelFileNodeBuffers is used both for the truncation case and for dropping relation buffers during smgrdounlink. In the latter case, it's still ...
    Tom LaneTom Lane
    Aug 15, 2010 at 6:58 pm
    Feb 18, 2011 at 11:33 pm
  • Attention committers!! ;) When we migrate to git, we will do a one-time mapping of your old username to an email address (as was discussed on the developer meeting in Ottawa earlier this year). This ...
    Magnus HaganderMagnus Hagander
    Aug 16, 2010 at 1:38 pm
    Aug 26, 2010 at 5:25 pm
  • So I got annoyed by $SUBJECT just now while chasing Wheeler's bug report. Seems like this would be a good thing to print. Should it appear always, or just with VERBOSE, or ??? regards, tom lane
    Tom LaneTom Lane
    Aug 24, 2010 at 2:40 pm
    Aug 26, 2010 at 9:54 am
  • Hi! According to the decision at the developer meeting, the migration to git should happen 17-20 Aug. Here's my proposed timeline. This will obviously affect development work some, and since the ...
    Magnus HaganderMagnus Hagander
    Aug 16, 2010 at 1:33 pm
    Aug 17, 2010 at 2:04 pm
  • Currently the english parser in text search does not support multiple words in the same position. Consider a word "wikipedia.org". The text search would return a single token "wikipedia.org". However ...
    Sushant SinhaSushant Sinha
    Aug 1, 2010 at 6:12 pm
    Jan 6, 2011 at 3:44 pm
  • I'd originally sent this to Joseph Adams, as he has been working on adding a JSON datatype. I've suggested supporting BSON, as there are many client implementations available, and the format is more ...
    Charles PritchardCharles Pritchard
    Aug 15, 2010 at 6:38 pm
    Aug 17, 2010 at 2:48 am
  • I want to create a database backup when PG is running, so I call pg_start_backup(''), scp the data to a backup directory, pg_stop_backup. Then I reboot PG , PG boot failed with log like "unexpected ...
    RichardRichard
    Aug 5, 2010 at 1:19 pm
    Aug 5, 2010 at 4:47 pm
  • Sorry. I forget to attach the patch file. Begin forwarded message: Date: Mon, 16 Aug 2010 19:49:20 +0800 From: Quan Zongliang <quanzongliang@gmail.com To: pgsql-hackers@postgresql.org Subject: patch ...
    Quan ZongliangQuan Zongliang
    Aug 17, 2010 at 12:58 pm
    Sep 30, 2010 at 8:12 am
  • In case anyone's interested, I've taken the CTE-based grouping sets patch from [1] and made it apply to 9.1, attached. I haven't yet done things like checked it for whitespace consistency, style ...
    Joshua TolleyJoshua Tolley
    Aug 3, 2010 at 5:50 am
    Aug 18, 2010 at 9:44 am
  • There's a little problem with EXECUTE USING when the parameters are of type unknown (going back to 8.4 where EXECUTE USING was introduced): do $$ BEGIN EXECUTE 'SELECT to_date($1, $2)' USING ...
    Heikki LinnakangasHeikki Linnakangas
    Aug 5, 2010 at 8:48 pm
    Aug 17, 2010 at 6:47 pm
  • I've been thinking about the idea of allowing triggers on views as a way of implementing updateable views. This would not be a replacement for rules in all situations, but rather a complementary ...
    Dean RasheedDean Rasheed
    Aug 4, 2010 at 11:39 am
    Aug 16, 2010 at 5:23 pm
  • Hi, attached is a patch that adds the missing feature to use "WHERE CURRENT OF :curname" in UPDATE and DELETE statements via ECPG. I used the current CVS MAIN but also applies almost cleanly to ...
    Boszormenyi ZoltanBoszormenyi Zoltan
    Aug 3, 2010 at 5:02 pm
    Feb 18, 2011 at 10:29 am
  • I also plan to add a security hook on authorization time. It shall allow external security providers to set up credential of the authenticated clients. Please note that it is not intended to control ...
    KaiGai KoheiKaiGai Kohei
    Aug 20, 2010 at 1:17 am
    Oct 27, 2010 at 1:24 am
  • This is an expansion of the question I posed in this thread: http://postgresql.1045698.n5.nabble.com/Need-help-understanding-vacuum-verbose-output-tp2265895p2266912.html I am framing the question ...
    Gordon ShannonGordon Shannon
    Aug 6, 2010 at 6:31 pm
    Aug 11, 2010 at 12:19 am
  • $SUBJECT seems to be less than 12 hours, which is annoyingly short. I don't see a good reason why I should have to log in again every morning. I could see expiring the cookie in a week or so, or ...
    Tom LaneTom Lane
    Aug 10, 2010 at 2:48 pm
    Aug 10, 2010 at 7:25 pm
  • Hey all, Accordingly to the documentation of libpq, SQLSTATE code field "is not localizable, and is always present.". But it seems, in some cases it isn't. E.g. /* the main code */ PGresult* res = ...
    Dmitriy IgrishinDmitriy Igrishin
    Aug 20, 2010 at 10:13 am
    Sep 22, 2010 at 2:45 pm
  • Hello I am working on Grouping Sets support. The first issue is "cube" keyword. Contrib module "cube" define a few functions "cube". So if we want to continue in support this function, then "cube" ...
    Pavel StehulePavel Stehule
    Aug 9, 2010 at 10:19 am
    Aug 9, 2010 at 6:08 pm
  • Yeah, I was thinking about that thread, too, on my drive home from Metuchen. I wouldn't get too bogged down in formal logic; it seems there are a couple of distinct cases here: 1. If you're changing ...
    Robert HaasRobert Haas
    Aug 3, 2010 at 7:32 pm
    Aug 5, 2010 at 2:10 pm
  • Hey all, This is just my email to notify you all that the project I've been working on with Stephen, the PostgreSQL Performance Farm, has been released. As of now, it only supports 9.0, due to the ...
    Luxenberg, Scott I.Luxenberg, Scott I.
    Aug 25, 2010 at 4:40 am
    Mar 27, 2011 at 8:26 pm
  • Hi, Here comes the new patch for MERGE command. It has the following features: 1. It is based on Heikki's merge_v102-cleanedup.patch. So, it is (hopefully) clean -- no meaningless white spaces and no ...
    Boxuan ZhaiBoxuan Zhai
    Aug 19, 2010 at 2:01 pm
    Aug 26, 2010 at 10:41 am
  • smgrcreate() currently contains a call to TablespaceCreateDbspace(). As the comment says, this is a rather silly place to put it. The silliest thing about it, IMHO, is that it forces the following ...
    Robert HaasRobert Haas
    Aug 20, 2010 at 2:44 am
    Aug 20, 2010 at 5:37 pm
  • I just noticed that we are now advertising the ability to insert UTF16 surrogate pairs in strings and identifiers (see section 4.1.2.2 in current docs, in particular). Is this really wise? I thought ...
    Tom LaneTom Lane
    Aug 22, 2010 at 6:29 pm
    Feb 20, 2011 at 12:00 am
  • I noticed that we were already tracking the information about when an autovacuum worker was last started in a database, but this information was not exposed. The attached patch puts this column in ...
    Magnus HaganderMagnus Hagander
    Aug 22, 2010 at 11:37 am
    Aug 23, 2010 at 2:46 pm
  • I found out "shared_preload_libraries" setting is ignored when we launch postgres in single user mode. In this case, postgres command is launched with "--single" argument, then the main() directly ...
    KaiGai KoheiKaiGai Kohei
    Aug 5, 2010 at 6:09 am
    Aug 17, 2010 at 3:43 am
  • Hello! We are 2 Students from the Technical University of Vienna. At our internship we would like to develop the item of the TODO list: "Allow SET CONSTRAINTS to be qualified by schema/table name". ...
    Viktor ValyViktor Valy
    Aug 3, 2010 at 12:57 pm
    Aug 13, 2010 at 1:32 pm
  • Attached is a patch to remove the upsert example from the pl/pgsql documentation. It has a serious bug (see: http://www.spinics.net/lists/pgsql/msg112560.html) which is nontrivial to fix. IMNSHO, our ...
    Merlin MoncureMerlin Moncure
    Aug 5, 2010 at 5:45 pm
    Feb 17, 2011 at 7:26 pm
  • I need suggestion about how region based memory management is done in postgres. I know the concept of region based memory management and also know about the functions like memorycontextswitch(). But ...
    SubhamSubham
    Aug 4, 2010 at 6:35 pm
    Sep 23, 2010 at 12:40 pm
  • Hi, I received the off-list email reporting that pg_subtrans keeps bloating up in the standby, from Harald (Thanks!). I investigated this issue and found that the standby doesn't truncate pg_subtrans ...
    Fujii MasaoFujii Masao
    Aug 27, 2010 at 1:39 pm
    Aug 30, 2010 at 12:29 pm
Group Navigation
period‹ prev | Aug 2010 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions156
posts2,061
users124
websitepostgresql.org...
irc#postgresql

124 users for August 2010

Tom Lane: 414 posts Robert Haas: 280 posts Pavel Stehule: 98 posts Kevin Grittner: 74 posts Heikki Linnakangas: 72 posts Magnus Hagander: 68 posts Bruce Momjian: 63 posts Peter Eisentraut: 61 posts David Fetter: 54 posts Josh Berkus: 45 posts David E. Wheeler: 44 posts Alvaro Herrera: 41 posts Simon Riggs: 41 posts Andrew Dunstan: 36 posts Fujii Masao: 31 posts Greg Stark: 31 posts Markus Wanner: 27 posts Boxuan Zhai: 24 posts KaiGai Kohei: 24 posts Stephen Frost: 24 posts
show more
Archives