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

== PostgreSQL Weekly News - August 05 2007 ==

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: == PostgreSQL Weekly News - August 05 2007 ==
Date: 2007-08-05 18:28:00
Message-ID: 20070805182800.GA3967@fetter.org (view raw or flat)
Thread:
Lists: pgsql-announce
== PostgreSQL Weekly News - August 05 2007 ==

Andreas (ads) Scherbaum is no longer single.

There was an extensive discussion on -advocacy about wikis.

== PostgreSQL Product News ==

Alinous-Core web/database language released.
http://alinous.org

pgpool 3.4 and pgpool-II 1.2 released
http://pgfoundry.org/projects/pgpool/

PostBooks 1.0 released.
http://www.xtuple.com/pb-gettingstarted

== PostgreSQL Jobs for August ==

http://archives.postgresql.org/pgsql-jobs/2007-08/threads.php

== PostgreSQL Local ==

David Fetter will be at Septimas Jornadas Regionales de Software
Libre.  http://jornadas.grulic.org.ar/7/

We will have a booth, a BOF and a dinner at LinuxWorldExpo: Join us!
Help us out!  http://developer.postgresql.org/index.php/LWESF2007

== PostgreSQL in the News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/

PostgreSQL Weekly News is brought to you this week by David Fetter

Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to david(at)fetter(dot)org, German to
pwn(at)pgug(dot)de(dot)

== Applied Patches ==

Magnus Hagander committed:

- Update supported standalone VC++ version to 7.1+ only, and fix some
  bad data leftover in win32.mak.  Per request from Hiroshi Saito.

Andrew Dunstan committed:

- Move session_start out of MyProcPort stucture and make it a global
  called MyStartTime, so that we will be able to create a cookie for
  all processes for CSVlogs.  It is set wherever MyProcPid is set.
  Take the opportunity to remove the now unnecessary session-only
  restriction on the %s and %c escapes in log_line_prefix.

- Make sure syslogPipe runs in binary mode on Windows to avoid
  corrupting the pipe chunking protocol.  Backport to 8.0

Neil Conway committed:

- Tweak for initdb: if more command-line arguments were specified than
  expected, exit with an error, rather than complaining about the
  error on stderr but continuing onward.

- In pgsql/src/backend/utils/sort/tuplestore.c, fix a memory leak in
  tuplestore_end(). Unlikely to be significant during normal
  operation, but tuplestore_end() ought to do what it claims to do.

Bruce Momjian committed:

- Mark TODO as done: "Allow buffered WAL writes and fsync."

- In pgsql/src/test/bench/runwisc.sh, fix strange quoting.

- In pgsql/src/test/bench/create.sh, fix script quoting problem.

- In pgsql/doc/FAQ_MINGW, remove links to old Win32 source code ports.

Tom Lane committed:

- In Fix up bad layout of some comments (probably pg_indent's fault), and
  improve grammar a tad.  Per Greg Stark.

- Fix crash caused by log_timezone patch if we attempt to emit any
  elog messages between the setting of log_line_prefix and the setting
  of log_timezone.  We can't realistically set log_timezone any
  earlier than we do now, so the best behavior seems to be to use GMT
  zone if any timestamps are to be logged during early startup.
  Create a dummy zone variable with a minimal definition of GMT (in
  particular it will never know about leap seconds), so that we can
  set it up without reference to any external files.

- Fix a problem in my recent patch to initialize cancel_key for
  autovac workers as well as regular backends: if no regular backend
  launches before the autovac launcher tries to start an autovac
  worker, the postmaster would get an Assert fault due to calling
  PostmasterRandom before random_seed was initialized.  Cleanest
  solution seems to be to take the initialization of random_seed out
  of ServerLoop and let PostmasterRandom do it for itself.

- Switch over to using the src/timezone functions for formatting
  timestamps displayed in the postmaster log.  This avoids
  Windows-specific problems with localized time zone names that are in
  the wrong encoding, and generally seems like a good idea to
  forestall other potential platform-dependent issues.  To preserve
  the existing behavior that all backends will log in the same time
  zone, create a new GUC variable log_timezone that can only be
  changed on a system-wide basis, and reference log-related
  calculations to that zone instead of the TimeZone variable.  This
  fixes the issue reported by Hiroshi Saito that timestamps printed by
  xlog.c startup could be improperly localized on Windows.  We still
  need a simpler patch for that problem in the back branches, however.

- Fix some sloppiness in the recent multiple-autovacuum-worker patch.
  It was not bothering to initialize is_autovacuum for regular
  backends, meaning there was a significant chance of the postmaster
  prematurely sending them SIGTERM during database shutdown.  Also,
  leaving the cancel key unset for an autovac worker meant that any
  client could send it SIGINT, which doesn't sound especially good
  either.

- Support an optional asynchronous commit mode, in which we don't
  flush WAL before reporting a transaction committed.  Data
  consistency is still guaranteed (unlike setting fsync = off), but a
  crash may lose the effects of the last few transactions.  Patch by
  Simon Riggs, some editorialization by Tom Lane.

- Fix a bug in the original implementation of redundant-join-clause
  removal: clauses in which one side or the other references both
  sides of the join cannot be removed as redundant, because that
  expression won't have been constrained below the join.  Per report
  from Sergey Burladyan.  CVS HEAD does not contain this bug due to
  EquivalenceClass rewrite, but it seems wise to include the
  regression test for it anyway.

- In pgsql/src/backend/executor/execUtils.c, if we're gonna use
  ExecRelationIsTargetRelation here, might as well simplify a bit
  further.

- Fix security definer functions with polymorphic arguments.  This
  case has never worked because fmgr_security_definer() neglected to
  pass the fn_expr information through.  Per report from Viatcheslav
  Kalinin.

== Pending Patches ==

Gregory Stark sent in a patch which creates a user-visible function to
make use of convert_to_scalar from SQL.



pgsql-announce by date

Next:From: Josh TolleyDate: 2007-08-07 16:43:30
Subject: pgsnmpd version 1.0 released
Previous:From: Tom LaneDate: 2007-08-03 03:27:29
Subject: Re: == PostgreSQL Weekly News - July 29 2007 ==

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