== Postgres Weekly News - 25 maggio 2008 ==

Post originale:
http://people.planetpostgresql.org/dfetter/index.php?/archives/174-PostgreSQL-Weekly-News-May-25-2008.html

Per errori di traduzione o omissioni scrivere a rotellaro (at) gmail.com

La commitfest di maggio è finita. Le patch rimaste in coda sono la
map-forks di Heikki, che e' ancora Work in progress e di cui non è
previsto il commit per ora; e la libpq hooks patch di Merlin e Andrew
che non è
ancora pronta per essere committata.

Il PgCon 2008 è stato un vero successo.
I partecipanti hanno discusso durante il meeting degli svilupppatori,
completato poi con il meeting della cabala segreta.
Ci sono stati partecipanti venuti da molto lontano come Pune, India.

== Postgres News prodotti ==
Rilasciato DbWrench Database Design v1.4.7.
http://www.dbwrench.com/

Rilasciato MicroOLAP Database Designer per PostgreSQL ver.1.2.4-beta.
http://microolap.com/products/database/postgresql-designer/download/

Rilasciato Npgsql 2 Beta4.
http://pgfoundry.org/projects/npgsql/

Il call for paper per "OSS 2.0: Influenzare la comunità Open Source
per il Business" è aperto. L'invio delle proposte deve avvenire entro
il 21 giugno 2008.
http://conferenze.dei.polimi.it/oss20

Rilasciato pgtcl 1.7.
http://pgfoundry.org/projects/pgtcl/

Rilasciato Playr 0.1.
https://area51.myyearbook.com/trac.cgi/wiki/Playr

== Offerte di lavoro legate a PostgreSQL per il mese di Maggio ==
http://archives.postgresql.org/pgsql-jobs/2008-05/threads.php

== PostgreSQL news locali ==

Il PUG Grecia gestirà uno stand alla terza conferenza FLOSS greca
il 27 e 28 maggio al NTUA, Atene.
http://www.postgresql.gr

Il LAPUG si incontrerà il 30 maggio 2008 al Cal Poly
viste updatabili non triviali di Keith Larson
http://pugs.postgresql.org/node/390

Il call for paper per il PgCon.BR è aperto. Il termine è il 31 maggio.
Quindi inviate le vostre proposte.
http://pgcon.postgresql.org.br/chamadas.en.html

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

La conferenza Open Source 2008 dello stato dell'Utah ha aperto il call
for paper fino al primo giugno.
Questa seconda conferenza annuale ci sarà dal 28 al 30 agosto a Salt Lake City
http://2008.utosc.com/

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:

- Coercion sanity check in ri_HashCompareOp failed to allow for enums,
as per example from Rod Taylor. On reflection the correct test here
is for any polymorphic type, not specifically ANYARRAY as in the
original coding.

- Make to_char()'s localized month/day names depend on LC_TIME, not
LC_MESSAGES. Euler Taveira de Oliveira

- Adjust -Wl,--asneeded test to avoid using the switch if it breaks
libreadline. What we will do for compatibility :-(

- Adjust timestamp regression tests to prevent two low-probability
failure cases. Recent buildfarm experience shows that it is
sometimes possible to execute several SQL commands in less time than
the granularity of Windows' not-very-high-resolution gettimeofday(),
leading to a failure because the tests expect the value of now() to
change and it doesn't. Also, it was recognized some time ago that
the same area of the tests could fail if local midnight passes
between the insertion and the checking of the values for
'yesterday', 'tomorrow', etc. Clean all this up per ideas from
myself and Greg Stark. There remains a window for failure if the
transaction block is entered exactly at local midnight (so that
'now' and 'today' have the same value), but that seems
low-probability enough to live with. Since the point of this change
is mostly to eliminate buildfarm noise, back-patch to all versions
we are still actively testing.

Heikki Linnakangas committed:

- Remove arbitrary 10MB limit on two-phase state file size. It's not
that hard to go beoynd 10MB, as demonstrated by Gavin Sharry's
example of dropping a schema with ~25000 objects. The really bogus
thing about the limit was that it was enforced when a state file
file was read in, not when it was written, so you would end up with
a prepared transaction that you can't commit or abort, and the only
recourse was to shut down the server and remove the file by hand.
Raise the limit to MaxAllocSize, and enforce it also when a state
file is written. We could've removed the limit altogether, but
reading in a file larger than MaxAllocSize would fail anyway because
we read it into a palloc'd buffer. Backpatch down to 8.1, where 2PC
and this issue was introduced.

Bruce Momjian committed:

- Mark TODO as done: "Use LC_TIME for localized weekday/month names."

- In pgsql/src/backend/utils/adt/formatting.c, simplify code now that
to_(upper|lower|initcap) do not modify the passed string.

Michael Meskes committed:

- Synced parser. Made ecpg parser use backend provided keyword list.
Changed whenever test so exit value is 0.

- In pgsql/src/interfaces/ecpg/preproc/Makefile, ecpg_keywords.o also
depends on preproc.h

- Link in keywords file instead of copying it. Use #define/#ifdef
instead of sed to fix include files, this should work on Windows
too.

Magnus Hagander committed:

- Use CRITICAL_SECTION instead of Mutexes for thread-locking in libpq
on Windows, for better performance. Per suggestion from Andrew
Chernow, but not his patch since the underlying code was changed to
deal with return values.

- In pgsql/src/bin/psql/print.c, fix function headers not matching
prototype in header file, per compiler warnings on msvc.

- In pgsql/src/tools/msvc/Mkvcbuild.pm, add include directory required
after the latest changes to the ecpg build. Per red Windows
buildfarm members.

== Patch rigettate (per ora) ==
Nessuno e' stato scontentato questa settimana ;-)

== Patch in attesa ==
Guillaume Lelarge sent in a patch to make psql backward-compatible to
7.4. Bryce Nesbitt followed up with one of his own.

Andrew Chernow sent in another revision of the libpq object hooks
patch.

Greg Sabino Mullane sent in a documentation patch by Kevin L. McBride
explaining LOCK_DEBUG options in detail.

Gregory Stark sent in three revisions of a patch which makes \d+ show
storage options for columns, per discussion with Oleg Bartunov.

Jaime Casanova sent in two versions of a patch to extent GRANT's scope
on sequences.

Heikki Linnakangas sent in another revision of his FSM rewrite patch.

Dickson Guedes sent in a patch in collaboration with Euler Taveira de
Oliveira which makes \d and \d+ on sequences produce more useful
output.