Peripheral Links
Header And Logo
Site Navigation
PostgreSQL Weekly News - June 08 2008
PostgreSQL 8.3.3, et al. will be out soon. Get ready to upgrade!
PostgreSQL Product News
pgAdmin III 1.8.4 released. http://www.pgadmin.org/
pgEdit 1.4 released. http://pgedit.com/
pgloader 2.3.1 released. http://pgfoundry.org/projects/pgloader/
PL/Proxy 2.0.5 released. http://pgfoundry.org/projects/plproxy/
SkyTools 2.1.7 released http://pgfoundry.org/projects/skytools/
PostgreSQL Jobs for June
http://archives.postgresql.org/pgsql-jobs/2008-06/threads.php
PostgreSQL Local
June's LAPUG meeting will be held at California Institute of Technology. Jaun Jose' Natera will be delivering a presentation on how PL-Perl can be used in PostgreSQL. http://pugs.postgresql.org/node/403
The Oklahoma PUG will hold it's first meeting on June 23 from 7:00 to 9:00 pm at Coach's in Norman, OK. http://pugs.postgresql.org/node/408
PDXPUG Meeting 6/19/08: The Relational Model http://pugs.postgresql.org/node/399
SFPUG June: Parsers & pgCon http://pugs.postgresql.org/node/403
PGDay will be in Portland the day before OSCON. http://pugs.postgresql.org/taxonomy/term/53
PGCon Brazil 2008 will be on September 26-27 at Unicamp in Campinas. http://pgcon.postgresql.org.br/index.en.html
PGDay.IT 2008 will be October 17 and 18 in Prato. http://www.pgday.org/it/
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@fetter.org, German language to pwn@pgug.de, Italian language to pwn@itpug.org.
Applied Patches
Tom Lane committed:
- In pgsql/src/bin/initdb/initdb.c, fix initdb to reject a relative path for -X (--xlogdir) argument. This doesn't work, and the real reason why not is it's unclear where the path is relative to (initdb's CWD, or the data directory?). We could make an arbitrary decision, but it seems best to make the user be unambiguous. Per gripe from Devrim.
- In pgsql/src/interfaces/ecpg/ecpglib/prepare.c, remove unused variable (was already done in HEAD).
- In pgsql/doc/src/sgml/release.sgml, draft release notes for upcoming back-branch updates.
- In pgsql/src/backend/utils/adt/ruleutils.c, fix pg_get_ruledef() so that negative numeric constants are parenthesized. This is needed because :: casting binds more tightly than minus, so for example -1::integer is not the same as (-1)::integer, and there are cases where the difference is important. In particular this caused a failure in SELECT DISTINCT ... ORDER BY ... where expressions that should have matched were seen as different by the parser; but I suspect that there could be other cases where failure to parenthesize leads to subtler semantic differences in reloaded rules. Per report from Alexandr Popov.
- In pgsql/doc/src/sgml/release.sgml, update release notes for 8.3.3 et al.
Michael Meskes committed:
- In ecpg, added lost sysmbol SQL_SQL to list of allowed variable names.
- In ecpg, added symbol SQL to list of allowed variables.
Alvaro Herrera committed:
- Change xlog.h to xlogdefs.h in bufpage.h, and fix fallout.
Rejected Patches (for now)
No one was disappointed this week :-)
Pending Patches
Joe Conway sent in another revision of his patch to fix dblink performance regression.
Davy Durham sent in another revision of his patch to allow pg_dump to add WHERE clauses to -t/--table arguments.
Heikki Linnakangas sent in another revision of his map forks patch.
Jan Urbanski sent in another revision of his patch, which extends VacAttrStats to allow typanalyze functions to store statistic values as a type different from that of the underlying column.
Pavel Stehule sent in another version of his patch which adds RETURNS TABLE functionality per SQL:2003.
Teodor Sigaev sent in another revision of his patch to speed up write operations on GIN indexes.
Pavel Stehule sent in a patch implementing an array_fill() function to initialize arrays with data.
Tom Lane sent in a patch which fixes DROP recursion and makes it faster at the cost of some memory.