FAQ

PostgreSQL > pgsql-hackers > June 2005

Search Discussions

181 discussions - 1,576 posts

  • 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 MomjianBruce 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 BerkusJosh 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 BerkusJosh 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 PageDave 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 FrostStephen 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 MomjianBruce Momjian
    Jun 21, 2005 at 4:04 am
    Jul 6, 2005 at 10:39 pm
  • Seems fine. Regards, Andreas
    Andreas PflugAndreas 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? ... John
    John HansenJohn Hansen
    Jun 15, 2005 at 1:53 am
    Jun 18, 2005 at 4:56 pm
  • Here are the open items. Feature freeze is Friday, July 1. --------------------------------------------------------------------------- PostgreSQL 8.1 Open Items ========================= Current ...
    Bruce MomjianBruce 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 LaneTom 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 ConwayNeil 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 TakahiroITAGAKI 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 PageDave 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 CramerDave 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 SigaevTeodor 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 LaneTom 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 BerkusJosh 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 DunstanAndrew 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 HaganderMagnus 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 LaneTom 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 StehulePavel 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 LussierDenis 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 GaddiRohit 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 EisentrautPeter 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 FetterDavid 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 HelmleBernd 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 LaneTom 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 LaneTom 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 LaneTom 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 SigaevTeodor 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 LaneTom 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. YegorovVictor 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 DunstanAndrew 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 ☭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 BerkusJosh 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 DunstanAndrew 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 RiggsSimon 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 HelmleBernd 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 StehulePavel 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 LaneTom 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 KrosingHannu 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 MomjianBruce 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 StehulePavel 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-SenAbhijit 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 BerkusJosh 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 ☭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 HansenJohn 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 PeschkoEdward 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. FournierMarc 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 HaganderMagnus Hagander
    Jun 27, 2005 at 1:51 pm
    Jul 1, 2005 at 6:00 am
Jun 2005
1234
Group Navigation
period‹ prev | Jun 2005 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions181
posts1,576
users149
websitepostgresql.org...
irc#postgresql

149 users for June 2005

Tom Lane: 296 posts Bruce Momjian: 141 posts Josh Berkus: 66 posts Andrew Dunstan: 62 posts Alvaro Herrera: 47 posts Dave Page: 44 posts Marc G. Fournier: 37 posts Christopher Kings-Lynne: 36 posts Simon Riggs: 30 posts Andreas Pflug: 29 posts Jonah H. Harris: 27 posts Stephen Frost: 27 posts John Hansen: 26 posts Matthew T. O'Connor: 24 posts Neil Conway: 24 posts Qingqing Zhou: 24 posts Pavel Stehule: 22 posts Greg Stark: 21 posts Jim C. Nasby: 21 posts Robert Treat: 21 posts
show more
Archives