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

== PostgreSQL Weekly News - February 08 2009 ==

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: == PostgreSQL Weekly News - February 08 2009 ==
Date: 2009-02-09 06:01:43
Message-ID: (view raw or whole thread)
Lists: pgsql-announce
== PostgreSQL Weekly News - February 08 2009 ==

PostgreSQL 8.3.6, 8.2.12, 8.1.16, 8.0.20 and 7.4.24 released.  Upgrade!

PostgreSQL Conference East 2nd Call for Papers ends February 23, 2009.

If you'd like to stuff folders at the LAPUG Pizza Party, Friday,
February 20th at the Westin in Los Angeles, write to lapug AT
postgresql DOT org to volunteer.

== PostgreSQL Product News ==

pgpool-II 2.2 beta2 released.

== PostgreSQL Tip of the Week ==

Until 8.4 comes out with a super-effient native one, you can add the
array_accum() function in the PostgreSQL documentation for rolling up
any column into an array, which can then be used by application code,
or combined with array_to_string() to format it as a list:

== PostgreSQL Jobs for February ==

== PostgreSQL Local ==

JNBPUG will be meeting February 9 19:00 at News Cafe on New Road in

Stephen Frost will be talking about column-level permissions at BWPUG
February 9 at 6:30pm in the OmniTI offices.

Prague PostgreSQL Developers' Day 2009 will be on February 12, 2009

The Bulgarian PostgreSQL Users' Group will be meeting February 12,
2009 at 7pm at Vinarnata, 19 Lavele str., Sofia.

SFPUG presents: Reece Hart on Unison DB for Computational Biology.
February 10, 2009, location to be announced.

PostgreSQL will be at SCALE February 20-22 in Los Angeles.

Andreas 'ads' Scherbaum will be presenting a talk at Perl Workshop
2009 on February 25 in Frankfurt am Main, Germany.

PostgreSQL Conference, U.S. will be holding a PgDay at LinuxFest
Northwest (April 25/26th). The call for papers is out at

PGCon 2009 will be held 21-22 May 2009, in Ottawa at the University of
Ottawa.  It will be preceded by two days of tutorials on 19-20 May

PGCon Brazil will be take place October 23-24 2009 at Unicamp in
Campinas, Sao Paulo state.

== PostgreSQL in the News ==

Planet PostgreSQL:

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

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

== Applied Patches ==

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/catalogs.sgml, put pg_user_mapping section
  into the right (alphabetical) order.

- In pgsql/src/backend/catalog/sql_features.txt, set column privileges
  to supported.

Michael Meskes committed:

- Fixed bug in ecpg's %s handling.

- Fixed auto allocation for binary data types in ecpg.

- In pgsql/src/interfaces/ecpg/test/sql/binary.pgc, set memory segment
  to '0', just to be sure.

- In ecpg, when changing a regression test file one should also change
  the expected output file.

- In pgsql/src/interfaces/ecpg/ecpglib/execute.c, fixed copy&paste
  mistake that made library use uninitialized variable.

- In pgsql/src/interfaces/ecpg/ecpglib/execute.c, argh, wrong line
  copied again.

- In ecpg, added result checks for calls to gmtime().

- In pgsql/src/interfaces/ecpg/pgtypeslib/dt_common.c, mixing long and
  int entries of a union only works on some architectures.

Alvaro Herrera committed:

- Allow reloption names to have qualifiers, initially supporting a
  TOAST qualifier, and add support for this in pg_dump.  This allows
  TOAST tables to have user-defined fillfactor, and will also enable
  us to move the autovacuum parameters to reloptions without taking
  away the possibility of setting values for TOAST tables.

- Fix some SGML-compiler warnings on -wxml mode.

Andrew Dunstan committed:

- Provide for parallel restoration from a custom format archive. Each
  data and post-data step is run in a separate worker child (a thread
  on Windows, a child process elsewhere) up to the concurrent number
  specified by the new pg_restore command-line --multi-thread | -m
  switch.  Andrew Dunstan, with some editing by Tom Lane.

- Allow alternative names for tclsh used on Windows.

Tom Lane committed:

- In pgsql/src/pl/plpgsql/src/gram.y, fix plpgsql to not treat INSERT
  INTO as an INTO-variables clause anywhere in the string, not just at
  the start.  Per bug #4629 from Martin Blazek.  Back-patch to 8.2;
  prior versions don't have the problem, at least not in the reported
  case, because they don't try to recognize INTO in non-SELECT
  statements.  (IOW, this is really fallout from the RETURNING patch.)

- In pgsql/doc/src/sgml/ref/select.sgml, document the longstanding
  behavior of LIMIT NULL and OFFSET NULL, per gripe from David Wheeler
  that this was mentioned nowhere.  In passing, editorialize a bit on
  the description of the SQL:2008 equivalent syntax.

- In pgsql/src/backend/postmaster/syslogger.c, add a failure check for
  syslogger's use of _beginthreadex(), and remove unnecessary thread
  address output parameter, to make this code look more like that in

- In pgsql/src/backend/optimizer/path/joinpath.c, fix an old
  corner-case error in match_unsorted_outer(): don't consider the
  cheapest-total inner path as a new candidate while truncating the
  sort key list, if it already matched the full sort key list.  This
  is too much of a corner case to be worth back-patching, since it's
  unusual for the cheapest total path to be sorted, and anyway no real
  harm is done (except in JOIN_SEMI/ANTI cases where cost_mergejoin is
  a bit broken at the moment).  But it wasn't behaving as intended, so
  fix it.  Noted while examining a test case from Kevin Grittner.
  This error doesn't explain his issue, but it does explain why "set
  enable_seqscan = off" seemed to reproduce it for me.

- Clean up some loose ends from the column privileges patch: add
  has_column_privilege and has_any_column_privilege SQL functions; fix
  the information_schema views that are supposed to pay attention to
  column privileges; adjust pg_stats to show stats for any column you
  have select privilege on; and fix COPY to allow copying a subset of
  columns if the user has suitable per-column privileges for all the
  columns.  To improve efficiency of some of the information_schema
  views, extend the has_xxx_privilege functions to allow inquiring
  about the OR of a set of privileges in just one call.  This is just
  exposing capability that already existed in the underlying aclcheck
  routines.  In passing, make the information_schema views report the
  owner's own privileges as being grantable, since Postgres assumes
  this even when the grant option bit is not set in the ACL.  This is
  a longstanding oversight.  Also, make the new has_xxx_privilege
  functions for foreign data objects follow the same coding
  conventions used by the older ones.  Stephen Frost and Tom Lane

- In pgsql/doc/src/sgml/ref/copy.sgml, ooops, forgot to update COPY
  reference page to mention column privileges.

- Fix cost_mergejoin's failure to adjust for rescanning of non-unique
  merge join keys when considering a semi or anti join.  This requires
  estimating the selectivity of the merge qual as though it were a
  regular inner join condition.  To allow caching both that and the
  real outer-join-aware selectivity, split RestrictInfo.this_selec
  into two fields.  This fixes one of the problems reported by Kevin

- In pgsql/src/backend/executor/execMain.c, ensure that INSERT ...
  SELECT into a table with OIDs never copies row OIDs from the source
  table.  This could never happen anyway before 8.4 because the
  executor invariably applied a "junk filter" to rows due to be
  inserted; but now that we skip doing that when it's not necessary,
  the case can occur.  Problem noted 2008-11-27 by KaiGai Kohei,
  though I misunderstood what he was on about at the time (the opacity
  of the patch he proposed didn't help).

Bruce Momjian committed:

- In pgsql/doc/src/sgml/mvcc.sgml, update read committed documentation
  to better explain undesirable behavior of concurrent commands in
  cases where rows are being added and removed from matching query
  criteria.  Minor word-smithing.

  statement.  Pavel Stehule.

- In pgsql/doc/src/sgml/libpq.sgml, document ways to avoid libpq
  WSACleanup() overhead on Windows.  Andrew Chernow.

- In pgsql/doc/src/sgml/libpq.sgml, fix typo in docs.

- Fix to_timestamp() to not require upper/lower case matching for
  meridian designations (AM/PM).  Also separate out matching of a
  meridian with periods (e.g. A.M.) and with those without.  Do the
  same for AD/BC.  Brendan Jurd

- Document disabling the statistics collector pg_dump activity, and
  give a bit more visibility to the PGOPTIONS environment variable
  supported by libpq.  Bryce Nesbitt

- In pgsql/doc/src/sgml/catalogs.sgml, update pg_constraint.conkey
  documentation description.

- In pgsql/doc/src/sgml/ref/pg_dump.sgml, properly wrap new pg_dump
  doc text.

- In pgsql/src/interfaces/ecpg/ecpglib/Makefile, ecpg requires libpq;
  add Makefile rules to require libpq to be built first.  Alvaro

- In pgsql/doc/src/sgml/catalogs.sgml, uppercase CHECK mention in
  relchecks documentation mention.

- In pgsql/doc/src/sgml/indices.sgml, remove documentation mention
  that hash indexes perform no better than btree;  keep mention about
  missing WAL logging.  Kenneth Marshall

- In pgsql/doc/src/sgml/queries.sgml, document that LIMIT NULL is the
  same as no LIMIT clause.  Report by David Wheeler.

Heikki Linnakangas committed:

- In pgsql/src/backend/access/transam/xlog.c, fix obsolete comment.
  Zdenek Kotala.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Fernando Ike de Oliveira sent in another revision of his patch to add
\dL (show languages) to psql.

David Wheeler sent in a doc patch to explicate that LIMIT NULL returns
all rows.

Zdenek Kotala sent in a fix for Czech (cs_CZ) locale regression tests.

Stephen Frost sent in another revision of his column-level privileges

Teodor Sigaev sent in another revision of his GIN improvements patch.

KaiGai Kohei sent in another revision of his SE-PostgreSQL patches.

Alvaro Herrera sent in another revision of the reloptions patch to
remove autovacuum parameters.

Peter Eisentraut sent in a patch to add basic KOI8-U support.

Alvaro Herrera sent in a doc patch for the reloptions patch.

David Lee Lambert sent in a patch which lets Linux use the ext2fs UUID
generator for UUIDs.

Tom Lane sent in a patch to make ALTER TABLE SET WITH OIDS actually
add the aforementioned OIDs.

pgsql-announce by date

Next:From: Guillaume LelargeDate: 2009-02-09 07:08:00
Subject: Re: Re: [ANNOUNCE] Subject: Let's Postgres, new PostgreSQL resource portal site opened.
Previous:From: Tatsuo IshiiDate: 2009-02-07 23:52:18
Subject: Re: Re: [ANNOUNCE] Subject: Let's Postgres, new PostgreSQL resource portal site opened.

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