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

== 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: (view raw or flat)
Lists: pgsql-it-generale
== Postgres News prodotti ==
Rilasciato DBD::Pg 2.7.1.

Rilasciato OpenX 2.5.67-beta, ora con il supporto PostgreSQL.

Rilasciato pgsnap 0.3.1.

Rilasciato pg_top 3.6.2.

Rilasciato psqlODBC 08.03.0200.

Rilasciato PostgreSQL Data Wizard 8.4.

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

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

Il PUG Grecia gestirà uno stand alla terza conferenza FLOSS greca
il 27 e 28 maggio al NTUA, Atene.

Il LAPUG si incontrerà il 30 maggio 2008 al Cal Poly
viste updatabili non triviali di Keith Larson

Il PGDay ci sarà a Portland il giorno precedente all'OSCON.

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

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

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

- 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

- 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

- 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

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

- Update alternative output regression files for new float8 test of

- 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

- 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

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/, improve logic for finding
 object files on OBJS lines in contrib Makefiles.  If this unbreaks
 buildfarm mastodon, apply everywhere.

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

- In pgsql/src/tools/msvc/, backpatch fixes for contrib
== 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

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

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

Alvaro Herrera sent in another revision of his snapshot management

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

pgsql-it-generale by date

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

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