FAQ

PostgreSQL > pgsql-hackers > June 2009

Search Discussions

128 discussions - 1,565 posts

  • Hi all, I am thinking about implementing GRANT ON ALL TABLES IN schema TODO item. I saw many people sending proposals to the list but nobody seemed to actually do anything. I have few questions and ...
    Petr JelinekPetr Jelinek
    Jun 16, 2009 at 3:51 pm
    Oct 13, 2009 at 1:35 am
  • Now that 8.4.0 is out the door, development for 8.5devel will be opened any day now. But we haven't discussed the development timeline so far. The core team has several proposals: CommitFest Alpha ...
    Peter EisentrautPeter Eisentraut
    Jun 30, 2009 at 5:33 am
    Aug 17, 2009 at 9:54 pm
  • [ it's way past time for a new subject thread ] Marko Kreen <markokr@gmail.com writes: This brings up something that I've been wondering about: my limited exposure to git hasn't shown me any sane way ...
    Tom LaneTom Lane
    Jun 2, 2009 at 3:43 pm
    Jun 19, 2009 at 7:18 am
  • I've been kicking the tires on this a bit, and I've found an issue when dealing with contrib/ (specifically dblink, although I haven't looked around anymore). dblink_current_query() is not in the 8.4 ...
    Brad NicholsonBrad Nicholson
    Jun 5, 2009 at 7:39 pm
    Jun 8, 2009 at 9:33 pm
  • Any objections if I add: http://archives.postgresql.org/pgsql-performance/2009-06/msg00215.php to the (currently empty) list of open items for 8.4? A 25-30% performance regression in our main bulk ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Jun 18, 2009 at 8:16 pm
    Jun 26, 2009 at 9:20 pm
  • What about just: static char spaces[4] = { ' ', ' ', ' ', ' ' }; and then ... * (uint32 *) spaces? There's not much point taking the length of the word when you've initialized it to contain exactly 4 ...
    Robert HaasRobert Haas
    Jun 16, 2009 at 4:24 am
    Feb 23, 2010 at 9:23 pm
  • Here we go, XML and JSON output. You will need to apply explain_refactor-v4.patch and explain_options-v2.patch first, then apply the two patches attached to this message. ...
    Robert HaasRobert Haas
    Jun 12, 2009 at 5:15 am
    Jun 18, 2009 at 7:11 am
  • It is time to run pgindent on CVS HEAD for 8.4. I am thinking of running it at zero-hour GMT tomorrow, meaning five hours from now. Any objections? -- Bruce Momjian <bruce@momjian.us ...
    Bruce MomjianBruce Momjian
    Jun 9, 2009 at 5:21 pm
    Jun 13, 2009 at 1:58 pm
  • PostgreSQL Extensions /* Debug borders */ p, li, dt, dd, div, pre, h1, h2, h3, h4, h5, h6 { /* border: 1px solid red; */ } body { margin: 1em 5% 1em 5%; } a { color: blue; text-decoration: underline; ...
    Dimitri FontaineDimitri Fontaine
    Jun 23, 2009 at 5:46 pm
    Jul 23, 2009 at 5:21 pm
  • We currently require that you set client_encoding correctly, or you get garbage in psql and any other tool using libpq. How about setting client_encoding automatically to match the client's locale? ...
    Heikki LinnakangasHeikki Linnakangas
    Jun 17, 2009 at 11:29 am
    Feb 19, 2011 at 7:02 am
  • As of today we are three months behind the original plan for 8.4.0 release. In a one-year release cycle that's already pretty bad slip; but there now seems no chance of a release happening in less ...
    Tom LaneTom Lane
    Jun 1, 2009 at 4:32 pm
    Jun 5, 2009 at 2:54 pm
  • I'd like some brief feedback on this idea before I try to make a real proposal. The use case is this: You have an application with several roles: * admin user - owns all the objects related to that ...
    Jeff DavisJeff Davis
    Jun 28, 2009 at 6:08 pm
    Jul 1, 2009 at 11:12 am
  • Hi, http://archives.postgresql.org/message-id/496B9495.4010902@enterprisedb.com One of the major problems in Synch Rep was that WAL files generated before replication starts are not automatically ...
    Fujii MasaoFujii Masao
    Jun 16, 2009 at 6:13 am
    Jul 10, 2009 at 1:11 am
  • As some of you have probably gathered from a couple of recent patches that I've posted, I've been taking a look at the scripts we use to generate various derived files based on the catalog headers, ...
    Robert HaasRobert Haas
    Jun 30, 2009 at 4:00 am
    Aug 11, 2009 at 9:28 pm
  • Hi, in case of a serious failure of a backend or an auxiliary process the postmaster performs a crash recovery and restarts the db automatically. Is there a possibility to deactivate the restart and ...
    Kolb, Harald (NSN - DE/Munich)Kolb, Harald (NSN - DE/Munich)
    Jun 4, 2009 at 4:02 pm
    Jun 17, 2009 at 7:36 am
  • Hi all, following the link in http://wiki.postgresql.org/wiki/Query_progress_indication but mostly: http://www.postech.ac.kr/~swhwang/progress2.pdf [1] I'm trying to write an implementation of the ...
    Scara MaccaiScara Maccai
    Jun 26, 2009 at 7:37 am
    Jul 2, 2009 at 6:27 pm
  • Hi, While analyzing some complex query and switching away from using the materialized views to their underlying ones I got interested in the long plan times (minutes and up) and did some profiling ...
    Andres FreundAndres Freund
    Jun 3, 2009 at 3:48 pm
    Jun 10, 2009 at 5:40 pm
  • Now that pg_migrator is in beta (http://pgfoundry.org/frs/?group_id=1000235), I was wondering if we want to mention pg_migrator anywhere in our docs or release notes? Josh Berkus is already ...
    Bruce MomjianBruce Momjian
    Jun 5, 2009 at 4:44 pm
    Jul 8, 2009 at 2:18 pm
  • I notice that one of my tables gets TOASTed, about 40% of it. I read about TOAST and understand the general motivation (get faster access to the *other* columns). But in my case the big column ...
    ShadarShadar
    Jun 11, 2009 at 2:32 pm
    Jul 22, 2009 at 1:23 am
  • Hello, pgsql-hackers. Is there any possibility that Postgres will have named transaction ever, like Firebird? Now for each transaction client should open separate connection. But CONNECTION LIMIT ...
    Pavel GolubPavel Golub
    Jun 17, 2009 at 9:57 am
    Jun 18, 2009 at 7:37 pm
  • Tsutomu YamadaTsutomu Yamada
    Jun 26, 2009 at 9:07 am
    Aug 4, 2009 at 3:43 pm
  • Hi, I pgdump'ed a 8.3.7 database and loaded the dump to a different server running PostgreSQL 8.4 beta 2 (compiled from source) under Opensolaris. One of the tables has about 6 million records, and a ...
    Floris Bos / MaxnetFloris Bos / Maxnet
    Jun 9, 2009 at 1:02 am
    Jun 10, 2009 at 7:42 pm
  • Hi, pg_standby can use ln command to restore an archived file, which might destroy the archived file as follows. 1) pg_standby creates the symlink to the archived file '102' 2) '102' is applied 3) ...
    Fujii MasaoFujii Masao
    Jun 1, 2009 at 5:47 am
    Jun 4, 2009 at 8:58 am
  • Move the shift-and-test login into a separate fls() function, which can use __builtin_clz() if it's available. This requires a new check for __builtin_clz in the configure script. Results in a ~2% ...
    Jeremy KerrJeremy Kerr
    Jun 30, 2009 at 7:08 am
    Jul 21, 2009 at 8:00 pm
  • Building 8.4beta2 on my AIX test machine works fine, but when I set listen_addresses = '*' in postgresql.conf, the server fails to start. This is what I get: LOG: 00000: could not translate service ...
    Albe LaurenzAlbe Laurenz
    Jun 9, 2009 at 3:58 pm
    Jun 12, 2009 at 3:55 pm
  • Howdy, I'm working on functions to compare result sets for pgTAP. In the process, I found what appears to be an inconsistency in error handling when comparing incomparable results. I'm testing in ...
    David E. WheelerDavid E. Wheeler
    Jun 30, 2009 at 5:18 pm
    Jun 30, 2009 at 11:53 pm
  • Hi, I have encountered strange errors while testing PostgreSQL 8.4 beta2. SELECT msg_sid FROM msginfo WHERE plainto_tsquery(E'test') @@ body_index; or SELECT msg_sid FROM msginfo WHERE ...
    Tatsuo IshiiTatsuo Ishii
    Jun 2, 2009 at 6:48 am
    Jun 6, 2009 at 3:46 am
  • Hi, I think that our dependencies for generated header files (gram.h, fmgroids.h, probes.h) are not as good as they could be. What we do right now is make src/backend/Makefile rebuild these before ...
    Robert HaasRobert Haas
    Jun 28, 2009 at 6:21 pm
    Aug 13, 2009 at 2:13 pm
  • Hi all, We are working with Aster for the summer and we would like to bounce some ideas that we are having for some possible PostgreSQL extensions. In order to describe our ideas we will use the ...
    Nedyalko BorisovNedyalko Borisov
    Jun 26, 2009 at 5:14 pm
    Sep 27, 2009 at 7:30 pm
  • Currently, libpq will wrap each send() call on the connection with two system calls to mask SIGPIPEs. This results in 3 syscalls instead of one, and (on Linux) can lead to high contention on the ...
    Jeremy KerrJeremy Kerr
    Jun 10, 2009 at 6:32 am
    Jun 10, 2009 at 1:04 pm
  • Hi, PFA patch, readme for automating partitions in PostgreSQL 8.4 Beta 2 and testcases. The patch automates table partitioning to support Range and Hash partitions. Please refer to attached readme ...
    Kedar PotdarKedar Potdar
    Jun 8, 2009 at 2:02 pm
    Sep 14, 2009 at 6:07 pm
  • Hi all, this patch adds the possibility to map the login-rolename to a different rolename actually used for permissions. What is it used for? I'm working with smartcard based TLS-authentication to ...
    Lars KanisLars Kanis
    Jun 29, 2009 at 1:15 pm
    Jul 24, 2009 at 7:32 pm
  • I complained a couple days ago that in HEAD, vacuum is putting very bogus values into pg_class.reltuples for indexes: http://archives.postgresql.org/pgsql-bugs/2009-06/msg00037.php After looking ...
    Tom LaneTom Lane
    Jun 6, 2009 at 7:44 pm
    Jun 16, 2009 at 11:19 am
  • Here is an updated version of my "generic options for explain" patch. Previous version here: http://archives.postgresql.org/pgsql-hackers/2009-06/msg00866.php This patch requires the "explain ...
    Robert HaasRobert Haas
    Jun 18, 2009 at 1:18 am
    Jul 27, 2009 at 2:52 am
  • Every so often the buildfarm shows row-ordering differences in the copy2 test, for example http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=jaguar&dt=2009-06-13%2003:00:02 ("jaguar" seems ...
    Tom LaneTom Lane
    Jun 13, 2009 at 4:27 pm
    Jun 22, 2009 at 5:07 am
  • This patch adds support DAC security checks on largeobjects. Enhanced GRANT/REVOKE statement allows to set SELECT (read) and UPDATE (write) permission on individual largeobjects. At the creation ...
    KaiGai KoheiKaiGai Kohei
    Jun 26, 2009 at 4:08 am
    Jul 31, 2009 at 7:20 am
  • A new approach to avioding manipulating the signal mask during for every send - this time round, use SO_NOSIGPIPE and MSG_NOSIGNAL if available. The patches have been tested on Linux and OSX, and ...
    Jeremy KerrJeremy Kerr
    Jun 30, 2009 at 6:50 am
    Jul 24, 2009 at 6:00 pm
  • pg_migrator needs hard link() capabiity on Win32 to support its --link option. Can someone create that and hopefully add it to libpgport? libpgport currently only has symlink capability for Win32. -- ...
    Bruce MomjianBruce Momjian
    Jun 1, 2009 at 2:54 am
    Jun 2, 2009 at 3:15 pm
  • Hi, contrib/dblink seems to have no treatments for query cancels. It causes the following issues: (1) Users need to wait for completion of remote query. Requests for query cancel won't be delivered ...
    Itagaki TakahiroItagaki Takahiro
    Jun 26, 2009 at 2:40 am
    Feb 25, 2010 at 12:39 am
  • I noticed the following core-dump situation in CVS HEAD: regression=# select array_agg_finalfn(null); server closed the connection unexpectedly This probably means the server terminated abnormally ...
    Tom LaneTom Lane
    Jun 9, 2009 at 4:31 pm
    Jun 10, 2009 at 10:16 pm
  • This will fail outright on any non-gcc compiler. regards, tom lane
    Tom LaneTom Lane
    Jun 2, 2009 at 4:07 pm
    Jun 5, 2009 at 4:08 am
  • If we are to make the proposed schedule for 8.4 (ie, wrap RC1 tomorrow) we've got to get pretty hard-nosed about closing out the open items at ...
    Tom LaneTom Lane
    Jun 10, 2009 at 5:40 pm
    Jun 11, 2009 at 6:35 pm
  • I poked into this a bit, and it looks sort of nasty. Mark's immediate complaint is a consequence of the synchronize_seqscan patch, but there are other issues too. The problem comes from the fact that ...
    Tom LaneTom Lane
    Jun 9, 2009 at 4:07 pm
    Jun 10, 2009 at 10:33 pm
  • Based on Tom's post today about RC1, it sounds like I need to get this committed very soon. Any complaints? Joe -------- Original Message -------- Subject: Re: [HACKERS] dblink patches for comment ...
    Joe ConwayJoe Conway
    Jun 6, 2009 at 7:50 am
    Jun 9, 2009 at 4:36 pm
  • Folks, For things like PostGIS, which will want to index in 4 dimensions (x, y, z, t), we might want to have multi-dimensional selectivity histograms and some way to use same. Anybody here qualified ...
    David FetterDavid Fetter
    Jun 29, 2009 at 4:51 pm
    Jul 5, 2009 at 8:15 am
  • The todo list says, as follows: * Binary Data o Add security checks for large objects http://wiki.postgresql.org/wiki/Todo#Binary_Data Is anyone working on? or interested in? Thanks, -- OSS Platform ...
    KaiGai KoheiKaiGai Kohei
    Jun 19, 2009 at 4:03 am
    Jun 23, 2009 at 4:24 am
  • All, I just realized that even if you do this: table foo ( id serial, bar varchar(200) ) ALTER TABLE foo ALTER COLUMN bar TYPE VARCHAR(1000) ... it triggers a heap & index rebuild, even though it's ...
    Josh BerkusJosh Berkus
    Jun 1, 2009 at 8:27 pm
    Jun 2, 2009 at 8:39 am
  • Hi, I wonder why pg_standby requires libpq.so.5. We should get rid of PG_LIB settings from contrib/pg_standby/Makefile? Here is the patch to do so. Am I missing something? Regards, -- Fujii Masao ...
    Fujii MasaoFujii Masao
    Jun 25, 2009 at 4:50 am
    Jul 16, 2009 at 11:21 am
  • I'm having trouble coming up with a sensible translation for the last line of this: peter=# \d test* Table "public.test1" Column | Type | Modifiers --------+---------+----------- a | integer | not ...
    Peter EisentrautPeter Eisentraut
    Jun 10, 2009 at 9:48 pm
    Jun 10, 2009 at 10:40 pm
  • Hi, As we discussed during PGCon, we are using temp tables in 2PC transactions. The temp tables are dropped before PREPARE (or have an ON COMMIT DROP option) and never cross transaction boundaries. ...
    Emmanuel CecchetEmmanuel Cecchet
    Jun 2, 2009 at 8:15 pm
    Jun 4, 2009 at 1:06 am
Jun 2009
123
Group Navigation
period‹ prev | Jun 2009 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions128
posts1,565
users131
websitepostgresql.org...
irc#postgresql

131 users for June 2009

Tom Lane: 325 posts Robert Haas: 113 posts Bruce Momjian: 99 posts Andrew Dunstan: 75 posts Kevin Grittner: 60 posts Simon Riggs: 48 posts Peter Eisentraut: 46 posts David E. Wheeler: 40 posts Greg Stark: 38 posts Josh Berkus: 37 posts Alvaro Herrera: 35 posts Jeremy Kerr: 35 posts Markus Wanner: 31 posts Andres Freund: 28 posts Fujii Masao: 27 posts Stefan Kaltenbrunner: 25 posts Dimitri Fontaine: 24 posts David Fetter: 21 posts Marko Kreen: 20 posts Aidan Van Dyk: 19 posts
show more
Archives