Search Discussions
-
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)
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 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 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 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 ...
Shadar
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 Golub
Jun 17, 2009 at 9:57 am
Jun 18, 2009 at 7:37 pm -
Tsutomu 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 / 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 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 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 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. 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Cecchet
Jun 2, 2009 at 8:15 pm
Jun 4, 2009 at 1:06 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 128 |
posts | 1,565 |
users | 131 |
website | postgresql.org... |
irc | #postgresql |
131 users for June 2009
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)