== Wöchentlicher PostgreSQL Newsletter - 10. Februar 2008 ==

[Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>]

Der Originalartikel befindet sich unter:
http://people.planetpostgresql.org/dfetter/index.php?/archives/158-Postgres-Weekly-News-February-10-2008.html


== Wöchentlicher PostgreSQL Newsletter - 10. Februar 2008 ==

PostgreSQL 8.3.0 erschienen!

Dank an die Teams von SCALE und LAPUG dass die Veranstaltung ein Erfolg
wurde.

PGDG RPMs für PostgreSQL 8.3.0 erschienen.
http://yum.pgsqlrpms.org

== PostgreSQL Produkt Neuigkeiten ==

Benetl 1.2 erschienen.
http://www.benetl.net/spip/index.php

MyJSQLView 2.81 beta erschienen.
http://myjsqlview.sourceforge.net/

PGCluster-1.9.0rc1 erschienen.
http://pgfoundry.org/projects/pgcluster/

pgloader 2.2.6 erschienen.
http://pgfoundry.org/projects/pgloader/

pgSphere 1.0.0 erschienen.
http://pgfoundry.org/projects/pgsphere/

PL/Java hat eine Version für 8.3 veröffentlicht.
http://pgfoundry.org/frs/?group_id=1000038&release_id=1024

Slony-I 1.2.13 erschienen. Diese Version funktioniert mit PostgreSQL
8.3.
http://slony.info/

SQLPro 1.4 erschienen.
http://www.vive.net/products/sqlpro.htm

Staplr 0.5 erschienen.
http://area51.myyearbook.com/trac.cgi/wiki/Staplr

== PostgreSQL Jobs im Februar ==

http://archives.postgresql.org/pgsql-jobs/2008-02/threads.php

== PostgreSQL Lokal ==

Der Prager PostgreSQL Developers Day 2008 wird am 13. Februar
stattfinden.
http://www.dbsvet.cz/view.php?cisloclanku=2008011101

Federico Campoli wird über PostgreSQL Internas auf dem GRASS/FOSS
Treffen auf der DICA in Perugia, Italien am 22. Februar sprechen.
Informationen unter:
http://www.grassmeeting2008.unipg.it/?q=node/10

FOSDEM hat das übliche Beer Event am Freitag abend, dem 22. Februar um
20:00 Uhr im Bier Zirkus in Brüssel organisiert.
http://www.beerintheevening.com/pubs/s/27/27650/Le_Bier_Circus/Brussels

Die BSD und PostgreSQL Teams haben einen gemeinsamen Developer Room auf
der FOSDEM 2008 in Brüssel. Wenn du einen Vortrag halten möchtest oder
beim Managing des Rooms helfen möchtest, kontaktiere fosdem(at)pgug(dot)eu(dot)
Für mehr Informationen siehe:
https://www.bsdwiki.de/FOSDEM_2008

Die Europäische PostgreSQL User Group wird ein neues Board of Directors
wählen. Wenn du einen Kandidaten vorschlagen möchtest oder die
Wahlregeln sehen möchtest:
http://www.pgug.eu/election.txt

PostgreSQL Conference East '08 ist am 29. und 30. März an der
Universität von Maryland, College Park. Call for Papers ist jetzt
eröffnet.
http://www.postgresqlconference.org/

Die FISL wird vom 17. bis 19. April 2008 auf der PUCRS in Porto Alegre,
Brasilien, stattfinden.
https://fisl.softwarelivre.org/9.0/

PGCon 2008 wird vom 20. bis 23. Mai in Ottawa stattfinden - Vorträge
werden jetzt akzeptiert.
http://www.pgcon.org/2008/papers.php

== PostgreSQL in den News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archive und gelegentliche News Artikel:
http://www.varlena.com/GeneralBits/

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David
Fetter

Sende Neuigkeiten und Ankündigungen bis Sonntag, 15 Uhr Pazifischer
Zeit. Bitte sende englische Beiträge an david(at)fetter(dot)org, deutsche an
pwn(at)pgug(dot)de, italienische an pwn(at)itpug(dot)org(dot)

== Angewandte Patches ==

Magnus Hagander committed:

- Handle libraries in directories with spaces in them.  Gevik
  Babakhani.

- Fix very broken clean.bat for msvc install.  The way we used
  subroutines in .bat simply did not work, and it called them in the
  wrong order, some several times, and some not at all, so this
  unrolls all subroutine calls.  This should fix the issues with clean
  deleting the wrong files reported by Dave Page.  While at it, add
  the "clean dist" option to act like "make distclean", and no longer
  remove the flex/bison output files by default.  This should fix the
  problem reported by Pavel Golub in bug #3909.

- In pgsql/src/tools/msvc/Install.pm, fix msvc install script to
  properly install NLS files when built with gettext.

- In pgsql/src/tools/msvc/Install.pm, fix msvc install for cases where
  msgfmt (from gettext) is in a directory that contains spaces.  Per
  complaint from Gevik Babakhani, like the last one.

Michael Meskes committed:

- Fixed segfault in ecpg when using an array element.  Free all memory
  in auto-prepare mode.

Tom Lane committed:

- Fix CREATE TABLE ... LIKE ... INCLUDING INDEXES to not cause
  unwanted tablespace permissions failures when copying an index that
  is in the database's default tablespace.  A side-effect of the
  change is that explicitly specifying the default tablespace no
  longer triggers a permissions check; this is not how it was done in
  pre-8.3 releases but is argued to be more consistent.  Per bug #3921
  from Andrew Gilligan.  (Note: I argued in the subsequent discussion
  that maybe LIKE shouldn't copy index tablespaces at all, but since
  no one indicated agreement with that idea, I've refrained from doing
  it.)

- Fix silly mistake in expand_indexqual_rowcompare --- in converting a
  forboth() into an iteration over three parallel lists, I had
  accidentally put the lnext steps outside the loop.  Sigh.  Per bug
  #3938.

- Add missing copyfuncs/equalfuncs support for AlterTSDictionaryStmt
  and AlterTSConfigurationStmt.  All utility statement node types are
  expected to be supported here, though they do not have to have
  outfuncs/readfuncs support.  Found by running regression tests with
  COPY_PARSE_PLAN_TREES enabled.

- Add missing copyfuncs/equalfuncs support for AlterTSDictionaryStmt
  and AlterTSConfigurationStmt.  All utility statement node types are
  expected to be supported here, though they do not have to have
  outfuncs/readfuncs support.  Found by running regression tests with
  COPY_PARSE_PLAN_TREES enabled.

- Some variants of ALTER OWNER tried to make the "object" field of the
  statement be a list of bare C strings, rather than String nodes,
  which is what they need to be for copyfuncs/equalfuncs to work.
  Fortunately these node types never go out to disk (if they did, we'd
  likely have noticed the problem sooner), so we can just fix it
  without creating a need for initdb.  This bug has been there since
  8.0, but 8.3 exposes it in a more common code path (Parse messages)
  than prior releases did.  Per bug #3940 from Vladimir Kokovic.

- Avoid misbehavior in foreign key checks when casting to a datatype
  for which the parser supplies a default typmod that can result in
  data loss (ie, truncation).  Currently that appears to be only
  CHARACTER and BIT.  We can avoid the problem by specifying the
  type's internal name instead of using SQL-spec syntax.  Since the
  queries generated here are only used internally, there's no need to
  worry about portability.  This problem is new in 8.3; before we just
  let the parser do whatever it wanted to resolve the operator, but
  8.3 is trying to be sure that the semantics of FK checks are
  consistent.  Per report from Harald Fuchs.

- In pgsql/src/backend/libpq/auth.c, since GSSAPI and SSPI
  authentication don't work in protocol version 2, issue a helpful
  error message instead of sending unparsable garbage.  (It is clearly
  a design error that this doesn't work, but fixing it is not worth
  the trouble at this point.)  Per discussion.

- In pgsql/doc/src/sgml/protocol.sgml, some small editorialization on
  the protocol documentation for GSSAPI/SSPI authentication.

- In pgsql/src/backend/storage/page/bufpage.c, fix
  PageGetExactFreeSpace() so that it actually behaves sensibly if
  pd_lower > pd_upper, rather than merely claiming to.  This would
  only matter if the page header were corrupt, which shouldn't occur,
  but ...

Bruce Momjian committed:

- In pgsql/doc/src/sgml/release.sgml, add "automatically" to HOT
  release note description.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Manolo di Domenico sent in two revisions of a patch intended to refine
the external sorting algorithm by using a two-way replacement
selection algorithm.

Simon Riggs sent in an optimization of TransactionIdIsInProgress().

Tom Lane sent in a patch to fix a bug in VACUUM FULL.

-- 
		Andreas 'ads' Scherbaum
Deutsche PostgreSQL User Group: http://www.pgug.de
DPWN: http://ads.wars-nicht.de/blog/categories/18-PWN



-- 
				Andreas 'ads' Scherbaum
Failure is not an option. It comes bundled with your Microsoft product.
 (Ferenc Mantfeld)