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

== Postgres Weekly News - 24 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 - 24 Febbraio 2008 ==
Date: 2008-02-25 16:13:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-it-generale
Post originale all'url:

Il FOSDEM è stato un successo per Postgres. Molti talk si sono tenuti
con la sala piena con persone in piedi; i ragazzi che hanno curato la
gestione dello stand sono comprensibilmente entusiasti e le donazioni
sono state importanti.  Grandi Onori agli organizzatori.

Il PostgreSQL European User Group ha eletto il proprio consiglio:
Jean-Paul Agudo dalla Francia, Gabriele Bartolini dall'Italia, Magnus
Hagander dalla Svezia e Andreas Scherbaum dalla Germania.

== Postgres News prodotti ==

Rilasciato Benetl 1.5 per Windows.

Rilasciata versione 0.3.2 di Pg::Snapshot e Materialized Views.

Peter Eisentraut insieme ad altri ha avviato il progetto Debian
PostgreSQL Packaging.

Greg Sabino Mullane ha reso MediaWiki compatibile con Postgres 8.3.

Rilasciato MicroOLAP Database Designer 1.2.3 per PostgreSQL.

Rilasciato Nagios Plugin per Postgres 1.2.0.

Sono stati aggiornati i package PGCluster 1.9, 1.7, 1.5 e 1.3 .

Rilasciato ptop 3.6.1 beta4.

Rilasciato textsearch-ja 8.3.0.

Rilasciato VTD-XML 2.3.

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

== PostgreSQL news locali ==
Il PG UK day ci sarà il 2 aprile a Birmingham.

Il PGCon 2008 ci sarà dal 20 al 23 maggio ad Ottawa.

La conferenza della costa orientale di PostgreSQL '08 ci sara' il 29 e
il 30 marzo al College Park dell'Universita' del Maryland.

Il FISL 9.0 ci sara' dal 17 al 19 aprile 2008 al PUCRS a Porto Alegre, Brasile.

== News su PostgreSQL ==

Planet PostgreSQL:

General Bits, archivi e nuovi articoli occasionali:

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 ==
Peter Eisentraut committed:

- In pgsql/src/backend/tsearch/Makefile, observe errors.

- Added --htmldir option to pg_config, equivalent to the new configure

- Refactor backend makefiles to remove lots of duplicate code.

- In pgsql/src/backend/access/common/Makefile, remove another target I
 forgot during the refactoring.

- Remove pgsql/src/backend/port/sunos4.  This subdirectory has been
 unused, dead, and broken for 10 years.

- More refactoring, so that the SUBSYS.o rules are now all in one

- Backport fixed AC_FUNC_FSEEKO

Bruce Momjian committed:

- autoconf 2.61's AC_FUNC_FSEEKO reports success/failure differently,
 so reorganize code for NetBSD/BSDi port/fseeko.c usage, and make
 code more modular.

- Put fseeko check back in old location, in hopes of silencing build

- Put back code modularization of fseeko() configure checks.

Tom Lane committed:

- Remove unnecessary opening of other relation in RI_FKey_keyequal_upd_pk
 and RI_FKey_keyequal_upd_fk, as well as no-longer-needed calls of
 ri_BuildQueryKeyFull.  Aside from saving a few cycles, this avoids
 needless deadlock risks when an update is not changing the columns
 that participate in an RI constraint.  Per a gripe from Alexey
 Nalbat.  Back-patch to 8.3.  Earlier releases did have a need to
 open the other relation due to the way in which they retrieved
 information about the RI constraint, so this problem unfortunately
 can't easily be improved pre-8.3.  Tom Lane and Stephan Szabo

- In pgsql/src/backend/catalog/catalog.c, put a CHECK_FOR_INTERRUPTS
 call into the loops that try to find a unique new OID or new
 relfilenode.  If the existing OIDs are sufficiently densely
 populated, this could take a long time (perhaps even be an infinite
 loop), so it seems wise to allow the system to respond to a cancel
 interrupt here.  Per a gripe from Jacky Leng.  Backpatch as far as
 8.1.  Older versions just fail on OID collision, instead of looping.

- In pgsql/src/bin/pg_ctl/pg_ctl.c, fix mistakes in pg_ctl's code for
 "start -w" that tries to cope with non-default settings for the
 postmaster's port number.  The code to parse command line options
 and postgresql.conf entries wasn't quite right about whitespace or
 quotes, and it was coded in a not-very-readable way too.  Per bug
 #3969 from Itagaki Takahiro, though this is more extensive than his
 proposed patch (which fixed only the whitespace problem).  This code
 has been broken since it was put in in 8.0, so patch all the way

- In pgsql/src/test/regress/pg_regress.c, make pg_regress -V
 consistent with the corresponding code in other programs: use puts
 with a compile-time-constant string.

- Rename miscadmin.h's PG_VERSIONSTR macro to PG_BACKEND_VERSIONSTR to
 make it a bit clearer what it is, and get rid of duplicate
 definitions in initdb and pg_ctl.

- Change the declaration of struct varlena so that the length word is
 represented as "char ...[4]" not "int32".  Since the length word is
 never supposed to be accessed via this struct member anyway, this
 won't break any existing code that is following the rules.  The
 advantage is that C compilers will no longer assume that a pointer
 to struct varlena is word-aligned, which prevents incorrect
 optimizations in TOAST-pointer access and perhaps other places.  gcc
 doesn't seem to do this (at least not at -O2), but the problem is
 demonstrable on some other compilers.  I changed struct inet as
 well, but didn't bother to touch a lot of other struct definitions
 in which it wouldn't make any difference because there were other
 fields forcing int alignment anyway.  Hopefully none of those struct
 definitions are used for accessing unaligned Datums.

- In pgsql/src/backend/utils/misc/help_config.c, avoid trying to print
 a NULL char pointer in --describe-config.  On some platforms this
 works, but on some it crashes.  Zdenek Kotala

- Use our own getopt() and getopt_long() on Solaris, because that
 platform's versions don't handle long options the way we want.  Per
 Zdenek Kotala.

Magnus Hagander committed:

- In pgsql/src/tools/msvc/, unbreak MSVC build after recent
 addition of HTMLDIR.

- In pgsql/src/timezone/strftime.c, fix function prototype to silence
 compiler warnings.

- In pgsql/src/tools/msvc/, un-break msvc port yet again (it
 started pulling in the Darwin port files, which obviously didn't

Alvaro Herrera committed:

- In pgsql/src/backend/postmaster/autovacuum.c, change error message
 to be able to differentiate the two cases.  Per suggestion from
 Jaime Casanova.

- Improve error messages emitted when VACUUM and ANALYZE skip a table.
 Per gripe from Clodoaldo Pinto Neto.

== Patch rigettate (per ora) ==

Nessuno e' stato scontentato questa settimana :-)

== Patch in attesa ==

Gevik Babakhani sent in a patch to fix MSVC compilation on MSVC.

Tatsuhito Kasahara sent in two revisions of a patch intended to change
pgstatindex.c and pgstattuple.sql, where some variables are defined
with int type, to a larger numeric type, which in turn allows for
larger tables.

Davd Page sent in a patch which fixes initdb failures on Windows
stemming from recent security-related changes to that platform.

Zdenek Kotala sent in three revisions of a patch intended to fix
non-portable getopt() code.

Neil Conway sent in a patch to fix some memory leaks in the
implementaiton of set-returning functions.

Peter Eisentraut sent in a patch links the backend in one piece
instead of many files.

Robert Lor sent in a patch to change the DTrace probes from the
DTRACE_PROBEn implementation to the header macro implementation so
that the probes can be used on OSs other than Solaris including OSX

Heikki Linnakangas sent in an optimization for CopyReadLineText which
should speed up COPY operations in many common cases.

(all opinions expressed are my own)
Federico Campoli is:
@ ITPUG -> Segretario,
@ PLUG -> Presidente,
PostgreSQL Consulting  -> PGHost

pgsql-it-generale by date

Next:From: rotellaroDate: 2008-02-28 12:28:44
Subject: PostgreSQL Book
Previous:From: rotellaroDate: 2008-02-18 09:11:00
Subject: == Postgres Weekly News - 17 Febbraio 2008 ==

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