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

== Notiziario settimanale PostgreSQL - 12 aprile 2009 ==

From: Gianni Ciolli <gianni(dot)ciolli(at)2ndquadrant(dot)it>
To: pgsql-it-generale <pgsql-it-generale(at)postgresql(dot)org>
Subject: == Notiziario settimanale PostgreSQL - 12 aprile 2009 ==
Date: 2009-04-18 19:01:21
Message-ID: 20090418190121.GA5793@fune (view raw or flat)
Thread:
Lists: pgsql-it-generale
(Traduzione parziale in lingua italiana delle PostgreSQL Weekly News a
 cura di Gianni Ciolli <gianni(dot)ciolli(at)2ndquadrant(dot)it>)

L'Associazione ITPUG - Italian PostgreSQL Users Group terrà una
presentazione di PostgreSQL agli studenti di Informatica
dell'Università di Pisa, il prossimo venerdì 8 maggio:
http://www.postgresql.org/about/event.856

Il PgDay di Florianopolis (Brasile) sarà il 22 maggio. Mettetevi in
contatto con Dickson S. Guedes (guedes AT guedesoft DOT net) per
partecipare o inviare un lavoro.
http://www.postgresql.org.br/eventos/pgday/sc

== Novità sul prodotto PostgreSQL ==

Rilasciata la versione 0.8 di py-postgresql, un insieme di tecnologie
Python, da usare sia dall'esterno che dall'interno del motore di
PostgreSQL.
http://python.projects.postgresql.org/docs/0.8/

== La novità della settimana di PostgreSQL 8.4 == 

Adesso psql tiene conto della versione, vale a dire che i comandi
"backslash" funzionano anche se psql 8.4 si connette a un server
avente versione più vecchia.

== Il suggerimento della settimana == 

La maniera più semplice di eliminare le righe duplicate in una tabella
dove manca una chiave naturale consiste nel creare una nuova tabella
con CREATE TABLE AS ... GROUP BY, TRUNCATE la vecchia tabella, e poi
copiare i dati dalla nuova tabella alla vecchia. E, ovviamente,
sostituire la chiave naturale!

== Offerte di lavoro su PostgreSQL per aprile 2009 ==

http://archives.postgresql.org/pgsql-jobs/2009-04/threads.php

== Notizie locali su PostgreSQL ==

Il 17 aprile si terrà il PgDay Brasilia. Per partecipare mettersi in
contatto con fernando.ike AT gmail DOT com oppure eduardo DOT santos
AT planejamento DOT gov DOT br.
http://www.postgresql.org.br/drupal6/eventos/pgday/df

La Percona Performance Conference si svolgerà presso il Santa Clara
Convention Center, Santa Clara, California, USA
http://conferences.percona.com/

Aperto il CfP per il PgDay São Paulo, che si terrà il 24 aprile.  Per
partecipare mettersi in contatto con marins DOT consultoria AT gmail
DOT com oppure marcelojscosta AT gmail DOT com.

La PostgreSQL Conference U. S. organizzerà un PgDay nell'ambito della
LinuxFest Northwest (25, 26 aprile). Informazioni su come proporre una
comunicazione sono disponibili sul sito
http://www.postgresqlconference.org/

Ci saranno anche dei PgDay il 29 aprile a Porto Velho, RO, e il 30 in
Ji-Parana, RO. Per partecipare mettersi in contatto con Luis Fernando
Bueno: proflfbueno AT gmail DOT com.

Michael Renner farà un workshop sulla replica con PostgreSQL a Netways
OSDC 2009 il 29 e 30 aprile a Norimberga, in Germania.
http://www.netways.de/english/osdc/y2009/programm/w/michael_renner_postgresql_repliziert_ein_ueberblick/

Nei giorni 21 e 22 maggio 2009 all'università di Ottawa, in Canada, si
terrà PGCon 2009. Nei due giorni precedenti si terranno dei tutorials.
http://www.pgcon.org/2009/

Segnatevi la data: pgDay San Jose (USA). Domenica 19 luglio subito
prima di OSCON. Saranno presto annunciate ulteriori informazioni!
(incluso il call for papers)

Il 23 e 24 ottobre 2009 si svolgerà PGCon Brazil, presso Unicamp,
nella città di Campinas, stato di San Paolo.

== Rassegna stampa su PostgreSQL ==

Planet PostgreSQL: http://planet.postgresql.org/

Questo notiziario settimanale PostgreSQL è stato realizzato da David
Fetter e Josh Berkus; traduzione parziale in lingua italiana a cura di
Gianni Ciolli.

Notizie o annunci destinati a questo notiziario dovranno pervenire
entro la mezzanotte di domenica (le 15 nel fuso orario della
California). I comunicati in lingua italiana dovranno essere inviati a
pwn(at)itpug(dot)org; per le lingue inglese o tedesca, si scriva
rispettivamente a david(at)fetter(dot)org o a pwd(at)pgug(dot)de(dot)

== Patch applicate ==

Heikki Linnakangas committed:

- Rinominate in LC_COLLATE e LC_CTYPE le nuove opzioni di CREATE
  DATABASE per impostare la collation e il ctype, come da discussione
  in pgsql-hackers.

- Il codeset da usare viene comunicato a gettext chiamando
  bind_textdomain_codeset(). Già facciamo questo su Windows, ma è
  necessario anche su altre piattaforme quando LC_CTYPE=C. Con altre locali

  We already did that on Windows, but it's
  needed on other platforms too when LC_CTYPE=C. With other locales,
  we enforce (or trust) that the codeset of the locale matches the
  server encoding so we don't need to bind it explicitly. It should do
  no harm in that case either, but I don't have full faith in the PG
  encoding -> OS codeset mapping table yet. Per recent discussion on
  pgsql-hackers.

- In pgsql/src/backend/utils/init/postinit.c, oops, mustn't call
  textdomain() when compiling without --enable-nls

- Quote string literals correctly in the new CREATE SERVER statements
  and binary upgrade UPDATE statements.

Teodor Sigaev committed:

- Fix 'all at one page bug' in picksplit method of R-tree emulation.
  Add defense  from buggy user-defined picksplit to GiST.

- Fix 'all at one page bug' in picksplit method of R-tree emulation.
  Add defense from buggy user-defined picksplit to GiST.

Tom Lane committed:

- In pgsql/doc/src/sgml/keywords.sgml, correct keywords table for
  status of COLLATE vs LC_COLLATE.

- In pgsql/doc/src/sgml/fuzzystrmatch.sgml, document the fact that
  fuzzystrmatch doesn't work in multibyte encodings.

- Add an optional parameter to pg_start_backup() that specifies
  whether to do the checkpoint in immediate or lazy mode.  This is to
  address complaints that pg_start_backup() takes a long time even
  when there's no need to minimize its I/O consumption.

- In pgsql/contrib/fuzzystrmatch/fuzzystrmatch.c, defend against
  non-ASCII letters in fuzzystrmatch code.  The functions still don't
  behave very sanely for multibyte encodings, but at least they won't
  be indexing off the ends of static arrays.

- In pgsql/contrib/pg_freespacemap/pg_freespacemap.c, remove useless
  (leftover?) extern declaration.

- Allow leading and trailing spaces around NaN in numeric_in.  Sam
  Mason, rewritten a bit by Tom Lane.

- Remove psql's ancient hack that suppressed functions taking or
  returning cstring from the output of \df.  Now that the default
  behavior is to exclude all system functions, the de-cluttering
  rationale for this behavior seems pretty weak; and it was always
  quite confusing/unhelpful if you were actually looking for I/O
  functions.  (Not to mention if you were looking for encoding
  converters or other cases that might take or return cstring.)

- Fix the plpgsql memory leak exhibited in bug #4677.  That leak was
  introduced by my patch of 2007-01-28 to use per-subtransaction
  ExprContexts/EStates: since we re-prepared any expression tree when
  the current subtransaction ID changed, we'd accumulate more and more
  leaked expression state trees in the outermost subtransaction if the
  same function was executed at multiple levels of subtransaction
  nesting.  To fix, go back to the previous scheme where there was
  only one EState per transaction for simple plpgsql expressions.  We
  really only need an ExprContext per subtransaction, not a whole
  EState, so it's possible to keep prepared expression state trees in
  the one EState throughout the transaction.  This should be more
  efficient as well as not leaking memory for cases involving lots of
  subtransactions.  The added regression test is the case that
  inspired the 2007-01-28 patch in the first place, just to make sure
  we didn't go backwards.  The current memory leak complaint is
  unfortunately hard to test for in the regression test framework,
  though manual testing shows it's fixed.  Although this is a
  pre-existing bug, I'm not back-patching because I'd like to see this
  method get some field testing first.  Consider back-patching if it
  gets through 8.4beta unscathed.

- In pgsql/src/backend/utils/misc/guc-file.l, treat EOF like \n for
  line-counting purposes in ParseConfigFile, per bug #4752.  Fujii
  Masao

- Remove SQL-compatibility function cardinality().  It is not exactly
  clear how this ought to behave for multi-dimensional arrays.  Per
  discussion, not having it at all seems better than having it with
  what might prove to be the wrong behavior.  We can always add it
  later when we have consensus on the correct behavior.

- In pgsql/doc/src/sgml/gin.sgml, update GIN limitations documentation
  to match current reality.

- Update time zone data files to tzdata release 2009e: DST law changes
  in Argentina/San_Luis, Cuba, Jordan (historical correction only),
  Morocco, Palestine, Syria, Tunisia.

- In pgsql/doc/src/sgml/release.sgml, update release notes through
  yesterday; some minor wordsmithing.

- Add cross-references from the DECLARE and FETCH reference pages to
  the plpgsql documentation about cursors.  Per a suggestion from
  Matthew Wakeling.

- In pgsql/src/bin/pg_dump/pg_dumpall.c, fix pg_dumpall so that when
  --clean is specified, it drops roles and tablespaces in an order
  that has some chance of working.  Per a complaint from Kevin Bailey.
  This is a pre-existing bug, but given the lack of prior complaints
  I'm not sure it's worth back-patching.  In most cases failure of the
  DROP commands wouldn't be that important anyway.  In passing, fix
  syntax errors in dumpCreateDB()'s queries for old servers; these
  were apparently introduced in recent binary_upgrade patch.

Bruce Momjian committed:

- In pgsql/src/bin/psql/tab-complete.c, adjust psql tab completion for
  new \d 'S' flag behavior;  adjust code to be more flexible about
  additional modifiers for \d commands.

- In pgsql/doc/src/sgml/maintenance.sgml, add documentation mention of
  'check_postgres.pl' in Routine Database Maintenance Tasks section.

- In pgsql/doc/src/sgml/maintenance.sgml, doc change in new patch,
  stand-alone -> standalone.

- In pgsql/src/backend/utils/misc/postgresql.conf.sample, display
  postgresql.conf unit options in an easier-to-understand, 2-column
  format.

- In pgsql/src/backend/utils/misc/postgresql.conf.sample, document in
  postgresql.conf that the default units for log_min_duration_statement
  is milliseconds.

- In pgsql/src/backend/utils/misc/postgresql.conf.sample, properly
  align equals signs in new postgresql.conf units comments.

- Add unit documentation for various postgresql.conf settings.

- In pgsql/doc/src/sgml/trigger.sgml, add doc link to section about
  how to compile triggers.

- Remove FAQ and FAQ_DEV ASCII and HTML files from CVS;  now on the
  wiki.  Per-language files kept for transator usage.

- In pgsql/doc/src/sgml/release.sgml, add release note item: Add
  Japanese message translations

- In pgsql/doc/src/sgml/release.sgml, add attribution for: Add
  Japanese message translations (Japan PostgreSQL Users Group).

- More GUC units doc updates.  Euler Taveira de Oliveira.

- Disable effective_io_concurrency on Solaris because posix_fadvise()
  is no-op on that platform.

- In pgsql/src/backend/utils/misc/guc.c, revert addition of units to
  GUC descriptions; doesn't affect postgresql.conf.

- In pgsql/src/bin/psql/tab-complete.c, improve tab completion for
  \ef.  Andrew (RhodiumToad) Gierth.

- In pgsql/doc/src/sgml/wal.sgml, improve documentation about how
  checkpoint spreads I/O activity.

- In pgsql/src/tools/RELEASE_CHANGES, no more need to update FAQs.

- In pgsql/doc/src/sgml/monitoring.sgml, clarify documentation
  references to pg_stat_get_blocks_fetched and pg_stat_get_blocks_hit,
  per suggestion from Robert Haas.

- In pgsql/doc/src/sgml/monitoring.sgml, document how *_blks_read
  statistics columns are computed.

- In pgsql/doc/src/sgml/release.sgml, clarify SSL _user_
  authentication in release notes.

- In pgsql/doc/src/sgml/client-auth.sgml, wording improvement for SSL
  user certificate authentication.

- In pgsql/doc/src/sgml/client-auth.sgml, wording improvement.

- In pgsql/doc/src/sgml/libpq.sgml, better document libpq sslverify
  behavior as requiring root.crt.

- In pgsql/doc/src/sgml/libpq.sgml, more wording clarification of
  sslverify setting.

Peter Eisentraut committed:

- In pgsql/src/backend/utils/mb/mbutils.c, add entry in the encoding
  number to OS name table for KOI8-U.

- XMLATTRIBUTES() should send the attribute values through
  map_sql_value_to_xml_value() instead of directly through the data
  type output function.  This is per SQL standard, and consistent with
  XMLELEMENT().

- Translation updates for 8.4 beta.

- Update config.guess and config.sub

- In pgsql/src/tools/RELEASE_CHANGES, add URL for config.guess/sub
  updates.

- In pgsql/src/bin/psql/help.c, message improvement.

- In pgsql/src/bin/psql/print.c, message fix (I guess this was a
  cruise replace mistake.)

Magnus Hagander committed:

- In pgsql/src/tools/msvc/Mkvcbuild.pm, support Perl 5.10 and TCL 8.5
  in MSVC builds.  We should probably have a better way to do this
  (meaning something not hardcoded) eventually, but this fixes the
  problem for 8.4.  Dave Page.

Marc Fournier committed:

- Commit and tag beta1.

Alvaro Herrera committed:

- In pgsql/src/bin/psql/common.c, make string more alike other similar
  messages.

Andrew Dunstan committed:

- In pgsql/src/bin/pg_dump/pg_backup_archiver.c, fix logic to detect
  conflicts or blocks involving exclusive locks in parallel restore
  items.  If a currently running item needs an exclusive lock on any
  item that the candidate items needs any sort of lock on, or vice
  versa, then the candidate item is not allowed to run now, and must
  wait till later.

== Patch rifiutate (per adesso) ==

No one was disappointed this week :-)

== Patch in coda ==

Pavel Stehule sent in another revision of his transformationHook
patch.

Pavel Stehule sent in a patch to add EEEE format support to to_char.

Taro Minowa(Higepon) sent in a patch to auto-delete large objects when
the referencing row is deleted.

Fujii Masao sent in another revision of his new trigger option for
standby patch.

Magnus Hagander sent in a patch to fix path separator issues on
Windows.

ITAGAKI Takahiro sent in an updated version of the sampling profiler
patch.

David Fetter sent in three patches to account for windowing functions
in psql.

Abhijit Menon-Sen sent in a patch to add tests for quoting and other
abuses in functions.


pgsql-it-generale by date

Next:From: Gianni CiolliDate: 2009-04-20 08:29:41
Subject: == Notiziario settimanale PostgreSQL - 19 aprile 2009 ==
Previous:From: Gianni CiolliDate: 2009-04-18 18:31:32
Subject: == Notiziario settimanale PostgreSQL - 5 aprile 2009 ==

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