Search Discussions
-
103
Sync Rep Design
I've mulled over the design for sync rep for awhile now, and have come up with a feature set that includes the final detailed feedback from Fujii Masao, Aidan Van Dyk, Josh Berkus and others. The ...Simon Riggs
Dec 30, 2010 at 5:26 pm
Jan 5, 2011 at 2:00 am -
Hi, Please find attached revision 16 of the extension patch, with the following additions over the previous one: - added documentation as proposed by David Wheeler, you can browse it online if ...
Dimitri Fontaine
Dec 9, 2010 at 8:34 pm
Jan 5, 2011 at 7:36 pm -
It would be cool to be able to transparently use hstores as Python dictionaries and vice versa. It would be easy enough with hstore as a core type, but with hstore as an addon it's not that easy. ...
Jan Urbański
Dec 13, 2010 at 7:57 am
Dec 15, 2010 at 9:48 pm -
Here's a patch that changes walsender to require a special privilege for replication instead of relying on superuser permissions. We discussed this back before 9.0 was finalized, but IIRC we ran out ...
Magnus Hagander
Dec 23, 2010 at 9:53 am
Jan 6, 2011 at 4:59 am -
The attached patch is the modular version of SE-PostgreSQL. Since I reduced the caching mechanism for access control decision, its code scale became about 2.6KL. [kaigai@saba sepgsql]$ wc -l *.[ch] ...
KaiGai Kohei
Dec 24, 2010 at 2:54 am
Mar 3, 2011 at 3:51 pm -
There are various applications where we want to completely replace the contents of a table with new/re-calculated data. It seems fairly obvious to be able to do this like... 1. Prepare new data into ...
Simon Riggs
Dec 14, 2010 at 6:27 pm
Jul 8, 2011 at 6:23 am -
Hi everyone, one of the ssesion I've attended on PgDay last week was Heikki's session about statistics in PostgreSQL. One of the issues he mentioned (and one I regularly run into) is the absence of ...
Tomas Vondra
Dec 12, 2010 at 2:58 am
Dec 27, 2010 at 3:12 pm -
Hi everyone, about two weeks ago I've started a thread about cross-column stats. One of the proposed solutions is based on number of distinct values, and the truth is the current distinct estimator ...
Tomas Vondra
Dec 27, 2010 at 4:13 pm
Jan 20, 2011 at 9:58 pm -
Dear fellow hackers, Problem: A normal diff of two slightly different schema dump files (pg_dump -s), will not produce a user-friendly diff, as you get all changes in the same file. Solution: I ...
Joel Jacobson
Dec 28, 2010 at 4:00 pm
Nov 28, 2012 at 6:46 pm -
The snapshot synchronization discussion from the parallel pg_dump patch somehow ended without a clear way to go forward. Let me sum up what has been brought up and propose a short- and longterm ...
Joachim Wieland
Dec 30, 2010 at 12:31 pm
Mar 3, 2011 at 11:53 pm -
Hi, Well $subject says about it all really. The bitrot of course comes from the fact that the last in-commitfest-dependency has been commited in, and I kept a version of pg_execute_sql_file() in the ...
Dimitri Fontaine
Dec 16, 2010 at 1:14 pm
Dec 20, 2010 at 11:32 pm -
Dear Greg, I have updated the MERGE patch for two main problems. 1. Support of system attributes in MERGE action expressions. In old version of MERGE, I use the top join as the only RTE in var name ...
Boxuan Zhai
Dec 4, 2010 at 1:28 pm
Jan 18, 2011 at 6:22 pm -
The new SQL Standard (SQL:2011) contains this: "Table constraints are either enforced or not enforced. Domain constraints and assertions are always enforced.", 4.17.2 The SQL Standard allows you to ...
Simon Riggs
Dec 12, 2010 at 10:51 pm
Jun 3, 2011 at 5:03 pm -
In reviewing the work Shigeru Hanada has done on SQL/MED, it's come to my attention that we have a lot of error messages that use the error code ERRCODE_WRONG_OBJECT_TYPE and have text like this: ...
Robert Haas
Dec 27, 2010 at 3:13 am
Jan 3, 2011 at 3:31 pm -
I've been playing around with postgresql hint bits in order to teach myself more about the internals of the MVCC system. I noticed that the hint bit system has been around forever (Vadim era) and ...
Merlin Moncure
Dec 21, 2010 at 10:42 pm
Dec 22, 2010 at 11:13 pm -
Hi, I found a bug which always prevents SignalSomeChildren with BACKEND_TYPE_WALSND from sending a signal to walsender. Though currently SignalSomeChildren with BACKEND_TYPE_WALSND has not been ...
Fujii Masao
Dec 15, 2010 at 3:54 am
Jan 21, 2011 at 4:43 am -
texteq, textne, byteaeq and byteane detoast their arguments, then check for equality of length. Unequal lengths imply the answer trivially; given equal lengths, the functions proceed to compare the ...
Noah Misch
Dec 20, 2010 at 6:20 pm
Jan 19, 2011 at 8:23 am -
Hi, I often find myself wanting advisory locks that are automatically released when the transaction ends, so here's a small patch trying to do just that. I don't know much about the lock system so ...
Marko Tiikkaja
Dec 13, 2010 at 10:52 pm
Feb 18, 2011 at 8:39 am -
Hackers, Some of you might already be aware that this combination produces a fatal startup crash in PostgreSQL: 1. Create an Ext3 or Ext4 partition and mount it with data=journal on a server with ...
Josh Berkus
Dec 1, 2010 at 2:56 am
Mar 11, 2011 at 1:26 am -
Here's a patch implementing traceback support for PL/Python mentioned in http://archives.postgresql.org/pgsql-hackers/2010-12/msg01991.php. It's an incremental patch on top of the plpython-refactor ...
Jan Urbański
Dec 23, 2010 at 1:55 pm
Mar 8, 2011 at 10:09 am -
As a side note, I think the term "writable CTE" is a misnomer. The CTE is not writable. The CTE is the result of a write operation. A writable CTE would look like this: WITH foo AS (SELECT ...) ...
Peter Eisentraut
Dec 22, 2010 at 6:28 pm
Jan 21, 2011 at 1:13 pm -
Hello I am resending a redesigned proposal about special plpgsql statement that support iteration over an array. The most conflict issue of last proposal was a syntax. It enhanced relative complex ...
Pavel Stehule
Dec 16, 2010 at 7:20 pm
Dec 17, 2010 at 8:08 pm -
Drat. OK, will work on it tomorrow. I didn't realize those places needed to be updated. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Robert Haas
Dec 26, 2010 at 4:55 am
Feb 4, 2011 at 3:37 am -
Hi there, below is the problem, which I don't have when running in shell. The database is in UTF-8 encoding. CREATE OR REPLACE FUNCTION url_decode(Vkw varchar) RETURNS varchar AS $$ use strict; use ...
Oleg Bartunov
Dec 8, 2010 at 3:13 pm
Jan 17, 2011 at 4:04 am -
I'm reviving the discussion on the subject topic because I just had an epiphany which makes it seem simple to implement. The concept of this is that if you start a SERIALIZABLE READ ONLY transaction ...
Kevin Grittner
Dec 5, 2010 at 3:11 pm
Dec 10, 2010 at 3:22 pm -
We're now just a day or two from the end of this CommitFest and there are still a LOT of open patches - to be specific, 23.Here's a brief synopsis of where we are with the others, all IMO of course. ...
Robert Haas
Dec 13, 2010 at 5:38 pm
Jan 20, 2011 at 5:43 pm -
Hello list, FK's cannot refer to rows in inheritance childs. With some changes in LockRows, together with removing the ONLY keyword in ri_trigger.c, it was possible to refer to the rows in child ...
Yeb Havinga
Dec 1, 2010 at 2:02 pm
Dec 7, 2010 at 11:07 am -
Hi I've just ran into a problem while upgrading from 8.4 to 9.0. pg_upgrade aborted during the step "Adding support functions to new cluster" with "ERROR: permission denied for language c" error. ...
Florian Pflug
Dec 12, 2010 at 9:55 am
Mar 9, 2011 at 7:25 pm -
Hi everyone, I just wrote my first patch, and I need to know whether I missed something or not. I haven't used C for a really long time, so sickbags on standby, and if you notice something really ...
Tv
Dec 11, 2010 at 6:59 pm
Feb 10, 2011 at 2:22 pm -
After reviewing the two ongoing threads about fixing the wal_sync_method fiasco, I think there is general agreement on these two points: 1. open_datasync shouldn't be the default choice 2. O_DIRECT ...
Tom Lane
Dec 7, 2010 at 4:24 pm
Jan 16, 2011 at 12:15 am -
Hello attached patch contains a implementation of iteration over a array: Regards Pavel Stehule
Pavel Stehule
Dec 23, 2010 at 8:31 pm
Jan 29, 2011 at 7:08 pm -
Hi all, Most of you already know I am new to this list and newer to any OSS development. However, while browsing the source code (of 9.0.1) I find that there is only one way to store relations on ...
Vaibhav Kaushal
Dec 10, 2010 at 6:39 am
Jan 1, 2011 at 8:59 pm -
Hi, The other infrastructure patch that has been mark ready for commit then commented further upon by Tom is $subject, even if the function provided as been renamed to pg_execute_sql_file(). Please ...
Dimitri Fontaine
Dec 11, 2010 at 9:09 pm
Dec 16, 2010 at 9:12 am -
Folks, Is there any good reason that this works: postgres=# select ('1e+01'::numeric)::integer postgres-# ; int4 ------ 10 But this doesn't? postgres=# select '1e+01'::Integer postgres-# ; ERROR: ...
Josh Berkus
Dec 17, 2010 at 7:06 pm
Dec 18, 2010 at 2:03 am -
Part of this may be my C skills not being good enough - if so, please enlighten me :-) My pg_streamrecv no longer works with 9.1, because it returns PGRES_COPY_BOTH instead of PGRES_COPY_OUT when ...
Magnus Hagander
Dec 28, 2010 at 12:13 pm
Mar 31, 2011 at 4:16 pm -
Here's the base refactoring patch mentioned in http://archives.postgresql.org/pgsql-hackers/2010-12/msg01991.php Git branch for this patch: https://github.com/wulczer/postgres/tree/refactor It does ...
Jan Urbański
Dec 23, 2010 at 1:40 pm
Jan 26, 2011 at 11:42 pm -
Hello, [Tried the general forum, didn't hear from anyone so far, trying this forum now, please review, thanks] We are looking to distribute postgres databases to our customers along with our ...
Srini Raghavan
Dec 23, 2010 at 12:35 am
Mar 11, 2011 at 10:35 am -
Attached patch implements a function called pg_primary_conninfo() that returns, well, the primary_conninfo used on the standby when in streaming replication mode (otherwise NULL). Objections? -- ...
Magnus Hagander
Dec 28, 2010 at 1:32 pm
Jan 13, 2011 at 11:06 am -
pg_ctl.c::test_postmaster_connection() has some fragile code that tries to detect the server port number by looking in the pg_ctl -o string, postgresql.conf, the PGPORT environment variable, and ...
Bruce Momjian
Dec 18, 2010 at 6:22 pm
Dec 27, 2010 at 8:20 pm -
I'm still not convinced there's any hazard of this type, but there is, apparently, a problem with failing to emit XLOG records for GIST indexes, because they apparently use LSNs to detect concurrent ...
Robert Haas
Dec 14, 2010 at 9:06 pm
Dec 18, 2010 at 1:51 am -
Initdb fails for me when host machine has no access to the Postgres build location. LOG: could not open directory .../install/share/timezone": No such file or directory LOG: could not open directory ...
BRUSSER Michael
Dec 9, 2010 at 5:37 pm
Dec 13, 2010 at 6:02 pm -
Extensions Patch v15 Review =========================== Submission review ----------------- * Is the patch in context diff format? Yes. * Does it apply cleanly to the current git master? Yes. * Does ...
David E. Wheeler
Dec 4, 2010 at 1:09 am
Dec 9, 2010 at 4:20 am -
I'm betting 8.4, because there is a field named "using" on that line in 8.4 ... We did clean up C++ keyword uses in the header files in 9.0, but your report shows it's already gotten broken again. ...
Tom Lane
Dec 26, 2010 at 5:31 pm
Jan 13, 2011 at 5:34 pm -
I am suggesting adding a function to libpq: PGresult *PQvexec(PGconn *conn, const char *fmt, ...); It behaves similar to PQexec, but it allows for printf style varargs and does connection ...
Marc Balmer
Dec 5, 2010 at 9:52 am
Dec 28, 2010 at 3:06 am -
ALTER TABLE ALTER TYPE always rewrites the table heap and its indexes. In some cases, we can determine that doing so is unhelpful, and that the conversion shall always succeed: CREATE DOMAIN loosedom ...
Noah Misch
Dec 29, 2010 at 12:56 pm
Jan 6, 2011 at 5:47 am -
I am having a hard time understanding this patch. I decided to start with the README, and I'm still lost. :-( My understanding of the problem is as follows. Acquiring a lock on a tuple prevents the ...
Robert Haas
Dec 19, 2010 at 4:24 am
Dec 21, 2010 at 1:48 am -
This broke the buildfarm on Windows, and I'm not sure of the best way to fix it. We currently define read and write permissions in port/win32.h specifically for windows. A quick-fix to just add these ...
Magnus Hagander
Dec 11, 2010 at 1:18 pm
Dec 13, 2010 at 4:38 pm -
Here's a patch implementing custom Python exceptions for SPI errors mentioned in http://archives.postgresql.org/pgsql-hackers/2010-12/msg01991.php. It's an incremental patch on top of the ...
Jan Urbański
Dec 23, 2010 at 2:39 pm
Mar 1, 2011 at 10:58 am -
Hackers, Here is first version of patch, which enable index support of wildcard search in pg_trgm contrib module. The idea of the patch is to extract from wildcard trigrams which should occurs in ...
Alexander Korotkov
Dec 11, 2010 at 9:08 pm
Feb 1, 2011 at 8:16 am -
Hi, Please see the following plan: postgres=# explain select * from small_table left outer join big_table using (id); QUERY PLAN ...
Jie Li
Dec 28, 2010 at 10:13 am
Jan 1, 2011 at 11:18 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 185 |
posts | 2,584 |
users | 144 |
website | postgresql.org... |
irc | #postgresql |
144 users for December 2010
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)