Skip site navigation (1) Skip section navigation (2)

== PostgreSQL Weekly News - October 08 2006 ==

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: == PostgreSQL Weekly News - October 08 2006 ==
Date: 2006-10-09 05:57:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announce
== PostgreSQL Weekly News - October 08 2006 ==

The University of California, Davis, is studying how open source
software is made through PostgreSQL, Apache and Python:

AnyWebDb wants PostgreSQL beta testers.

== PostgreSQL Product News ==

Continuent uni/cluster replication software released.

Red Hat Inc. announced their new application development stack, which
includes support for PostgreSQL. has released an OLAP Cube solution for PostgreSQL.

pgAdmin III v1.6 Beta 2 released.  Please test.

Navicat PostgreSQL 6.3.1 for OS/X and Navicat PostgreSQL 7.2.6 for
Windows released.

3CX VOIP Phone System for Windows released.

== PostgreSQL Jobs for October ==

== PostgreSQL Local ==

French PostgreSQL company Dalibo has just hired Stephane Schildknecht
(SAS), French PostgreSQL association president.  Kudos to both.

== PostgreSQL in the News ==

Planet PostgreSQL:

This Week in General Bits:
Renumbering with COPY, Functional Indexes, and Deferrable UNIQUE
Constraints with SET CONSTRAINTS.

PostgreSQL Weekly News is brought to you this week by David Fetter,
Josh Berkus and Dave Page.

== Applied Patches ==

Bruce Momjian committed:

- Update multi-line editing wording in release notes.

- In release notes, mention that multi-line history saving does not
  work on Win32.

- Add include needed for new getrusage() call to

- Update comments for pgcvslog, -r BASE does not work with cvs log.

- In release notes, always use </link> rather than </>.

- Add main documentation link tags to the release notes.

- Add indenting to Solaris FAQ, for clarity.

- Andreas Seltenreich' update to the DB2X texinfo example code.

- Update Solaris strtol() bug comment.

- Update Solaris strtod() bug comment.

- Zdenek Kotala's patch which update the Solaris FAQ.

- Exclude pgindent from affecting the ecpg regression directory.

- Add URL about strlcpy() creation history to strlcpy.c.

- Add 'Fix SSL retry to avoid useless repeated connection attempts and
  ensuing misleading error messages' to TODO.

- Add URL for strlcpy() to TODO

- David Wheeler's patch that mentioning in postgresql.conf that
  autovacuum also needs stats_start_collector and stats_row_level to
  be on as well.

- Guillaume Lelarge's patch which fixes a small typo in

- Move WIN32_ONLY_COMPILER define from c.h to win32.h because it was
  being defined too late.

- Simon Riggs's updated recovery (PITR) documentation.

- Updated tsearch2 README for current version.

- Add URL for cached copy of paper as SGML comment.

- Changed TODO to reflect use of strlcopy rather than PostgreSQL's
  StrNCpy() macro

- Kenneth Marshall's change which removes mention of the -fast option
  from the Solaris FAQ.

- Add Magnus Hagander's note to release notes: "Drop privileges on
  startup so servers can be started from an administrative account"

- Move "Exotic Features" to the bottom of TODO.

- David Fetter's patch correcting an error message for overflow of
  NUMERIC types.

- Euler Taveira de Oliveira's patch which make some sentences
  consistent with similar ones in the source.

- Andreas Seltenreich's patch which improves readline psql prompt

- Andreas Seltenreich's patch which adds experimental support for db2x

- ITAGAKI Takahiro's patch which changes units of the some default
  values in postgresql.conf, modifies initdb to write MB-unit values.
  Anything over 8000kB is now rounded out to MB.  Adds
  GUC_UNIT_XBLOCKS for wal_buffers, which is like GUC_UNIT_BLOCKS,
  but uses XLOG_BLCKSZ instead of BLCKSZ.  Cleans up the tests of
  GUC_UNIT_* flags in preparation to add more unit flags in fewer

- Clean up pgwin32_open() 'if' test, and avoid possible error.

- Martijn van Oosterhout's patch which fixes a yesno_prompt() memory
  leak in /script tools, reported by Coverity.

- Update typedef list for 8.2 pgindent run.

- Magnus Hagander's patch which makes vcbuild actually build the
  pgevent dll and changes the pgevent DLL file so it doens't specify
  ordinal for the functions.

Tom Lane committed:

- Fix back-branch pg_regress scripts to try the "canonical" expected
  file if we tried a variant file from resultmap and it didn't match.
  This is already done in HEAD's C-code version, and is needed
  because OpenBSD has recently migrated to a more standard handling
  of float underflow --- see buildfarm results from emu.

- Update Darwin dlopen() support to avoid deprecation warnings with
  latest Apple developer tools.  We now use dlopen directly if
  available, and fall back to the older code if not.  Per Chris

- On Windows, we know the backend stack size limit because we have to
  specify it explicitly in backend/Makefile.  Arrange for this value
  to be known by get_stack_depth_rlimit() too.  Per suggestion from
  Magnus Hagander.

- Fix ancient oversight in psql's \d pattern processing code: when
  seeing two quote chars inside quote marks, should emit one quote
  *and stay in inquotes mode*.  Back-patched through 7.3.

- Fix thinko in comment in pgsql/src/port/pgstrcasecmp.c.

- When planning a query at Bind time, be careful to pass the correct
  query_list into the Portal, ie, the one seen and possibly modified
  by the planner.  Per report from Sergey Koposov.

- On platforms that have getrlimit(RLIMIT_STACK), use it to ensure
  that max_stack_depth is not set to an unsafe value.  This commit
  also provides configure-time checking for <sys/resource.h>, and
  cleans up some perhaps-unportable code associated with use of that
  include file and getrlimit().

- Adjust HINT for stack depth limit to mention checking the underlying
  platform limit, rather than just blindly raising max_stack_depth.
  Also, tweak the code to work properly if someone sets
  max_stack_depth to more than 2Gb, which guc.c will allow on a
  64-bit machine.

- Fix string_to_array() to correctly handle the case where there are
  overlapping possible matches for the separator string, such as
  string_to_array('123xx456xxx789', 'xx').  Also, revise the logic of
  replace(), split_part(), and string_to_array() to avoid O(N^2) work
  from redundant searches and conversions to pg_wchar format when
  there are N matches to the separator string.

- Fix bcc32.mak to create and remove pg_config_os.h properly.
  Apparently win32.mak got patched for this, but not bcc32.mak.

- Fix SysCacheGetAttr() to handle the case where the specified
  syscache has not been initialized yet.  This can happen because
  there are code paths that call SysCacheGetAttr() on a tuple
  originally fetched from a different syscache (hopefully on the same
  catalog) than the one specified in the call.  It doesn't seem
  useful or robust to try to prevent that from happening, so just
  improve the function to cope instead.  Per bug 2678 from Jeff

- Cleanup for pglz_compress code: remove dead code, const-ify API of
  remaining functions, simplify pglz_compress's API to not require a
  useless data copy when compression fails.  Also add a check in
  pglz_decompress that the expected amount of data was decompressed.

- Work around buggy strtod on (some versions of?) IRIX.  Combination
  of proposed patches from John Jorgensen and Steve Singer.

- Second try at fixing libedit configuration for Bob Friesenhahn.
  Buildfarm results from 'gazelle' show that there are indeed libedit
  versions for which history.h is a needed header, even though it's
  apparently been dropped entirely in other versions.

- Adjust configure's handling of libedit to not look for a history.h
  file.  Per Bob Friesenhahn's report, this file is not supplied by
  some versions of libedit, and even when it is supplied it seems to
  be just a link to readline.h, so we don't need to include it
  anyway.  Also, ensure that we won't try to use a too-old version of
  Bison.  The previous coding would bleat but then use it anyway;
  better to invoke the 'missing' script if any grammar files need to
  be rebuilt.

- Fix initdb's logic for picking shared_buffers/max_fsm_pages, which
  had gotten rather thoroughly whacked out by careless recent
  changes: the intended ratio between the two was off by a lot, and
  the minimum number of shared buffers tried had increased by a lot.
  Problem exposed by failures on buildfarm members with smaller
  SHMMAX values.

- In postgresql.conf.sample, fix wal_buffers comment to agree with

- Improve error messages from to_tsquery per yesterday's discussion:
  provide the bad input, and be sure to mention that we are talking
  about a tsearch query.

- Add qsort and qsort_arg to MSVC list of src/port files.

- Magnus Hagander's patch which rearranges MSVC errcode hack and fixes
  incorrect _MSC_VER test.

- Switch over to using our own qsort() all the time, as has been
  proposed repeatedly.  Now that we don't have to worry about memory
  leaks from glibc's qsort, we can safely put CHECK_FOR_INTERRUPTS
  into the tuplesort comparators, as was requested a couple months
  ago.  Also, get rid of non-reentrancy and an extra level of
  function call in tuplesort.c by providing a variant qsort_arg() API
  that passes an extra void * argument through to the comparison

Michael Meskes committed:

- Revert changes made by pgindent, make show.pgc set all variables
  before displaying them.

Peter Eisentraut committed:

- Updated keyword table for 8.2

- Added missing entry (CASCADED) in keywords table.

- Updated config.guess and config.sub

- The -X option in pg_dump was supposed to be a workaround for the
  lack of portable long options, but we have had portable long
  options for a long time now, so this is obsolete.  People have
  added options which *only* work with -X but not as regular long
  option, so I'm putting a stop to this: -X is deprecated; it still
  works, but it has been removed from the documentation, and please
  don't add more of them.  

- Message style improvements

Neil Conway committed:

- Fix a typo in release notes.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Magnus Hagander sent in a patch which adds a version check for bison
when running the vc++ build.

pgsql-announce by date

Next:From: Marian POPESCUDate: 2006-10-09 08:52:32
Subject: Re: pgAdmin III v1.6 Beta 2 Released
Previous:From: CeesDate: 2006-10-08 21:04:44
Subject: Re: [ANNOUNCE] pgAdmin III v1.6 Beta 2 Released

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group