Skip to content

Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007



Der Originalartikel befindet sich unter:
http://people.planetpostgresql.org/dfetter/


== Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007 ==

Frohes neues Jahr!

Trotz der "Urlaubswoche" gab es jede Menge Aktivitäten.
Wirf einen Blick auf die Patchliste für mehr Details.

== PostgreSQL Produkt Neuigkeiten ==

GNUmed 0.2.8.0 erschienen.
http://wiki.gnumed.de

Pgtcl-ng 1.6.2 erschienen.
http://pgfoundry.org/projects/pgtclng/

Viewalyzer 1.0.2 erschienen.
http://sourceforge.net/projects/viewalyzer/

xTuple Apps 2.3 erschienen.
http://www.xtuple.org/index.php?option=com_content&task=view&id=4281&Itemid=1

== PostgreSQL Jobs im Dezember ==

http://archives.postgresql.org/pgsql-jobs/2007-12/threads.php

== PostgreSQL Lokal ==

PGCon 2008 wird vom 20-23. Mai in Ottawa sein, Talks werden ab jetzt
akzeptiert.
http://www.pgcon.org/2008/papers.php

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@pgug.eu.
Für mehr Informationen siehe:
http://fosdem.org/2008/schedule/devroom/bsdpostgresql

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

FISL 9.0 findet vom 17. bis 19. April 2008 auf der PUCRS in Porto
Alegre, Brasilien statt. Vorträge sind bis zum 11. Januar 2008
einzureichen.
https://fisl.softwarelivre.org/9.0/

== 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@fetter.org, deutsche an
pwn@pgug.de, italienische an pwn@itpug.org.
== Angewandte Patches ==

Alvaro Herrera committed:

- In pgsql/contrib/uuid-ossp: uuid-ossp.c, add missing return code
checks in the uuid-ossp contrib module, per bug #3841.

Andrew Dunstan committed:

- In pgsql/src/backend/commands/copy.c, add sanity check to ensure
delimiter and quote are different in CSV mode.

Michael Meskes committed:

- In ecpg, applied patch send by ITAGAKI Takahiro to fix bug in
connect statement if user name is a variable. Also fixed test case
that didn't detect this.

Tom Lane committed:

- In pgsql/src/backend/commands/copy.c, swap the order of testing for
control characters and for column delimiter in
CopyAttributeOutText(), so that control characters are converted to
the C-style escape sequences even if they happen to be equal to the
column delimiter (as is true by default for tab, for example).
Oversight in my previous patch to restore pre-8.3 behavior of COPY
OUT escaping. Per report from Tomas Szepe.

- In pgsql/src/backend/commands/copy.c, fix ill-advised usage of x?y:z
expressions in errmsg() and errhint() calls. This prevented gettext
from recognizing the strings that need to be translated.

- In pgsql/src/backend/commands/copy.c, disallow digits and lower-case
ASCII letters as the delimiter in non-CSV COPY. We need a
restriction here because when the delimiter occurs as a data
character, it is emitted with a backslash, and that will only work
as desired if CopyReadAttributesText() will interpret the backslash
sequence as representing the second character literally. This is
currently untrue for 'b', 'f', 'n', 'r', 't', 'v', 'x', and octal
digits. For future-proofing and simplicity of explanation, it seems
best to disallow a-z and 0-9. We must also disallow dot, since "\."
by itself would look like copy EOF. Note: "\N" is by default the
null print string, so N would also cause a problem, but that is
already tested for.

- Improve consistency of error reporting in GUC assign_hook routines.
Some were reporting ERROR for interactive assignments and LOG for
other cases, some were saying nothing for non-interactive cases, and
a few did yet other things. Make them use a new function
GUC_complaint_elevel() to establish a reasonably uniform policy
about how to report. There are still a few edge cases such as
assign_search_path(), but it's much better than before. Per gripe
from Devrim Gunduz and subsequent discussion. As noted by Alvaro,
it'd be better to fold these custom messages into the standard
"invalid parameter value" complaint from guc.c, perhaps as the
DETAIL field. However that will require more redesign than seems
prudent for 8.3. This is a relatively safe, low-impact change that
we can afford to risk now.

- Update examples in planstats.sgml for 8.3, and improve some aspects
of that discussion. Add a link from perform.sgml.

- Improve a number of elog messages for not-supposed-to-happen cases
in btrees, since these seem to happen after all in corrupted
indexes. Make sure we supply the index name in all cases, and
provide relevant block numbers where available. Also consistently
identify the index name as such. Back-patch to 8.2, in hopes that
this might help Mason Hale figure out his problem.


Peter Eisentraut committed:

- Wording improvements in pgsql/src/backend/tsearch/ts_utils.c,
pgsql/src/backend/utils/adt/tsquery.c,
pgsql/src/backend/utils/adt/tsquery_cleanup.c,
pgsql/src/backend/utils/adt/tsvector_op.c,
pgsql/src/backend/utils/misc/guc.c and pgsql/src/port/open.c.

- In pgsql/doc/src/sgml/docguide.sgml, update required TeX settings.

- In pgsql/doc/src/sgml/stylesheet.dsl, disable LOT for the time being
because of TeX problems.

- In pgsql/src/port/open.c, change may to might.

Bruce Momjian committed:

- Add documentation section about preventing server spoofing. Update
SSL documention to be clearer about certificates, and restructure
for clarity.

- Add two documentation tables to outline SSL file usage for client
and server.

- Update docs to clarify purpose of SSL key file.

- In pgsql/doc/src/sgml/libpq.sgml, update docs: client always gets
server certificate.

- In pgsql/doc/src/sgml/runtime.sgml, document problem with NULL SSL
ciphers and man-in-the-middle attacks.

- In pgsql/doc/src/sgml/runtime.sgml, improve wording of NULL SSL
cipher.

- In pgsql/doc/src/sgml/client-auth.sgml, update docs mentioning PAM
doesn't work reading /etc/passwd because of non-root. Dhanaraj M

- In pgsql/doc/src/sgml/runtime.sgml, document that null ciphers are
not recommended. Mark Mielke

- In pgsql/doc/src/sgml/runtime.sgml, remove tab in file name.

- In pgsql/doc/src/sgml/wal.sgml, document how to control the disk
write cache on Solaris. Zdenek Kotala

- Update Japanese FAQ. Jun Kuwamura.

- Add to TODO: Allow SSL authentication/encryption over unix domain
sockets.
http://archives.postgresql.org/pgsql-hackers/2007-12/msg00924.php

- Remove TODO.detail for pg_upgrade.

- Update TODO list based on 8.3 completed items.

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Hans-Juergen Schoenig sent in a patch which updates Evgen Potemkin's
CONNECT BY PRIOR patch.
  • Twitter
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007 at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007
  • Bloglines Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007
  • Technorati Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007
  • Fark this: Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007 at YahooMyWeb
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007 at Furl.net
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007 at reddit.com
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007 at blinklist.com
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007 at Spurl.net
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007 at Simpy.com
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007 at blogmarks
  • Bookmark Wöchentlicher PostgreSQL Newsletter - 30. Dezember 2007 with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Trackbacks

No Trackbacks

Comments

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