Skip to content

== Wöchentlicher PostgreSQL Newsletter - 27. Januar 2008 ==

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 27. Januar 2008 ==

8.3 RC2 ist da. Testen!

Gratulation an Selena Deckelmann für Ihren neuen Job als Verbindungsmann zwischen den Postgresql User Groups.

Achtet auf den aktualisierten PUG Server diese Woche.

Postgres Weekly News brachte Euch diese Woche David Fetter

und Devrim GUNDUZ

== PostgreSQL Produkt Neuigkeiten ==

ip4r 1.02 erschienen.

pg_proboscis 0.9.4 erschienen.

== PostgreSQL Jobs im Januar ==

== PostgreSQL Lokal ==

Die Europaische PostgreSQL User Group wählt ihren Vorstand

Möchtest Du einen Kandidaten vorschlagen oder die Wahlregeln sehen

schaue hier:

Prager PostgreSQL Entwickler Tag 2008 findet am 13. Februar statt.

PGCon 2008 findet statt am 20-23 Mai in Ottawa - Vorschläge werden angenommen.

FOSDEM hat das normale Ereigniss am Freitag 20Uhr, 22. Februar im Bier

Circus in Brüssel organisiert.

Das BSD und das PostgreSQL Team teilen sich einen Entwicklerraum zur FOSDEM 2008 in

Brüssel am 22-24 Februar 2008. Möchtest Du einen Vortrag halten oder bei der Organisation

helfen, kontaktiere Für mehr Informationen,


PostgreSQL Conference East '08 talks sind am 29. und 30. März in der

University of Maryland, College Park. Der Ruf nach Papier ist eröffnet.

FISL 9.0 findet am 17-19 April 2008 in PUCRS in Porto Alegre,

Brasilien statt.

== PostgreSQL in den News ==

Planet PostgreSQL:

General Bits, Archive und gelegentliche News Artikel:

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer

Zeit. Bitte sende englische Beiträge an, deutsche an

== Angewandte Patches ==

Alvaro Herrera committed:

- In pgsql/src/backend/catalog/pg_enum.c, split error message.

- In pgsql/src/backend/catalog/pg_shdepend.c, improve lock level

choices in pg_shdepend.c. Noticed by Tom Lane.

Tom Lane committed:

- Fix psql \h output for case of no parameters (ie, list all the known

commands) to format properly for the actually needed column width,

instead of having a hard-wired assumption about the longest command

name length. Also make it respond to the current screen width. In

passing, const-ify the constant table.

- Fix RS_isRegis() to agree exactly with RS_compile()'s idea of what's

a valid regis. Correct the latter's oversight that a

bracket-expression needs to be terminated. Reduce the ereports to

elogs, since they are now not expected to ever be hit (thus

addressing Alvaro's original complaint). In passing, const-ify the

string argument to RS_compile.

- In pgsql/doc/src/sgml/config.sgml, improve description of

bgwriter_lru_multiplier, per discussion.

- Reference pgAdmin as a typical client-side tool, rather than the

no-longer-maintained PgAccess. Per Erik Rijkers.

- In pgsql/doc/src/sgml/syntax.sgml, avoid mathematical inconsistency

in example about avoiding division by zero with a CASE expression.

Per gripe from Russell Smith.

- In pgsql/doc/src/sgml/backup.sgml, provide a concrete example of

parameter expansion in archive_command. Per discussion of bug

#3877. Simon Riggs, some fixes by moi.

- In pgsql/src/include/utils/timestamp.h, prevent integer overflow

within the integer-datetimes version of TimestampTzPlusMilliseconds.

An integer argument of more than INT_MAX/1000 milliseconds (ie,

about 35 minutes) would provoke a wrong result, resulting in

incorrect enforcement of statement_timestamp values larger than

that. Bug was introduced in my rewrite of 2006-06-20, which fixed

some other overflow risks, but missed this one :-( Per report from


- In pgsql/src/backend/utils/adt/ri_triggers.c, release any detoasted

copies of arrays that are made temporarily in ri_FetchConstraintInfo,

to avoid a query-duration memory leak when that routine is called by

RI_FKey_keyequal_upd_fk (which isn't executed in a short-lived

context). This problem was latent when the routine was added in

February, but it didn't become serious until the varvarlena patch

made it quite likely that the fields being examined would be

"toasted" (ie, have short headers). Per report from Stephen Denne.

- In pgsql/src/backend/postmaster/syslogger.c, fix two different

copy-and-paste-os in CSV log rotation logic; one that led to a

double-pfree crash and another that effectively disabled size-based

rotation for CSV logs. Also suppress a memory leak and make some

trivial cosmetic improvements. Per bug #3901 from Chris Hoover and

additional code-reading.

- Change StatementCancelHandler() to check the DoingCommandRead flag

to decide whether to execute an immediate interrupt, rather than

testing whether LockWaitCancel() cancelled a lock wait. The old way

misclassified the case where we were blocked in ProcWaitForSignal(),

and arguably would misclassify any other future additions of new

ImmediateInterruptOK states too. This allows reverting the old

kluge that gave LockWaitCancel() a return value, since no callers

care anymore. Improve comments in the various implementations of

PGSemaphoreLock() to explain that on some platforms, the assumption

that semop() exits after a signal is wrong, and so we must ensure

that the signal handler itself throws elog if we want cancel or die

interrupts to be effective. Per testing related to bug #3883,

though this patch doesn't solve those problems fully. Perhaps this

change should be back-patched, but since pre-8.3 branches aren't

really relying on autovacuum to respond to SIGINT, it doesn't seem

critical for them.

Peter Eisentraut committed:

- Provide a clearer error message if the pg_control version number

looks wrong because of mismatched byte ordering.

- Change /contrib to contrib for consistency.

Andrew Dunstan commited:

- In pgsql/src/pl/plperl/plperl.c, work around for perl 5.10 bug - fix

due to perl hacker Simon Cozens.

- In pgsql/src/pl/plperl/plperl.c, document the fix for perl 5.10 with

the following comment: "The temporary enabling of the caller opcode

here is to work around a bug in perl 5.10, which unkindly changed

the way its works, without notice. It is quite safe, as

caller is informational only, and in any case we only enable it

while we load the 'strict' module."

- In pgsql/doc/src/sgml/plperl.sgml, fix example of de-escaping bytea

argument, per Florian Weimer. Also fix example of escaping bytea

return value. Both cases did not handle backslash values properly.

== Abgelehnte Patches (bis jetzt) ==

Simon Riggs's patch to reduce the contention on SInvalLock, due to its


== Eingesandte Patches ==

Tom Lane sent in a patch for renaming constraints along with the

corresponding indexes.

Simon Riggs sent in a doc patch for bug 3877 (re: WAL/PITR).

Greg Sabino Mullane sent in a patch to add a useful response to 'help'

and variants in psql.

Hiroshi Saito sent in a patch to fix testlo on Windows.

Gokulakannan Somasundaram sent in two more revisions of his thick

index patch.

Pavel Stehule sent in a WIP patch for variadic functions.

Neil Conway sent in an updated version of Gregory Stark's

non-recursive WITH patch with the WITH RECURSIVE parts trimmed out.

Tom Lane sent in a patch which adds a GUC variable to allow clients to

disable the new synchronized-scanning behavior, and make pg_dump

disable sync scans so that it will reliably preserve row ordering.


No Trackbacks


Display comments as Linear | Threaded

akretschmer on :

sorry für die nicht ganz optimale Formatierung, aber ich kam mit dem Blogsystem nicht wirklich so zurecht, wie ich wollte und unter Zeitdruck ist das alles a bissl, naja. Ich wünsche ads von hier aus auf seiner derzeitigen Mission (*g*) viel Erfolg...
Comments ()

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options