== Postgres Weekly News - 11 maggio 2008 ==

From: rotellaro(at)gmail(dot)com
To: pgsql-it-generale <pgsql-it-generale(at)postgresql(dot)org>, itpug-soci(at)lists(dot)itpug(dot)org, itpug(at)lists(dot)itpug(dot)org
Subject: == Postgres Weekly News - 11 maggio 2008 ==
Date: 2008-05-12 17:47:00
Message-ID: a3e8e2210805121047x454b486fj8b1cd2d3c994f058@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-it-generale

== Postgres News prodotti ==
Rilasciato DBD::Pg 2.7.1.
http://search.cpan.org/dist/DBD-Pg/

Rilasciato OpenX 2.5.67-beta, ora con il supporto PostgreSQL.
http://www.openx.org/beta

Rilasciato pgsnap 0.3.1.
http://pgsnap.projects.postgresql.org/

Rilasciato pg_top 3.6.2.
http://ptop.projects.postgresql.org/

Rilasciato psqlODBC 08.03.0200.
http://psqlodbc.projects.postgresql.org/release.html

Rilasciato PostgreSQL Data Wizard 8.4.
http://www.sqlmaestro.com/products/postgresql/datawizard/

== 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 BWPUG terrà il suo primo meeting mercoledi 14 maggio presso la sede
OmniTI world a Columbia, MD.

Il PGCon 2008 ci sarà dal 20 al 23 maggio a Ottawa.
http://www.pgcon.org/2008/

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 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/

== 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 ==
Bruce Momjian committed:

- Mark TODO as done: "Improve display of enums to show valid enum
values."

- Mark TODO as done: "Add function to report the time of the most
recent server reload."

- Update libpqxx URL in README.

- Point to our download URL, rather than listing interface in the
README file:

- In pgsql/src/bin/psql/variables.c, have boolean pset values checked
against typical boolean values, rather than only 'off'.

- In TODO, add item, make text search section: "Consider changing
error to warning for strings larger than one megabyte."

- Update TODO to read: "Allow dictionaries to change the token that is
passed on to later dictionaries."

- Add URL for TODO: "Consider increasing the number of default
statistics target, and reduce statistics target overhead."

- Fixed TODO typo.

- In pgsql/doc/src/sgml/postgres.sgml, move Client Authentication
right after Server Configuration in docs. Scott Marlowe

- In pgsql/doc/src/sgml/ref/psql-ref.sgml, remove OID/foreign key
mention in psql variable interpolation docs.

- Add to TODO: "Add database and transaction-level triggers."

- Add to TODO: "Add CREATE SCHEMA ... LIKE that copies a schema."

- Update TODO wording to read: "Improve detection of shared memory
segments being used by others by checking the SysV shared memory
field 'nattch'"

- Have psql output tab as the proper number of spaces, rather than
\x09.

- In pgsql/src/backend/utils/adt/numeric.c, have numeric 0 ^ 4.3
return 1, rather than an error, and have 0 ^ 0.0 return 1, rather
than error. This was already the float8 behavior.

- Add psql '\pset format wrapped' mode to wrap output to screen width,
or file/pipe output too if \pset columns' is set. Bryce Nesbitt

- Add regression test for various power expressions with a zero base,
and adjust source code to be more modular.

- Add to TODO: "Improve the /contrib installation experience."

- Update C comments to mention SQL:2003 handling of power return
values.

- Adjust power() error messages to be more descriptive.

- Mark TODO as done: "Prevent parent tables from altering or dropping
constraints. Prevent child tables from altering or dropping
constraints."

- Add to TODO: "Clear table counters on TRUNCATE."

- Update alternative output regression files for new float8 test of
power().

- Add URL for TODO: "Add column to pg_stat_activity that shows the
progress of long-running commands like CREATE INDEX and VACUUM."

- Add to TODO: "Allow an existing index to be marked as a table's
primary key."

- Add URL for TODO: "Allow an existing index to be marked as a table's
primary key."

Magnus Hagander committed:

- In pgsql/src/interfaces/libpq/win32.mak, add more dependencies from
libpgport required by standalone msvc build of libpq. Hiroshi Saito.

- Make the pg_stat_activity view call a SRF (pg_stat_get_activity())
instead of calling a bunch of individual functions. This function
can also be called directly, taking a PID as an argument, to return
only the data for a single PID.

- Make the new pg_stat_get_activity use OUT parameters, so you don't
have to specify the column names and types. Also simplifies the
view. Per comments from Tom Lane.

Tom Lane committed:

- In pgsql/src/include/utils/syscache.h, convert the list of syscache
names from a series of #define's into an enum, to avoid the pain of
manually renumbering them anytime we insert another name in
alphabetical order. An excellent idea from Alex Hunsaker and
NikhilS' inherited-constraints patch --- whether or not the rest of
that gets in, this should. Dunno why we never thought of it before.

- In pgsql/src/backend/utils/cache/syscache.c, the CONSTROID syscache
should show conrelid as a relation OID column. Not clear that
there's any observable bug at present from this omission, but it
seems like something to fix going forward.

- Fix rules regression test for recent pg_stat_activity change.

- Fix contrib/xml2 makefile to not override CFLAGS, and in passing
make it auto-configure properly for libxslt present or not.

- Fix memory stomp that's turning the whole buildfarm pink: you can't
hack up pg_wcsformat without changing pg_wcssize to match. Add some
comments to try to make that clearer, and make a couple other minor
editorializations.

- Fix bogus expected output that should have made it quite clear that
something was wrong with that tab patch.

- In pgsql/contrib/pgbench/pgbench.c, give a warning if -s switch is
used with a non-custom pgbench test. Also, clean up the code that
assigned the scale into :scale variables. Greg Smith and Tom Lane

- Fix an ancient oversight in change_varattnos_of_a_node: it neglected
to update varoattno along with varattno. This resulted in having
Vars that were not seen as equal(), causing inheritance of the
"same" constraint from different parent relations to fail. An
example is:
create table pp1 (f1 int check (f1>0));
create table cc1 (f2 text, f3 int) inherits (pp1);
create table cc2(f4 float) inherits(pp1,cc1);
Backpatch as far as 7.4. (The test case still fails in 7.4, for
reasons that I don't feel like investigating at the moment.) This is
a backpatch commit only. The fix will be applied in HEAD as part of
the upcoming pg_constraint patch.

- Change the rules for inherited CHECK constraints to be essentially
the same as those for inherited columns; that is, it's no longer
allowed for a child table to not have a check constraint matching
one that exists on a parent. This satisfies the principle of least
surprise (rows selected from the parent will always appear to meet
its check constraints) and eliminates some longstanding bogosity in
pg_dump, which formerly had to guess about whether check constraints
were really inherited or not. The implementation involves adding
conislocal and coninhcount columns to pg_constraint (paralleling
attislocal and attinhcount in pg_attribute) and refactoring various
ALTER TABLE actions to be more like those for columns. Alex
Hunsaker, Nikhil Sontakke, Tom Lane

- In pgsql/src/bin/psql/print.c, restore psql's former behavior that
padding spaces to the right of the last output column are not
emitted. (That change already caused more noise in the regression
test output files than I would like.) Provide some needed editorial
help for comments, clean up code formatting.

Alvaro Herrera committed:

- In pgsql/doc/src/sgml/pgstandby.sgml, add Simon Riggs' email
address.

Heikki Linnakangas committed:

- Fix incorrect archive truncation point calculation in the %r
recovery_command parameter. This fixes bug 4137 reported by Wojciech
Strzalka, where a WAL file is deleted too early when starting the
recovery of a warm standby server. Also add a sanity check in
pg_standby so that it will refuse to delete anything earlier than
the file being restored, and improve the debug message in case
nothing is deleted. Simon Riggs. Backpatch to 8.3, which is where
%r was introduced.

- In pgsql/src/backend/access/transam/xlog.c, fix Assert introduced in
previous patch.

Peter Eisentraut committed:

- Add "%option noinput" to the scanners to avoid compiler warnings.
GCC 4.3 began to realize that the input() function isn't used and
printed warnings.

Andrew Dunstan committed:

- In pgsql/src/tools/msvc/Mkvcbuild.pm, improve logic for finding
object files on OBJS lines in contrib Makefiles. If this unbreaks
buildfarm mastodon, apply everywhere.

- In pgsql/src/tools/msvc/Mkvcbuild.pm, remaining pieces of fix for
contrib makefiles.

- In pgsql/src/tools/msvc/Mkvcbuild.pm, backpatch fixes for contrib
makefiles.
== Patch rigettate (per ora) ==
Nessuno e' stato scontentato questa settimana ;-)

== Patch in attesa ==
Pavel Stehule sent in another revision of his patch to add CASE to
PL/PgSQL.

Alex Hunsaker sent in two more revisions of his patch for fixing the
problems with identifying constraints which should be inherited.

Heikki Linnakangas sent in another revision of his WIP Map Forks
patch.

Simon Riggs sent in a patch which adds --schema-pre-load and
--schema-post-load options both to pg_dump and pg_restore.

Magnus Hagander sent in a patch which adds some error checking to the
thread locking parts in libpq.

Bruce Momjian sent in two revisions of a patch to do something more
sane with tabs in psql output.

Pavel Stehule sent in another revision of his patch to add options to
PL/PgSQL's RAISE statement.

Brendan Jurd sent in another revision of his printTable API.

Bernd Helmle sent in another revision (via git) of his updateable
views patch.

Peter Eisentraut sent in a patch to fix flex warnings from GCC 4.3.

Jan Urbanski sent in a patch as infrastructure for his Summer of Code
project which changes the assumption that update_attstats() constructs
an array whose elements are of the same type as the corresponding
attribute.

Alvaro Herrera sent in another revision of his snapshot management
patch.

Hans-Juergen Schoenig sent in a patch intended to fix a performance
issue in concurrent scans.

David Gould sent in a patch to add a lock timeout option to pg_dump.

--
(all opinions expressed are my own)
Federico Campoli
PostgreSQL Consulting -> PGHost http://www.pghost.eu

Browse pgsql-it-generale by date

  From Date Subject
Next Message rotellaro 2008-05-19 06:32:38 == Postgres Weekly News - 11 maggio 2008 ==
Previous Message rotellaro 2008-05-07 11:49:28 == Postgres Weekly News - 4 maggio 2008 ==