Skip to content

Wöchentlicher PostgreSQL Newsletter - 01. Februar 2009

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 01. Februar 2009 ==

Bugfix Releases für 8.3, 8.2, 8.1, 8.0 und 7.4 werden in Kürze
erscheinen. Fertigmachen zum Upgrade!

Greg Smith hat Version 0.90 von pgtune auf pgfoundry veröffentlicht.

Die bulgarische PostgreSQL User Gruppe wird sich am 12. Februar 2009 um
19 Uhr im Vinarnata, 19 Lavele str in Sofia treffen.

== PostgreSQL Produkt Neuigkeiten ==

Archiveopteryx 3.0.6, ein Mailsystem basierend auf PostgreSQL, ist

Pgbuildfarm 3.2 Client Code ist erschienen.  Upgrade!

== PostgreSQL Tipp der Woche ==

Muss nur ein Teil der Tabelle Unique sein, z. B. nur die Benutzernamen
der aktiven User? Dann nutze einen partiellen Unique Index:
CREATE UNIQUE INDEX ON logins ( username ) WHERE active = true;

== PostgreSQL Lokal ==

Richard Broersma koordiniert die Standhelfer für SCALE (siehe unten).
Kontaktiere ihn unter richard DOT broersma AT gmail DOT com.

SYDPUG wird sich am 3. Februar 2009 um 18:30 Uhr bei Fujitsu
Australia in Nord Sydney treffen. Mark Leslie wird über die Geschichte
und Motivationen von PostGIS sprechen.

Viele der üblichen Verdächtigen werden auf der FOSDEM am 7. und 8.
Februar in Brüssel, Belgien sein. Mehr Informationen und der Zeitplan
sind verfügbar unter:

JNBPUG trifft sich am 9. Februar um 19:00 Uhr im News Cafe in der
New Road in Midrand.

Stephen Frost wird über Column-Level Permissions bei der BWPUG sprechen,
am 9. Februar um 18:30 Uhr in den OmniTI Büros.

Der Prager PostgreSQL Entwicklertag 2009 findet am 12. Februar statt.

SFPUG präsentiert: Reece Hart von Unison DB für rechenbetonte Biologie
am 10. Februar 2009, der Ort wird noch bekannt gegeben.

PostgreSQL wird auf der SCALE vom 20. bis 22. Februar in Los Angeles
vertreten sein.

Andreas 'ads' Scherbaum wird einen Vortrag auf dem Perl Workshop 2009
am 25. Februar in Frankfurt am Main, Deutschland, halten.

PostgreSQL Conference U.S. wird einen PgDay auf dem Linuxfest Nordwest
am 25. und 26. April veranstalten. Der Call for Papers ist unter:

PGCon 2009 wird vom 21. bis 22. Mai 2009 in Ottawa an der Universität
von Ottawa stattfinden. Dem gehen zwei Tage mit Tutorials vom 19. bis
20. Mai 2009 voraus.

PGCon Brasilien wird am 23.-24. Oktober 2009 auf dem Unicamp in
Campinas, Sao Paulo, stattfinden.

== PostgreSQL in den News ==

Planet PostgreSQL:

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David
Fetter und Josh Berkus.

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an, deutsche an, italienische an

== Angewandte Patches ==

Peter Eisentraut committed:

- Message format tuning in ecpg.

- Revert updatable views.

- Message fix in pgsql/src/interfaces/ecpg/preproc/

- Translation updates.

- In pgsql/src/interfaces/ecpg/preproc/ecpg.c, whitespace fix in

- In ecpg, Make messages consistent with existing ones.

Alvaro Herrera committed:

- Allow extracting and parsing of reloptions from a bare pg_class
  tuple, and refactor the relcache code that used to do that.  This
  allows other callers (particularly autovacuum) to do the same
  without necessarily having to open and lock a table.

Magnus Hagander committed:

- In pgsql/src/backend/utils/adt/pg_locale.c, silence compiler
  warnings in new win32 locale code when building on mingw.  ITAGAKI

- In pgsql/src/test/regress/pg_regress.c, silence compiler warning on
  win32.  ITAGAKI Takahiro

- In pgsql/src/bin/pg_ctl/pg_ctl.c, support running as a service on
  Windows 7, by not specifying the JOB_OBJECT_UILIMIT_HANDLES flag.
  Dave Page & Magnus Hagander

- Go over all OpenSSL return values and make sure we compare them to
  the documented API value. The previous code got it right as it's
  implemented, but accepted too much/too little compared to the API
  documentation.  Per comment from Zdenek Kotala.

- In pgsql/src/test/regress/pg_regress.c, change warning-silencing
  code not to cast the pointer type, instead casting the value of the
  variable later.  Per comments from Tom Lane.

Teodor Sigaev committed:

- In pgsql/contrib/tsearch2/tsearch2.c, fix bug with multiple
  evaluation of tsearch2 compatibility trigger, trigger data should be
  restored.  Backpatch only to 8.3 because previous versions don't
  have such layer.

- In pgsql/src/backend/tsearch/spell.c, fix incorrect dereferencing of
  char* to array's index.  Per report from Tommy Gildseth.

Tom Lane committed:

- Replace argument-checking Asserts with regular test-and-elog checks
  in all encoding conversion functions.  These are not can't-happen
  cases because it's possible to create a conversion with the wrong
  conversion function for the specified encoding pair.  That would
  lead to an Assert crash in an Assert-enabled build, or incorrect
  conversion otherwise, neither of which is desirable.  This would be
  a DOS issue if production databases were customarily built with
  asserts enabled, but fortunately that's not so.  Per an observation
  by Heikki.  Back-patch to all supported branches.

- Update time zone data files to tzdata release 2009a: introduces
  Asia/Kathmandu as the preferred spelling of that zone name, corrects
  historical DST information for Switzerland and Cuba.

- In pgsql/doc/src/sgml/release.sgml, update back-branch release

- Defend against null input in analyze_requires_snapshot(), per report
  from Rushabh Lathia.  Back-patch of patch of 2009-01-08.  This is
  necessary in 8.3, as reported by Bjorn Munch.  It's not currently
  necessary in 8.2, AFAICS, but seems best to include it there too.

- In pgsql/src/backend/utils/adt/arrayfuncs.c, fix unnest() to handle
  a toasted input array safely.  Per report from Alvaro Herrera.

Heikki Linnakangas committed:

- Check that connection limit is within valid range. IOW, not < -1.
  It's missing in older versions too, but it doesn't seem worth
  back-porting. All negative are just harmlessly treated as "no
  limit", and tightening the check might even brake an application
  that relies on it.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

KaiGai Kohei sent in another revision of his SE-PostgreSQL patch.

KaiGai Kohei sent in two doc patches atop his SE-PostgreSQL patches.

Brendan Jurd sent in an updated patch to correct the meridiem markers.

Zdenek Kotala sent in another revision of his space reservation patch.

Fujii Masao sent in another revision of the synchronous replication

Simon Riggs sent in a bug fix atop the Hot Standby patch.

Heikki Linnakangas sent in two more revisions of the Recovery
Infrastructure patch.

Kenneth Marshall sent in another revision of the updated hash
functions patch.

Timo Savola sent in a patch which allows people to set a sample
percentage for logging.

Alvaro Herrera sent in two more revisions of his patch to add
namespaces to reloptions.

Fernando Ike de Oliveira sent in a patch to add \dL, which lists
languages, to psql.

Andrew Dunstan sent in another revision of his parallel pg_dump patch.

Euler Taveira de Oliveira sent in two patchs atop Alvaro Herrera's
reloptions patch.

Hiroshi Saito sent in three revisions of a patch to generate a
.def (DLL symbol export) file for the event log plugin on mingw.

Robert Haas sent in a patch to optimize add_path in the planner.


No Trackbacks


Display comments as Linear | Threaded

No 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