== PostgreSQL Weekly News - February 01 2009 ==

== PostgreSQL Weekly News - February 01 2009 ==

Bug fix releases for the 8.3, 8.2, 8.1, 8.0 and 7.4 series will be out
soon. Get ready to upgrade!

Greg Smith posted version 0.90 of pgtune on pgfoundry.
http://pgfoundry.org/projects/pgtune/

The Bulgarian PostgreSQL Users' Group will be meeting February 12,
2009 at 7pm at Vinarnata, 19 Lavele str., Sofia.
http://www.doodle.com/participation.html?pollId=vb788q7v8ybi4z39

== PostgreSQL Product News ==

Archiveopteryx 3.0.6, a mail system based on PostgreSQL, released.
http://www.archiveopteryx.org/3.0.6

Pgbuildfarm 3.2 client code is out. Upgrade!
http://pgfoundry.org/frs/download.php/2069/build-farm-3_2.tgz

== PostgreSQL Tip of the Week ==

Need to make only part of your table unique, such as making only the
usernames of active users unique? Use a Partial Unique Index:
CREATE UNIQUE INDEX ON logins ( username ) WHERE active = true;

== PostgreSQL Local ==

Richard Broersma is coordinating booth volunteers for SCALE (below).
Contact him at richard DOT broersma AT gmail DOT com.

SYDPUG will be meeting February 3, 2009 at 6:30pm at Fujitsu Australia
in North Syndey. Mark Leslie will talk about the history and
motivations of PostGIS.
http://archives.postgresql.org/sydpug/2009-01/msg00000.php

Many of the usual suspects will be at FOSDEM February 7-8 in Brussels,
Belgium. More information and the schedule are available at:
http://wiki.postgresql.eu/wiki/FOSDEM_2009

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

Stephen Frost will be talking about column-level permissions at BWPUG
February 9 at 6:30pm in the OmniTI offices.
http://pugs.postgresql.org/bwpug

Prague PostgreSQL Developers' Day 2009 will be on February 12, 2009
http://www.postgresql.org/about/event.808
Schedule:
http://www.postgres.cz/p2d2/2009/sched_en.html

SFPUG presents: Reece Hart on Unison DB for Computational Biology.
February 10, 2009, location to be announced.
http://postgresql.meetup.com/1/calendar/9351228/

PostgreSQL will be at SCALE February 20-22 in Los Angeles.
http://www.socallinuxexpo.org/

Andreas 'ads' Scherbaum will be presenting a talk at Perl Workshop
2009 on February 25 in Frankfurt am Main, Germany.
http://www.perl-workshop.de/talks/151/view

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

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
2009.
http://www.pgcon.org/2009/papers.php

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

== PostgreSQL in the News ==

Planet PostgreSQL: http://planet.postgresql.org/

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:

- Message format tuning in ecpg.

- Revert updatable views.

- Message fix in pgsql/src/interfaces/ecpg/preproc/parse.pl

- Translation updates.

- In pgsql/src/interfaces/ecpg/preproc/ecpg.c, whitespace fix in
message.

- In ecpg, Make messages consistent with existing ones.

Alvaro Herrera committed:

- Allow extracting and parsing of reloptions from a bare pg_class
tuple, and refactor the relcache code that used to do that. This
allows other callers (particularly autovacuum) to do the same
without necessarily having to open and lock a table.

Magnus Hagander committed:

- In pgsql/src/backend/utils/adt/pg_locale.c, silence compiler
warnings in new win32 locale code when building on mingw. ITAGAKI
Takahiro.

- In pgsql/src/test/regress/pg_regress.c, silence compiler warning on
win32. ITAGAKI Takahiro

- In pgsql/src/bin/pg_ctl/pg_ctl.c, support running as a service on
Windows 7, by not specifying the JOB_OBJECT_UILIMIT_HANDLES flag.
Dave Page & Magnus Hagander

- Go over all OpenSSL return values and make sure we compare them to
the documented API value. The previous code got it right as it's
implemented, but accepted too much/too little compared to the API
documentation. Per comment from Zdenek Kotala.

- In pgsql/src/test/regress/pg_regress.c, change warning-silencing
code not to cast the pointer type, instead casting the value of the
variable later. Per comments from Tom Lane.

Teodor Sigaev committed:

- In pgsql/contrib/tsearch2/tsearch2.c, fix bug with multiple
evaluation of tsearch2 compatibility trigger, trigger data should be
restored. Backpatch only to 8.3 because previous versions don't
have such layer.

- In pgsql/src/backend/tsearch/spell.c, fix incorrect dereferencing of
char* to array's index. Per report from Tommy Gildseth.

Tom Lane committed:

- Replace argument-checking Asserts with regular test-and-elog checks
in all encoding conversion functions. These are not can't-happen
cases because it's possible to create a conversion with the wrong
conversion function for the specified encoding pair. That would
lead to an Assert crash in an Assert-enabled build, or incorrect
conversion otherwise, neither of which is desirable. This would be
a DOS issue if production databases were customarily built with
asserts enabled, but fortunately that's not so. Per an observation
by Heikki. Back-patch to all supported branches.

- Update time zone data files to tzdata release 2009a: introduces
Asia/Kathmandu as the preferred spelling of that zone name, corrects
historical DST information for Switzerland and Cuba.

- In pgsql/doc/src/sgml/release.sgml, update back-branch release
notes.

- Defend against null input in analyze_requires_snapshot(), per report
from Rushabh Lathia. Back-patch of patch of 2009-01-08. This is
necessary in 8.3, as reported by Bjorn Munch. It's not currently
necessary in 8.2, AFAICS, but seems best to include it there too.

- In pgsql/src/backend/utils/adt/arrayfuncs.c, fix unnest() to handle
a toasted input array safely. Per report from Alvaro Herrera.

Heikki Linnakangas committed:

- Check that connection limit is within valid range. IOW, not < -1.
It's missing in older versions too, but it doesn't seem worth
back-porting. All negative are just harmlessly treated as "no
limit", and tightening the check might even brake an application
that relies on it.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

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

KaiGai Kohei sent in two doc patches atop his SE-PostgreSQL patches.

Brendan Jurd sent in an updated patch to correct the meridiem markers.

Zdenek Kotala sent in another revision of his space reservation patch.

Fujii Masao sent in another revision of the synchronous replication
patch.

Simon Riggs sent in a bug fix atop the Hot Standby patch.

Heikki Linnakangas sent in two more revisions of the Recovery
Infrastructure patch.

Kenneth Marshall sent in another revision of the updated hash
functions patch.

Timo Savola sent in a patch which allows people to set a sample
percentage for logging.

Alvaro Herrera sent in two more revisions of his patch to add
namespaces to reloptions.

Fernando Ike de Oliveira sent in a patch to add \dL, which lists
languages, to psql.

Andrew Dunstan sent in another revision of his parallel pg_dump patch.

Euler Taveira de Oliveira sent in two patchs atop Alvaro Herrera's
reloptions patch.

Hiroshi Saito sent in three revisions of a patch to generate a
.def (DLL symbol export) file for the event log plugin on mingw.

Robert Haas sent in a patch to optimize add_path in the planner.