== Postgres Weekly News - 08 giugno 2008 ==

La vesione 8.3.3 PostgreSQL verrà rilasciata a breve. Preparatevi all'upgrade!

== Postgres News prodotti ==
Rilasciato pgAdmin III 1.8.4.
http://www.pgadmin.org/

Rilasciato pgEdit 1.4.
http://pgedit.com/

Rilasciato pgloader 2.3.1.
http://pgfoundry.org/projects/pgloader/

Rilasciato PL/Proxy 2.0.5.
http://pgfoundry.org/projects/plproxy/

Rilasciati gli SkyTools 2.1.7
http://pgfoundry.org/projects/skytools/

== Offerte di lavoro legate a PostgreSQL per il mese di Giugno ==

http://archives.postgresql.org/pgsql-jobs/2008-06/threads.php

== PostgreSQL news locali ==

Il meeting di giugno del LAPUG avverrà presso il California Institute of
Technology. Jaun Jose' Natera presenterà come PL-Perl può essere usato
in PostgreSQL.
http://pugs.postgresql.org/node/403

L'Oklahoma PUG terrà il suo primo meeting il 23 giugno dalle 19:00
alle 21:00 presso Coach's, Norman, OK.
http://pugs.postgresql.org/node/408

PDXPUG Meeting 19/06/08: Il Modello Relazionale
http://pugs.postgresql.org/node/399

SFPUG Giugno: Parsers & pgCon
http://pugs.postgresql.org/node/403

Il PGDay ci sarà a Portland il giorno precedente all'OSCON.
http://pugs.postgresql.org/taxonomy/term/53

Il PGCon Brasile 2008 ci sara' il 26 e 27 settembre 2008 a Unicamp, Campinas.
http://pgcon.postgresql.org.br/index.en.html

Il PGDay.IT 2008 ci sarà il 17 e 18 ottobre a Prato.
http://www.pgday.org/it/

== News su PostgreSQL ==

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

General Bits, archivi e nuovi articoli occasionali:
http://www.varlena.com/GeneralBits/

PostgreSQL Weekly News è stato spedito questa settimana grazie a David
Fetter e Tom Lane.

Per segnalare news e annunci invia un email in inglese entro le ore 15,
fuso orario della costa orientale degli U.S.A, di domenica.

Per segnalazioni in inglese david(at)fetter(dot)org, per segnalazioni in
Tedesco pwn(at)pgug(dot)de, per segnalazioni in italiano pwn(at)itpug(dot)org

== Patch applicate ==
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.

== Patch rigettate (per ora) ==
Nessuno è stato scontentato questa settimana ;)

== Patch in attesa ==
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.

--
(all opinions expressed are my own)
Federico Campoli
PostgreSQL Consulting -> PGHost http://www.pghost.eu