Skip site navigation (1) Skip section navigation (2)

== Postgres Weekly News - 10 Febbraio 2008 ==

From: rotellaro(at)gmail(dot)com
To: pgsql-it-generale <pgsql-it-generale(at)postgresql(dot)org>, itpug(at)lists(dot)itpug(dot)org, itpug-soci(at)lists(dot)itpug(dot)org
Subject: == Postgres Weekly News - 10 Febbraio 2008 ==
Date: 2008-02-11 08:21:35
Message-ID: a3e8e2210802110021s5f222ab9s48c69f2d017118f4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-it-generale
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

pgsql-it-generale by date

Next:From: rotellaroDate: 2008-02-18 09:11:00
Subject: == Postgres Weekly News - 17 Febbraio 2008 ==
Previous:From: gabriele.bartoliniDate: 2008-02-06 09:11:17
Subject: Re: [itpug] Postgres e gli indici B+ tree

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group