Search Discussions
-
SYNTAX: ALTER SYSTEM SET configuration_parameter = value COMMENT 'value'; DESIGN IDEA: (a) have a postgresql.conf.auto (b) add a default include for postgresql.conf.auto at the beginning of ...
Amit Kapila
Oct 29, 2012 at 1:31 pm
Jan 12, 2013 at 7:43 am -
Not many RULE-lovers out there, once you've tried to use them. Allowing RULEs complicates various things and can make security more difficult. For 9.3, I suggest we create a DDL trigger by default ...
Simon Riggs
Oct 11, 2012 at 7:28 pm
Oct 22, 2012 at 11:18 pm -
Hi all, One of the outputs on the discussions about the integration of pg_reorg in core was that Postgres should provide some ways to do REINDEX, CLUSTER and ALTER TABLE concurrently with low-level ...
Michael Paquier
Oct 3, 2012 at 1:14 am
Dec 19, 2012 at 2:25 am -
Based on a previous thread (http://archives.postgresql.org/pgsql-hackers/2012-10/msg00131.php) I have put together a first attempt of a pg_ping utility. I am attaching two patches. One for the ...
Phil Sorber
Oct 13, 2012 at 9:19 pm
Dec 25, 2012 at 6:47 am -
Hi, With the help of Cédric, here's a patch changing the TRUNCATE TABLE command, adding the IF EXISTS option to allow the presence in the list of tables of a missing or invisible table. This meets ...
Sébastien Lardière
Oct 9, 2012 at 8:33 am
Oct 18, 2012 at 7:03 pm -
1. These operations think they can use ordinary heap_update operations to change pg_index entries when they don't have exclusive lock on the parent table. The lack of ex-lock means that another ...
Tom Lane
Oct 5, 2012 at 11:56 pm
Nov 30, 2012 at 12:56 am -
Hmm, I think we need to step back a bit. I've never liked the way replication_timeout works, where it's the user's responsibility to set wal_receiver_status_interval < replication_timeout. It's not ...
Heikki Linnakangas
Oct 1, 2012 at 10:39 am
Jan 9, 2013 at 4:04 am -
This problem has been discussed before. Those familiar with the subject please skip the next paragraph. When autovacuum finds a substantial amount of empty pages at the end of a relation, it attempts ...
Jan Wieck
Oct 24, 2012 at 8:20 pm
Dec 11, 2012 at 8:38 pm -
Hi, I've just noticed a change of LOCK command behavior between 9.1 and 9.2, and I'm not sure whether this is expected or not. Let's use a very simple table CREATE TABLE x (id INT); Say there are two ...
Tomas Vondra
Oct 10, 2012 at 8:21 pm
Nov 26, 2012 at 4:12 pm -
Sequences, as defined by SQL Standard, provide a series of unique values. The current implementation on PostgreSQL isolates the generation mechanism to only a single node, as is common on many ...
Simon Riggs
Oct 15, 2012 at 9:34 pm
Oct 18, 2012 at 3:43 pm -
Hallo postgresql and replication hackers This mail is an additional RFC which proposes a simple way to extend the new logical replication feature so it can cover most usages of skytools/pgq/londiste ...
Hannu Krosing
Oct 16, 2012 at 8:56 am
Oct 26, 2012 at 8:28 pm -
The security of MD5 authentication is brought up every now and then, most recently here: http://archives.postgresql.org/pgsql-hackers/2012-08/msg00586.php. The NIST competition mentioned in that ...
Heikki Linnakangas
Oct 10, 2012 at 10:41 am
Oct 23, 2012 at 4:53 pm -
It has been a fact that the RETURNING clause on an INSERT will return multiple rows with the same order as multiple VALUES have been fed. eg: INSERT INTO tbl1(code) VALUES ('abc'), ('def'), ('agh') ...
P. Christeas
Oct 17, 2012 at 12:39 pm
Oct 22, 2012 at 3:24 am -
Can we please expose the internal hash id of the statements in pg_stat_statements? I know there was discussions about it earlier, and it wasn't done with an argument of it not being stable between ...
Magnus Hagander
Oct 1, 2012 at 7:57 am
Nov 15, 2012 at 9:44 pm -
Hi, PL/pgsql seems to have a strange restriction regarding "RETURN". Normally, you can write "RETURN <expression ". But if the function returns a row type, then you can only write "RETURN variable" ...
Robert Haas
Oct 8, 2012 at 2:42 pm
Dec 7, 2012 at 4:29 am -
Since Simon stirred up a hornets nest suggesting deprecation of a number of features, I figured I'd take it one step further and suggest removal of some previously deprecated features :) In ...
Magnus Hagander
Oct 18, 2012 at 11:20 am
Nov 5, 2012 at 10:15 pm -
The attached patch would add the FET timezone abbreviation to the Default list _and_ the list of european abbreviations. - mb
Marc Balmer
Oct 6, 2012 at 9:18 am
Oct 9, 2012 at 3:40 pm -
I've noticed, doing some reporting queries once, that index scans fail to saturate server resources on compute-intensive queries. Problem is, just after fetching a page, postgres starts computing ...
Claudio Freire
Oct 18, 2012 at 8:30 pm
Nov 6, 2012 at 1:53 pm -
As discussed on other threads, Hash Indexes are currently a broken feature and bring us into disrepute. I describe them as broken because they are neither crash safe, nor could they properly be ...
Simon Riggs
Oct 14, 2012 at 1:46 pm
Oct 19, 2012 at 9:17 am -
People, The commitfest currently in progress seems to have ground to a halt. We really need to get things moving, because we're three weeks onto it and there is a large number of patches still ...
Alvaro Herrera
Oct 10, 2012 at 3:19 pm
Nov 5, 2012 at 6:34 pm -
Folks, One chronic problem users encounter is this one: 1. User creates new table 2. User inserts 45 records into new table. 3. Time passes. 4. User creates a query which joins against new table. 5 ...
Josh Berkus
Oct 12, 2012 at 11:53 pm
Oct 15, 2012 at 7:39 pm -
As per the last discussion for this patch, performance data needs to be provided before this patch's Review can proceed further. So as per your suggestion and from the discussions about this patch, I ...
Amit kapila
Oct 13, 2012 at 7:56 am
Jan 10, 2013 at 9:26 am -
Hi, Working on the Event Trigger next patch series, one of the challenge to address is deparsing the DDL commands so that the User Defined Function used by the trigger definition has that ...
Dimitri Fontaine
Oct 5, 2012 at 12:48 pm
Nov 4, 2012 at 8:20 pm -
Rushabh Lathia of the EnterpriseDB development team and I have been doing some testing of the extended query protocol and have found a case where it causes an assertion failure. Here's how to ...
Robert Haas
Oct 19, 2012 at 4:19 pm
Oct 22, 2012 at 5:24 am -
Hackers, I’ve discovered something a bit disturbing at $work. We’re migrating (slowly) from Oracle to PostgreSQL, and in some cases are using oracle_fdw to copy data over. Alas, there are a fair ...
David E. Wheeler
Oct 6, 2012 at 12:55 am
Oct 9, 2012 at 12:49 pm -
Hi all, I see there's already a TODO for allowing pg_restore to accept multiple --table arguments[1], but would folks support adding this capability to various other commands which currently accept ...
Josh Kupershmidt
Oct 28, 2012 at 11:31 pm
Dec 14, 2012 at 3:14 pm -
Hi, This patch adds an empty row before each section header in the error codes table in the docs. I tried not putting an empty row before the first section, but it looks better to always have an ...
Karl O. Pinc
Oct 26, 2012 at 2:03 pm
Dec 10, 2012 at 7:48 pm -
This contains all the consolidated data and comparison for both the approaches: The difference of this testcase as compare to previous one is that it has default value of wal_page_size ( 8K ) as ...
Amit kapila
Oct 16, 2012 at 9:23 am
Oct 29, 2012 at 2:40 pm -
Hey, this is my first post to the -hackers lists, so be merciful ;-) I created a patch which implements MAP_HUGETLB for sysv shared memory segments (PGSharedMemoryCreate). It is based on tests of Tom ...
Christian Kruse
Oct 29, 2012 at 8:14 pm
Dec 21, 2012 at 8:37 pm -
I just had this thought a few minutes ago, discussed it briefly with RhodiumToad on #postgresql and wanted to put it out here for discussion. Feel free to rip it apart. It probably is a bit ...
Jan Wieck
Oct 27, 2012 at 5:02 am
Nov 6, 2012 at 3:12 am -
Hello I should to search distinct values based on similarity postgres=# explain select nazobce, nazobce <- 'Benešov' from obce order by nazobce <- 'Benešov' limit 10 ; QUERY PLAN ...
Pavel Stehule
Oct 22, 2012 at 1:11 pm
Oct 26, 2012 at 6:56 am -
Hackers, Any plans to implement a documentation standard for extensions? I would love to see `make install` create the necessary man pages and perhaps even HTML (with a link added in the proper ...
David E. Wheeler
Oct 25, 2012 at 5:31 pm
Nov 2, 2012 at 4:16 pm -
Hey folks, It seems like right now when you want to create an index concurrently, the index creation will get canceled if you cancel the statement (i.e. you must keep your statement open). Is there a ...
David Lee
Oct 27, 2012 at 11:20 pm
Oct 29, 2012 at 8:50 pm -
10
Is there a good reason why PL languages do not support cstring type arguments and return values ?
Is the lack of support of cstring in PLs just laziness/ovelook or is there a good reason why PL languages do not support cstring type arguments and return values ? I'm currently adding this to ...Hannu Krosing
Oct 10, 2012 at 12:33 pm
Oct 11, 2012 at 11:18 am -
I was wondering recently if there was any command line tool that utilized PQping() or PQpingParams(). I searched the code and couldn't find anything and was wondering if there was any interest to ...
Phil Sorber
Oct 3, 2012 at 3:01 am
Oct 10, 2012 at 5:18 pm -
Per http://archives.postgresql.org/pgsql-hackers/2012-10/msg00167.php This brings to mind a lot of issues we see reported among our users: I see the problem of database connections shared among ...
Daniel Farina
Oct 3, 2012 at 10:09 pm
Oct 9, 2012 at 6:58 pm -
Hello, Using PostgreSQL 9.2.1 on Windows, I am facing a strange character set issue with a UTF-8 database. Maybe this is expected, but want to be sure that I am not missing something. On Windows, I ...
Sebastien FLAESCH
Oct 18, 2012 at 7:26 am
Jan 11, 2013 at 10:16 pm -
Hi, One of my colleagues, Jehan-Guillaume de Rorthais, found a weird behaviour of the "-c" command line option in the pg_restore tool while doing a training. Here is the following steps he followed ...
Guillaume Lelarge
Oct 13, 2012 at 2:47 pm
Oct 20, 2012 at 9:41 pm -
A while ago I noticed that in some places we strdup/pg_strdup() optarg strings from getopt(), and in some places we don't. If we needed the strdup(), the missing cases should generate errors. If we ...
Bruce Momjian
Oct 8, 2012 at 6:40 pm
Oct 13, 2012 at 7:28 pm -
Hi, I am trying to identify foreign scans uniquely.I am trying to do that by struct ForeignScanState,but I am confused as to how I can identify the scan. Is there a member of ForeignScanState that ...
Atri Sharma
Oct 6, 2012 at 6:33 pm
Oct 8, 2012 at 1:20 pm -
While looking around to fix the pg_malloc(0) issue, I noticed that various other pieces of code such as pg_basebackup have essentially identical functions, except they're called xmalloc(). I propose ...
Tom Lane
Oct 2, 2012 at 4:02 pm
Oct 4, 2012 at 2:19 pm -
See the CAVEATS here: https://developer.apple.com/library/mac/#documentation/Darwin/Reference/ManPages/man2/fork.2.html Apparently fork() without exec() isn't all that well supported. Noticed while ...
Alvaro Herrera
Oct 3, 2012 at 4:06 pm
Oct 3, 2012 at 10:57 pm -
While investigating a ruby-pg issue [1], we noticed that a libpq SSL connection can fail, if the running application uses OpenSSL for other work, too. Root cause is the thread local error queue of ...
Lars Kanis
Oct 23, 2012 at 8:09 am
Dec 10, 2012 at 11:54 pm -
I looked into the complaint of unreasonable planner runtime in bug #7626, http://archives.postgresql.org/pgsql-bugs/2012-10/msg00232.php In the given example, the indexed relation "foo" has join ...
Tom Lane
Oct 30, 2012 at 9:57 pm
Nov 5, 2012 at 8:19 pm -
There was a thread in January of 2012 where we discussed the idea of pulling system table/column name descriptions from the SGML docs and creating SQL comments for them ...
Bruce Momjian
Oct 12, 2012 at 5:29 pm
Oct 16, 2012 at 1:37 am -
Hackers, I have a database with 94059 entries in pg_class. Things are mostly working fine but psql tab completion is frustratingly slow (around 2.5 seconds on this box). I poked around in psql a bit ...
Merlin Moncure
Oct 10, 2012 at 1:33 pm
Oct 12, 2012 at 8:42 pm -
Hi, I would like to work on psql \ds improvements. Here's my idea : - in src/bin/psql/describe.c, add a new function : listSequences(*pattern, verbose) wich will list sequences and remove code ...
Julien Tachoires
Oct 7, 2012 at 9:07 pm
Oct 8, 2012 at 6:58 pm -
Hello Hackers! So, currently the only way to see if a function is security definer or not is to directly query pg_proc. This is both irritating, and I think perhaps dangerous since security definer ...
Jon Erdman
Oct 27, 2012 at 3:30 pm
Dec 29, 2012 at 6:56 pm -
Hello I did review of pgbench patch http://archives.postgresql.org/pgsql-hackers/2012-09/msg00737.php * this patch is cleanly patched * I had a problem with doc make[1]: Entering directory ...
Pavel Stehule
Oct 2, 2012 at 6:09 pm
Dec 18, 2012 at 12:08 pm -
I don't see Sébastien's message, but I made the same mistake in my patch. Another one is attached with copyfuncs and equalfuncs. I did a grep for DeallocateStmt and I don't believe I have missed ...
Vik Reykja
Oct 9, 2012 at 2:44 pm
Dec 6, 2012 at 2:21 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 136 |
posts | 1,580 |
users | 137 |
website | postgresql.org... |
irc | #postgresql |
137 users for October 2012
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)