Search Discussions
-
One goal for 8.1 is to move /contrib/pg_autovacuum in to the backend. I think it has to be done in four stages: o move it into the backend and have it start/stop automatically o move the autovacuum ...
Bruce Momjian
Jun 15, 2005 at 1:23 am
Jun 21, 2005 at 8:07 pm -
Tom, All: Ok, finally managed though the peristent efforts of Mark Wong to get some tests through. Here are two tests with the CRC and wall buffer checking completely cut out of the code, as Tom ...
Josh Berkus
Jun 29, 2005 at 6:35 pm
Jul 27, 2005 at 10:37 pm -
Folks, I had a lot of time to kill on airplanes recently so I've gone digging through /contrib in an effort to sort out what's in there and try to apply some consistent rules to it. Before people ...
Josh Berkus
Jun 7, 2005 at 5:51 pm
Jun 14, 2005 at 12:11 pm -
The following functions are currently in contrib/dbsize. As Bruce has suggested, we should discuss which functions should or shouldn't be moved into the backend, and which should be renamed. int8 ...
Dave Page
Jun 24, 2005 at 7:30 pm
Jul 29, 2005 at 2:47 pm -
Great, glad to hear it. I hope you got a chance to look over the open items in the 'milestones' file. I'd really like to see the grammar be fixed to match SQL spec for GRANT ROLE/REVOKE ROLE. I think ...
Stephen Frost
Jun 28, 2005 at 4:04 pm
Jul 4, 2005 at 12:21 pm -
We have addressed all the open issues for 8.1 except for auto-vacuum, which Alvaro is working on, so I think we are ready for a feature freeze on July 1. -- Bruce Momjian | http://candle.pha.pa.us ...
Bruce Momjian
Jun 21, 2005 at 4:04 am
Jul 6, 2005 at 10:39 pm -
Seems fine. Regards, Andreas
Andreas Pflug
Jun 27, 2005 at 9:41 pm
Jul 26, 2005 at 9:55 pm -
41
LGPL
Is there any reason why we would not be able to use LGPL code in PG? ... JohnJohn Hansen
Jun 15, 2005 at 1:53 am
Jun 18, 2005 at 4:56 pm -
37
Open items
Here are the open items. Feature freeze is Friday, July 1. --------------------------------------------------------------------------- PostgreSQL 8.1 Open Items ========================= Current ...Bruce Momjian
Jun 26, 2005 at 3:25 am
Jul 1, 2005 at 11:07 pm -
[ redirected back to hackers, since it seems this is far from a finished discussion ] Robert Treat <xzilla@users.sourceforge.net writes: pg_addons or pg_tools or something like that seems like a fine ...
Tom Lane
Jun 18, 2005 at 2:12 pm
Jun 21, 2005 at 3:44 pm -
In PL/PgSQL, "END LOOP" is used to terminate loop blocks, and "END IF" is used to terminate IF blocks. This is needlessly verbose: we could simply accept "END" in both cases without syntactic ...
Neil Conway
Jun 22, 2005 at 2:17 am
Jul 2, 2005 at 9:01 am -
Hi all, O_DIRECT for WAL writes was discussed at http://archives.postgresql.org/pgsql-patches/2005-06/msg00064.php but I have some items that want to be discussed, so I would like to re-post it to ...
ITAGAKI Takahiro
Jun 21, 2005 at 5:44 am
Jul 14, 2005 at 7:44 pm -
And as we all know, optional means pgFoundry or someplace else. To be honest, I simply couldn't be bothered on this one because even if I could convince everyone to allow such a beast on the backend, ...
Dave Page
Jun 16, 2005 at 8:06 pm
Jun 18, 2005 at 7:44 pm -
Do the transaction id's used in 2PC need to be unique across all sessions? Do we provide a mechanism for this ? If not shouldn't we provide a way to create a unique transaction id ? Dave Cramer ...
Dave Cramer
Jun 30, 2005 at 10:39 pm
Jul 3, 2005 at 7:35 am -
Have we list named something like 'test focusing for 8.1'? If it exists then GiST concurrency and recovery testing should be added to it. Especially, recovery after crash. Of course, now Oleg and me ...
Teodor Sigaev
Jun 27, 2005 at 12:49 pm
Aug 30, 2005 at 1:54 pm -
I've mentioned this a couple times now, but here is an official proposal: I would like to move the contrib/rtree_gist functionality into the core system before feature freeze. There are a couple ...
Tom Lane
Jun 26, 2005 at 2:03 pm
Jun 30, 2005 at 3:14 pm -
Hackers: I've been trying to get a test result for 8.1 that shows that we can eliminate commit_delay and commit_siblings, as I believe that these settings no longer have any real effect on ...
Josh Berkus
Jun 22, 2005 at 4:48 pm
Jul 2, 2005 at 6:15 am -
[switched to -hackers] Tom Lane wrote: All true. Conversely, there does need to be a path for us to get to standard behaviour. I think we're going to need to provide for switchable behaviour, as ugly ...
Andrew Dunstan
Jun 16, 2005 at 3:25 pm
Jun 21, 2005 at 4:18 pm -
I had an idea about how to possibly solve the pg_terminate_backend issue. How about we add a field to PGPROC (or is there a better place?) called shouldExit. pg_terminate_backend will set this field ...
Magnus Hagander
Jun 21, 2005 at 9:23 pm
Jul 10, 2006 at 9:33 pm -
There are several buildfarm machines failing like this. I think a possible solution is for the postmaster to do putenv("PGPORT=nnn") so that libpq instances running in postmaster children will ...
Tom Lane
Jun 22, 2005 at 3:21 am
Jul 2, 2005 at 11:28 pm -
We can write debugger with breakpoints without bytecode. Every stmt rec can have flag if has breakpoints. No problem. I don't see any advance of bytecode. Maybe, goto stmt is possible. What is ...
Pavel Stehule
Jun 28, 2005 at 12:51 pm
Jun 29, 2005 at 4:40 pm -
Hi All, My company (EnterpriseDB) is very interested in helping to make ANSI-ISO SQL Stored Procedures part of standard BSD Postgres. The SQL/PSM standard is currently used in DB2 and is being ...
Denis Lussier
Jun 26, 2005 at 6:53 pm
Jun 29, 2005 at 4:21 pm -
Hi I have created a base table with a column id of type int. This table is inherited by a few subtables each of which have rows which satisfy a range of ids. The ranges are mutually exclusive. For ...
Rohit Gaddi
Jun 20, 2005 at 2:15 pm
Jun 21, 2005 at 12:26 pm -
During a recent training session I was reminded about a peculiar misbehavior that recent PostgreSQL releases exhibit when the TCP port they are trying to bind to is occupied: LOG: could not bind IPv4 ...
Peter Eisentraut
Jun 28, 2005 at 9:50 am
Jul 1, 2005 at 1:19 pm -
We don't yet have this functionality, as the patch allows for using second and later regex matches "()" in the replacement pattern. The function is misnamed. It should be called regex_replace_all() ...
David Fetter
Jun 6, 2005 at 4:11 pm
Jun 26, 2005 at 2:30 pm -
I've took a look at the TODO item Allow objects to be moved to different schemas I've done some code so far which implements the syntax ALTER [OBJECT] name SET SCHEMA name where OBJECT currently is ...
Bernd Helmle
Jun 8, 2005 at 6:23 pm
Jun 11, 2005 at 11:44 am -
I believe I have figured out the problem behind the recent reports we've been seeing of "index is not a btree" errors. Here's how to reproduce it (in 8.0 or HEAD): -- drop database test if present ...
Tom Lane
Jun 25, 2005 at 7:27 pm
Aug 4, 2005 at 8:22 am -
I looked into the r-tree breakage discussed in this thread: http://archives.postgresql.org/pgsql-general/2004-03/msg01135.php The executive summary: r-tree index opclasses contain four ...
Tom Lane
Jun 23, 2005 at 9:59 pm
Jun 27, 2005 at 3:57 pm -
Oh-ho, I see it: (gdb) bt #0 0x000000004489fba4 in memcpy () from /usr/lib/libc.so.34.2 #1 0x0000000000326f9c in hash_search (hashp=0xa6e030, keyPtr=0xa5ff90, action=HASH_ENTER, foundPtr=0x0) at ...
Tom Lane
Jun 18, 2005 at 7:05 pm
Jun 20, 2005 at 6:38 pm -
Ok, I already realized WAL in GiST and tested with online backup. It works. Now I need test it on recovery after crash (power loss etc) and there is a problem in GiST with incompleted inserts, I ...
Teodor Sigaev
Jun 10, 2005 at 4:24 pm
Jun 20, 2005 at 8:28 am -
Ciprian Popovici discovered an entirely new way to break the safety interlocks that are meant to prevent you from starting a postmaster in a data directory of the wrong version: ...
Tom Lane
Jun 30, 2005 at 2:55 pm
Jul 1, 2005 at 4:49 pm -
I need your advice. For on-disk bitmap I run a list of TIDs. TIDs are stored in pages as an array, page's opaque data holds an array of bits, indicating whether corresponding TID has been deleted and ...
Victor Y. Yegorov
Jun 6, 2005 at 8:00 pm
Jun 9, 2005 at 3:17 am -
Is there any reason for us to keep putting the language handler functions in the public schema? If they were put in, say, pg_catalog (as I see Peter's pl/sh language does for its handler) then the ...
Andrew Dunstan
Jun 24, 2005 at 12:01 am
Jul 10, 2005 at 2:26 pm -
By analogy, array_upper('{}'::TEXT[], 1) should return 0 instead of NULL. Markus -- Markus Bertheau ☭ <twanger@bluetwanger.de
Markus Bertheau ☭
Jun 6, 2005 at 2:17 pm
Jun 27, 2005 at 9:39 am -
Folks, There's no time to do this for 8.1, but I'd like to get it on the books for 8.2: The Problem: Occassionally a DBA needs to dump a database to a new encoding. In instances where the current ...
Josh Berkus
Jun 28, 2005 at 7:08 pm
Jul 10, 2005 at 3:09 pm -
I just got this regression failure on Windows: ================== pgsql.2220/src/test/regress/regression.diffs =================== *** ./expected/prepared_xacts.out Thu Jun 23 10:20:28 2005 --- ...
Andrew Dunstan
Jun 23, 2005 at 3:09 pm
Jun 24, 2005 at 3:52 am -
Sweating over the logic of the theorem prover, I notice it doesn't actually bother to complete an accurate test. I can't see that it produces an error, but I thought I would raise it, if only to ...
Simon Riggs
Jun 21, 2005 at 7:56 pm
Jun 23, 2005 at 3:55 pm -
I'm still playing around with the ALTER OBJECT SET SCHEMA stuff. I managed to alter indexes and constraints as well for tables, but with SERIAL sequences there is one little problem: When altering a ...
Bernd Helmle
Jun 27, 2005 at 11:43 pm
Jun 30, 2005 at 4:01 pm -
Hello Statement CONTINUE isn't in PL/SQL too, I know it, but Oracle PL/SQL has statement GOTO. I don't need GOTO statement, but 'continue' can be very usefull for me. I have to do some ugly trick ...
Pavel Stehule
Jun 16, 2005 at 4:32 pm
Jun 16, 2005 at 7:44 pm -
Well, there are a number of issues whenever a single query references a whole lot of tables in any fashion. It's only with Neil Conway's rewrite of the List package in 8.0 that we had any hope of ...
Tom Lane
Jun 10, 2005 at 6:10 am
Jun 16, 2005 at 12:36 pm -
It seems that currently we do not allow modifying a table while an index is built on it (at least my experience and some small tests I did indicate it). Strangely I did not find a TODO item for it, ...
Hannu Krosing
Jun 10, 2005 at 8:34 am
Jun 13, 2005 at 12:10 pm -
Does anyone understand why the precedence of % is strange: test= select -25 % -10; ?column? ---------- -35 (1 row) test= select -25 % (-10); ?column? ---------- -5 (1 row) Is it treating the first as ...
Bruce Momjian
Jun 4, 2005 at 3:56 am
Jun 5, 2005 at 3:53 am -
Hello The concept is from Oracle 9i, but with some changes. http://www.oracle-10g.de/oracle_10g_documentation/appdev.101/b10807/05_colls.htm#i35672 Associative arrays are any arrays with index. Will ...
Pavel Stehule
Jun 29, 2005 at 3:59 pm
Jun 29, 2005 at 8:25 pm -
Hi. I've been working on making it possible for PL/Perl users to fetch large result sets one row at a time (the current spi_exec_query interface just returns a big hash). The idea is to have ...
Abhijit Menon-Sen
Jun 12, 2005 at 9:24 am
Jun 24, 2005 at 4:00 pm -
Folks, Going over some performance test results at OSDL, our single greatest performance issue seems to be checkpointing. Not matter how I fiddle with it, checkpoints seem to cost us 1/2 of our ...
Josh Berkus
Jun 21, 2005 at 6:59 pm
Jun 22, 2005 at 7:59 pm -
Hi, I'm writing an application with a lot of PL/pgSQL and am constructing SQL queries on the fly. The quote_literal() and quote_ident() functions proved very much needed. Similarly, I need functions ...
Markus Bertheau ☭
Jun 20, 2005 at 1:08 pm
Jun 20, 2005 at 2:43 pm -
Hi all, CREATE TYPE my_type AS ( a int, b int, c int, d int, e int ); CREATE FUNCTION text_to_my_type(text) RETURNS my_type AS 'my_lib.so' LANGUAGE 'C' IMMUTABLE STRICT; CREATE CAST (text AS my_type) ...
John Hansen
Jun 18, 2005 at 11:18 am
Jun 18, 2005 at 2:14 pm -
hey all, I'm trying to convince some people here to adopt either mysql or postgresql as a relational database here.. However, we can't start from a clean slate; we have a very mature oracle database ...
Edward Peschko
Jun 6, 2005 at 8:00 pm
Jun 13, 2005 at 11:14 pm -
How are ppl using this? I'm trying to use it to re-configure, having tried both tcsh and bash, and neither seem to 'work': # ./configure `pg_config --configure` configure: error: invalid variable ...
Marc G. Fournier
Jun 9, 2005 at 2:35 am
Jun 9, 2005 at 6:15 pm -
Hi! Now that we have both WAL logging and better concurrency for GiST indexes (great job btw, this will push at least one of my projects into using 8.1 the day it is released - or more likely, at RC ...
Magnus Hagander
Jun 27, 2005 at 1:51 pm
Jul 1, 2005 at 6:00 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 181 |
posts | 1,576 |
users | 149 |
website | postgresql.org... |
irc | #postgresql |
149 users for June 2005
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)