Re: == PostgreSQL Weekly News - June 08 2008 ==

On Sun, Jun 08, 2008 at 08:17:58PM -0700, David Fetter wrote:
> == PostgreSQL Weekly News - June 01 2008 ==

Let's try that again. Sorry, folks.

== 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(at)fetter(dot)org, German language
to pwn(at)pgug(dot)de, Italian language to pwn(at)itpug(dot)org(dot)

== 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.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate