Search Discussions
-
Greg Smith
Nov 2, 2008 at 2:02 am
Jan 26, 2009 at 7:46 pm -
Attached is a patch to fix problems 2 and 3: help.c clean application and formatting of the output therein. I also put \z right after \dp and removed the duplicate wording, to make it fit better, per ...
Greg Sabino Mullane
Nov 8, 2008 at 5:10 pm
Feb 7, 2009 at 9:38 pm -
Well, I assume SEPostgreSQL will rely on libraries that only exist on SELinux, so I am afraid there will have to be some type of compile-time flag, though the goal is to have as much of it enabled as ...
Bruce Momjian
Nov 7, 2008 at 6:20 pm
Jan 16, 2009 at 9:39 am -
This thread covers part of 3. Quoted from SQL:2008 "If CUME_DIST is specified, then the relative rank of a row R is defined as NP/NR, where NP is defined to be the number of rows preceding or peer ...
David Rowley
Nov 5, 2008 at 12:25 am
Dec 29, 2008 at 11:32 pm -
Hi. I am sorry to be a very late reaction... "Hiroshi Saito" <z-saito@guitar.ocn.ne.jp writes: next patch is this. Regards, Hiroshi Saito
Hiroshi Saito
Nov 2, 2008 at 5:20 am
Jan 11, 2009 at 9:58 am -
I hope this is the right place to report a bug/issue in the official documentation... In http://www.postgresql.org/docs/current/interactive/plpgsql-control-structures.html there is an example for a ...
Andreas Kretschmer
Nov 24, 2008 at 11:02 am
Nov 27, 2008 at 7:37 pm -
I think we should avoid the #define's like below which uses a local variable. I guess the same #define is used elsewhere in the code as well. If the code is rearranged or the variable name is ...
Pavan Deolasee
Nov 21, 2008 at 7:52 am
Dec 16, 2008 at 6:03 pm -
Hi! It will clearly also need an update to the comment, but I can take care of that. I assume you have tested this? The comment says that it works because we are handling UTF8 on a special way on ...
Magnus Hagander
Nov 24, 2008 at 12:28 pm
Jan 22, 2009 at 10:10 am -
Hi, Attached is the latest version of Synch Rep patch. Sorry for my late posting. I fixed some bugs in v1patch and integrated walreceiver into core. Attached contain some patches: * ...
Fujii Masao
Nov 14, 2008 at 10:15 am
Dec 1, 2008 at 2:17 am -
An idea for a possible enhancement to PostgreSQL: allow creation of a temporary table without generating any disk I/O. (Creating and dropping a three-column temporary table within a database ...
Kevin Grittner
Nov 5, 2008 at 11:01 pm
Nov 21, 2008 at 11:18 pm -
When perl function executes first time, it is too slowly, but if execute perl function(not function which executed first time) again it runs in 1000 times faster. Why ? how can i optimize it ? ...
Oleg Serov
Nov 15, 2008 at 10:36 pm
Nov 17, 2008 at 6:59 pm -
Hi! I want to use the fnmatch() function in libpq, to support wildcard certificate matching. This function is part of the standard ...
Magnus Hagander
Nov 20, 2008 at 12:24 pm
Nov 24, 2008 at 2:48 pm -
Well, FNM_CASEFOLD is not POSIX, and Autoconf thinks it's a GNU extension, which has obviously crept into other systems. So you'd need to use AC_FUNC_FNMATCH_GNU, but that also requires you to use ...
Peter Eisentraut
Nov 24, 2008 at 2:40 pm
Dec 1, 2008 at 5:28 pm -
Hello I am testing PostgreSQL on Federa 10. There is Perl 5.10. After successful compilation I got error CREATE LANGUAGE plperl; ERROR: could not oad library "/........plperl.so": ... undefined ...
Pavel Stehule
Nov 3, 2008 at 1:16 pm
Nov 10, 2008 at 4:20 pm -
Hi, I just noticed that the interface for choosing a different locale at db creation time is createdb --lc-collate=X --lc-ctype=X. Is there a reason for having these two separate switches? It seems ...
Alvaro Herrera
Nov 6, 2008 at 5:13 pm
Feb 13, 2009 at 9:27 am -
Hello, HEAD is failed to be built on win32 mingw. It requires manual 'mkdir man7' or so. Are there any changes in build process? Or am I missing something required to build? ---- $ make /bin/sh.exe: ...
ITAGAKI Takahiro
Nov 19, 2008 at 11:51 pm
Nov 28, 2008 at 11:28 pm -
19
SQL5 budget
Hi, all. I had preliminary conversation with my employer about implementation of SQL5 [1] without "Driven Scene" [2]. He needs concrete budget. So i'm asking you to estimate and say, how much will it ...Dmitry Turin
Nov 4, 2008 at 2:38 pm
Nov 13, 2008 at 6:53 pm -
I think the usual way is to call the function like: (void) function_with_return_value() -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
Heikki Linnakangas
Nov 20, 2008 at 3:08 pm
Nov 25, 2008 at 12:26 pm -
So based on Graeme Job's T-SQL hack over at thedailywtf.com I adapted the T-SQL code to Postgres and got this. Thought others might find it amusing. WITH RECURSIVE Z(IX, IY, CX, CY, X, Y, I) AS ( ...
Gregory Stark
Nov 19, 2008 at 9:53 pm
Nov 23, 2008 at 8:09 pm -
for anyone interested.... Solaris 2.5.1 with --enable-thread-safety configure:25848: gcc -o conftest -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels ...
Andrew Chernow
Nov 18, 2008 at 7:07 pm
Jan 14, 2009 at 10:39 pm -
Today I noticed I cannot login to cvs.pgfoundry.org anymore since the IP address has been changed am asked password which seems to be changed. So I cannot use CVS any more. Does anybody why this ...
Tatsuo Ishii
Nov 26, 2008 at 2:43 pm
Nov 26, 2008 at 11:03 pm -
Hello I am thinking about allowing 2D array from multicolumn subselect (all columns have to share same type, ofcourse). Is there some real limit, why this functionality is disallowed? Regards Pavel ...
Pavel Stehule
Nov 18, 2008 at 3:06 pm
Nov 18, 2008 at 6:59 pm -
Hi, The suppress_redundant_updates_trigger() works incorrectly on the table defined with "WITH_OIDS" option. ---------- (*) The latest 8.4devel tree without SE-PostgreSQL patch postgres=# CREATE ...
KaiGai Kohei
Nov 5, 2008 at 9:33 am
Nov 7, 2008 at 3:13 am -
I finally have a working version. Please have a look at the attached files including a changed version of gram.y and and automatically created version of preproc.y. To recreate just run "awk -f ...
Michael Meskes
Nov 1, 2008 at 8:06 pm
Nov 14, 2008 at 4:59 pm -
I installed and ran the citext tests both with and without the patch and had failures both times. The patch applied cleanly and the "make;make install" completed without errors. I have attached the ...
Kenneth Marshall
Nov 5, 2008 at 2:40 pm
Nov 7, 2008 at 11:51 pm -
Hot Standby patch, including all major planned features. Allows users to connect to server in archive recovery and run queries. Applies cleanly, passes make check. There's no flaky code, kludges or ...
Simon Riggs
Nov 1, 2008 at 5:57 pm
Dec 3, 2008 at 7:18 am -
I have experienced some brittleness in the regression test setup that causes the tests to be run against a different server instance or fail in confusing ways when you have multiple instances ...
Peter Eisentraut
Nov 14, 2008 at 3:29 pm
Nov 27, 2008 at 12:23 pm -
Unofficially, well done to everybody that submitted patches in time for Commit Fest. The queue has grown significantly over last few days and it's clear many people have been working very hard right ...
Simon Riggs
Nov 1, 2008 at 6:04 pm
Nov 2, 2008 at 11:46 am -
It was brought to my attention that DISCARD ALL does not release advisory locks: http://pgfoundry.org/tracker/index.php?func=detail&aid=1010499&group_id=1000258&atid=983 Thus connection managers / ...
Marko Kreen
Nov 24, 2008 at 3:07 pm
Nov 26, 2008 at 8:59 pm -
While working on the join elimination patch, I was going through the trigger code and found quite a bit of nastiness in regard to naming and variable repurposing related to the addition of ...
Jonah H. Harris
Nov 6, 2008 at 5:03 am
Jan 22, 2009 at 7:17 pm -
Hi, I wonder how portable designated initializers are. As far as I can tell they were only defined in C99. Can we use them in our source? If not, is there a way to do this in C89? I mean something ...
Alvaro Herrera
Nov 22, 2008 at 11:10 pm
Dec 10, 2008 at 8:50 pm -
I'm trying to do client only builds on a bunch of legacy platforms and noticed that the include path is messed up...if keywords.o is not already built, it fails to build be because src/backend/parser ...
Merlin Moncure
Nov 6, 2008 at 3:44 pm
Feb 4, 2009 at 7:34 pm -
NotDashEscaped: You need GnuPG to verify this message Looks like inheritance causes a statement-level trigger to fire on the last evaluated table in the inheritance chain. Is this the desired ...
Greg Sabino Mullane
Nov 28, 2008 at 9:34 pm
Jan 19, 2009 at 10:56 pm -
attached is a patch which enables plpython to recognize function with multiple OUT params as returning a record py=# create or replace function addsub( in i1 int, in i2 int, py=# out o1 int, out o2 ...
Hannu Krosing
Nov 1, 2008 at 4:13 am
Jan 1, 2009 at 9:58 pm -
Please find enclosed a revised version of pg_readahead and a patch to invoke pg_readahead. Changes from the previous one is as follows: Pg_readahead now does not return any prefetched point. It ...
Koichi Suzuki
Nov 27, 2008 at 12:04 pm
Dec 26, 2008 at 8:05 am -
Hi. As I wanted to change the order of columns of some tables (I know, I know, my code does not depend on that; but I prefer that \dt gives me a more organized ouput...) I've added an option to ...
Hernan gonzalez
Nov 14, 2008 at 5:21 pm
Nov 26, 2008 at 7:33 pm -
We are now in discussion about toast table upgrading. I try to collect ideas and figure out how it should work and where are problems. Overview: --------- A few weeks ago we made a decision to use ...
Zdenek Kotala
Nov 19, 2008 at 9:45 pm
Nov 20, 2008 at 8:17 pm -
All, This is my first patch review for PostgreSQL. I did submit a patch last commit fest (Boyer-Moore) so I feel I should review one this commit fest. I'm quite new to PostgreSQL so please don't rely ...
David Rowley
Nov 2, 2008 at 12:00 am
Nov 17, 2008 at 5:29 am -
I found the following behavior surprising. Is there a reason for it? This is 8.3.5. ...Robert rhaas=# BEGIN WORK; BEGIN rhaas=# CREATE TABLE test_table (id serial, foo integer, bar integer); NOTICE: ...
Robert Haas
Nov 14, 2008 at 9:32 pm
Nov 16, 2008 at 12:26 am -
The attached version now is able to generate an ecpg parser without a single change in gram.y. Also included is a perl version of the script created by a2p and fixed by me. Unfortunately a2p did not ...
Michael Meskes
Nov 10, 2008 at 2:40 pm
Nov 11, 2008 at 12:02 pm -
Hi, Brendan Jurd submitted a patch to add a pg_typeof() builtin function: http://archives.postgresql.org/pgsql-patches/2008-09/msg00029.php I've reviewed the patch and it looks fine. An updated ...
Kurt Harriman
Nov 3, 2008 at 9:35 am
Nov 7, 2008 at 11:01 pm -
Hi, I'm very new to hacking postgresql but am using on a very big site ( http://ojp.nationalrail.co.uk). One of the issues that we have is moving data from a live database to a reports one. I've ...
Rob Kirkbride
Nov 25, 2008 at 8:39 pm
Nov 27, 2008 at 11:29 am -
Following test case gives a warning of snapshot not destroyed at commit time. CREATE TABLE test (a int); INSERT INTO test VALUES (1); BEGIN; DECLARE c CURSOR FOR SELECT * FROM test FOR update; ...
Pavan Deolasee
Nov 24, 2008 at 7:35 am
Nov 25, 2008 at 8:34 pm -
Hi, In the current Synch Rep patch, the standby cannot catch up with the primary which has a bigger timeline. So, whenever making the standby catch up, a fresh base backup is required. This is ...
Fujii Masao
Nov 20, 2008 at 1:42 pm
Nov 25, 2008 at 6:54 am -
Here is a patch to reimplement the xmlconcat functionality as a variadic function instead of a hardcoded special expression type. I haven't found any variadic function in the set of built-in ...
Peter Eisentraut
Nov 17, 2008 at 11:22 am
Nov 18, 2008 at 8:44 am -
Attached patch allows to setup storage parameter for space reservation. I use reloptions capability for it. You can use it: CREATE TABLE test(id int) with (reservedspace=10); The idea is to reduce ...
Zdenek Kotala
Nov 8, 2008 at 10:59 pm
Nov 10, 2008 at 1:50 pm -
Hmph. It's trying to see if the NOT IN condition is self-contradictory, which of course it isn't, but the predicate_refuted_by machinery isn't smart enough to determine that except by running through ...
Tom Lane
Nov 12, 2008 at 3:47 pm
Nov 13, 2008 at 12:24 am -
All, Looking at my old thread I realized I never got an answer on whether people agreed with these two items: 1) Take the "SET search_path=public" out of all contrib SQL scripts so that DBAs can ...
Josh Berkus
Nov 6, 2008 at 9:48 pm
Nov 7, 2008 at 6:07 pm -
I am trying to compile libpq on HP-UX 10.20 using gcc 2.95.3, cpu is a 400MHz PA8500. I'm using the 8.3.5 tarball. [full make output is attached] Outside of the failure to build... I am getting a ...
Andrew Chernow
Nov 15, 2008 at 6:22 pm
Nov 17, 2008 at 10:03 pm -
Just noticed that the last libpqtypes release was broken on windows when dynamically linking. The problem is that windows has two addresses for functions, the import library uses a stub "ordinal" ...
Andrew Chernow
Nov 12, 2008 at 2:40 pm
Nov 15, 2008 at 3:45 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 177 |
posts | 1,918 |
users | 134 |
website | postgresql.org... |
irc | #postgresql |
134 users for November 2008
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)