== Postgres Weekly News - 10 Febbraio 2008 ==

Rilasciato PostgreSQL 8.3.0!

Onore al team SCALE team e il LAPUG per aver reso di questo evento un successo.

Il PGDG ha rilasciato gli RPM per PostgreSQL 8.3.0
http://yum.pgsqlrpms.org

== Postgres News prodotti ==
Rilasciato Benetl 1.2
http://www.benetl.net/spip/index.php

Rilasciato MyJSQLView 2.81 beta.
http://myjsqlview.sourceforge.net/

Rilasciato PGCluster-1.9.0rc1.
http://pgfoundry.org/projects/pgcluster/

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

Rilasciato pgSphere 1.0.0.
http://pgfoundry.org/projects/pgsphere/

Rilasciato PL/Java per PostgreSQL 8.3.
http://pgfoundry.org/frs/?group_id=1000038&release_id=1024

Rilasciato Slony-I 1.2.13 . Questa release funziona con PostgreSQL 8.3.
http://slony.info/

Rilasciato SQLPro 1.4 .
http://www.vive.net/products/sqlpro.htm

Rilasciato Staplr 0.5.
http://area51.myyearbook.com/trac.cgi/wiki/Staplr

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

== PostgreSQL news locali ==
Il PostgreSQL Developers' Day 2008 di Praga ci sarà il 13 Febbraio.
http://www.dbsvet.cz/view.php?cisloclanku=2008011101

Federico Campoli parlera' di Postgres internals al meeting
GRASS/FOSS Meeting presso il DICA a Perugia, Italia il 22 Febbraio.
Informazioni in italiano di seguito.
http://www.grassmeeting2008.unipg.it/?q=node/10

Il FOSDEM ha organizzato il suo evento tradizionale il venerdi 22
febbraio alle 20 presso il Bier
Circus a Bruxelles.
http://www.beerintheevening.com/pubs/s/27/27650/Le_Bier_Circus/Brussels

I team BSD e PostgreSQL condivideranno una developer room al FOSDEM
2008 a Bruxelles dal 23 al 24 febbraio 2008. Per proporre talk o per
offrire il proprio aiuto nella gestione della dev room contattare
fosdem(at)pgug(dot)eu(dot) Per maggiori informazioni visitare:
https://www.bsdwiki.de/FOSDEM_2008

L'European PostgreSQL User Group eleggera' il nuovo consiglio.
Se volete suggerire un candidato oppure volete informazioni sulle
regole di voto visitate:
http://www.pgug.eu/election.txt

La conferenza della costa orientale di PostgreSQL '08 ci sara' il 29 e
il 30 marzo al College Park dell'Universita' del Maryland. Il Call for
Papers e' aperto.
http://www.postgresqlconference.org/

Il FISL 9.0 ci sara' dal 17 al 19 aprile 2008 al PUCRS a Porto Alegre, Brasile.
https://fisl.softwarelivre.org/9.0/

Il PGCon 2008 ci sara' dal 20 al 23 a Ottawa - si accettano proposte di talk.
http://www.pgcon.org/2008/papers.php

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

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 ==
Magnus Hagander committed:

- Handle libraries in directories with spaces in them. Gevik
Babakhani.

- Fix very broken clean.bat for msvc install. The way we used
subroutines in .bat simply did not work, and it called them in the
wrong order, some several times, and some not at all, so this
unrolls all subroutine calls. This should fix the issues with clean
deleting the wrong files reported by Dave Page. While at it, add
the "clean dist" option to act like "make distclean", and no longer
remove the flex/bison output files by default. This should fix the
problem reported by Pavel Golub in bug #3909.

- In pgsql/src/tools/msvc/Install.pm, fix msvc install script to
properly install NLS files when built with gettext.

- In pgsql/src/tools/msvc/Install.pm, fix msvc install for cases where
msgfmt (from gettext) is in a directory that contains spaces. Per
complaint from Gevik Babakhani, like the last one.

Michael Meskes committed:

- Fixed segfault in ecpg when using an array element. Free all memory
in auto-prepare mode.

Tom Lane committed:

- Fix CREATE TABLE ... LIKE ... INCLUDING INDEXES to not cause
unwanted tablespace permissions failures when copying an index that
is in the database's default tablespace. A side-effect of the
change is that explicitly specifying the default tablespace no
longer triggers a permissions check; this is not how it was done in
pre-8.3 releases but is argued to be more consistent. Per bug #3921
from Andrew Gilligan. (Note: I argued in the subsequent discussion
that maybe LIKE shouldn't copy index tablespaces at all, but since
no one indicated agreement with that idea, I've refrained from doing
it.)

- Fix silly mistake in expand_indexqual_rowcompare --- in converting a
forboth() into an iteration over three parallel lists, I had
accidentally put the lnext steps outside the loop. Sigh. Per bug
#3938.

- Add missing copyfuncs/equalfuncs support for AlterTSDictionaryStmt
and AlterTSConfigurationStmt. All utility statement node types are
expected to be supported here, though they do not have to have
outfuncs/readfuncs support. Found by running regression tests with
COPY_PARSE_PLAN_TREES enabled.

- Add missing copyfuncs/equalfuncs support for AlterTSDictionaryStmt
and AlterTSConfigurationStmt. All utility statement node types are
expected to be supported here, though they do not have to have
outfuncs/readfuncs support. Found by running regression tests with
COPY_PARSE_PLAN_TREES enabled.

- Some variants of ALTER OWNER tried to make the "object" field of the
statement be a list of bare C strings, rather than String nodes,
which is what they need to be for copyfuncs/equalfuncs to work.
Fortunately these node types never go out to disk (if they did, we'd
likely have noticed the problem sooner), so we can just fix it
without creating a need for initdb. This bug has been there since
8.0, but 8.3 exposes it in a more common code path (Parse messages)
than prior releases did. Per bug #3940 from Vladimir Kokovic.

- Avoid misbehavior in foreign key checks when casting to a datatype
for which the parser supplies a default typmod that can result in
data loss (ie, truncation). Currently that appears to be only
CHARACTER and BIT. We can avoid the problem by specifying the
type's internal name instead of using SQL-spec syntax. Since the
queries generated here are only used internally, there's no need to
worry about portability. This problem is new in 8.3; before we just
let the parser do whatever it wanted to resolve the operator, but
8.3 is trying to be sure that the semantics of FK checks are
consistent. Per report from Harald Fuchs.

- In pgsql/src/backend/libpq/auth.c, since GSSAPI and SSPI
authentication don't work in protocol version 2, issue a helpful
error message instead of sending unparsable garbage. (It is clearly
a design error that this doesn't work, but fixing it is not worth
the trouble at this point.) Per discussion.

- In pgsql/doc/src/sgml/protocol.sgml, some small editorialization on
the protocol documentation for GSSAPI/SSPI authentication.

- In pgsql/src/backend/storage/page/bufpage.c, fix
PageGetExactFreeSpace() so that it actually behaves sensibly if
pd_lower > pd_upper, rather than merely claiming to. This would
only matter if the page header were corrupt, which shouldn't occur,
but ...

Bruce Momjian committed:

- In pgsql/doc/src/sgml/release.sgml, add "automatically" to HOT
release note description.

== Patch rigettate (per ora) ==

Nessuno e' stato scontentato questa settimana :-)

== Patch in attesa ==

Manolo di Domenico sent in two revisions of a patch intended to refine
the external sorting algorithm by using a two-way replacement
selection algorithm.

Simon Riggs sent in an optimization of TransactionIdIsInProgress().

Tom Lane sent in a patch to fix a bug in VACUUM FULL.

--
(all opinions expressed are my own)
Federico Campoli is:
@ ITPUG -> Segretario, http://www.itpug.org
@ PLUG -> Presidente, http://www.prato.linux.it
PostgreSQL Consulting -> PGHost http://www.pghost.eu