== Wöchentlicher PostgreSQL Newsletter - 28. November 2010 ==

== Wöchentlicher PostgreSQL Newsletter - 28. November 2010 ==

am 29.11.2010 22:48:41 von adsmail

Der Originalartikel befindet sich unter:

http://www.postgresql.org/community/weeklynews/pwn20101128



== Wöchentlicher PostgreSQL Newsletter - 28. November 2010 ==

== PostgreSQL Produkt Neuigkeiten ==

DiffKit 0.8.2, ein Vergleichswerkzeug für Tabellen mit Support
für PostgreSQL, ist erschienen.
http://www.diffkit.org

PostgreDAC 2.6.0, ein Delphi/C++ Builder für PostgreSQL,
ist erschienen.
http://microolap.com/products/connectivity/postgresdac/downl oad/

== PostgreSQL Jobs im November ==

http://archives.postgresql.org/pgsql-jobs/2010-11/threads.ph p

== PostgreSQL Lokal ==

Der Call für Projekte des PostgreSQLFr hat begonnen. Projekte müs=
sen
sich um PostgreSQL drehen und die französisch-sprechende Community
betreffen. Maile Projektvorschläge an appel-projets-2010
AT postgresql DOT fr.
http://www.postgresql.fr/appel_a_projets_2010:call_for_proje cts

Registrierung für PGDay.EU 2010 vom 6. bis 8. Dezember in
Stuttgart, Deutschland ist bis zum 4. Dezember offen.
http://2010.pgday.eu/register

Registrierung für PGDay.IT am 10. Dezember 2010 in Rom,
Italien ist jetzt offen und der Vortragsplan ist online.
http://2010.pgday.it/

FOSDEM ist eine der größten Freien und Open Source Veranstaltungen
und findet jährlich in Brüssel, Belgien statt, nächstes Jahr=
am
5. und 6. Februar 2011. Ungefähr 4.000 Besucher finden sich dort ein.
Sende deine Vorträge an fosdem AT postgresql DOT eu.
http://andreas.scherbaum.la/blog/archives/749-PostgreSQLFOSD EM-2011-Call-fo=
r-talks.html

PGDay findet dieses Jahr während der südkalifornischen Linux Auss=
tellung
(SCALE) im LAX Hilton Hotel in Los Angeles, Kalifornien am Freitag dem
25. Februar 2011 statt. Vorträge kannst du unter pgday-submissions AT
googlegroups DOT com einreichen.

PGCon will be May 19-20, 2011 at the University of Ottawa, preceded by
two days of tutorials on May 17-18.
http://www.pgcon.org/2011/

== PostgreSQL in den News ==

Planet PostgreSQL: http://planet.postgresql.org/

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David Fet=
ter.

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, spanische an pwn@arpug.com.ar.

== Reviews ==

Magnus Hagander reviewed the patch to add getrusage tracking to
EXPLAIN ANALYZE and found some breakage on Windows.

Steve Singer reviewed another revision of Gurjeet Singh's patch to
allow ALTER TABLE to create a primary key from an existing index.

ITAGAKI Takahiro reviewed the pg_execute_from_file patch and found an
OID collision, a compiler warning and some English, access control and
internationalization issues.

== Angewandte Patches ==

Alvaro Herrera pushed:

- Remove GucContext parameter from ParseConfigFile.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5272=
d7987506554f6b2bde740e1b4d7e4a0b8608

Robert Haas pushed:

- Centralize some ALTER .. SET SCHEMA checks. Any flavor
of ALTER .. SET SCHEMA fails if (1) the object is already
in the new schema, (2) either the old or new schema is a temp
schema, or (3) either the old or new schema is the TOAST schema.
Extraced from a patch by Dimitri Fontaine, with additional hacking
by me.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4447=
5e782f4674d257b9e5c1a3930218a4b4deea

- Remove belt-and-suspenders guards against buffer pin leaks.
Forcibly releasing all leftover buffer pins should be unnecessary
now that we have a robust ResourceOwner mechanism, and it
significantly increases the cost of process shutdown. Instead, in
an assert-enabled build, assert that no pins are held; in a
non-assert-enabled build, do nothing.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dc228=
1ac87cf4828b6b828dc8585a10aeb3a176e0

- Add inet_net_ntop.c to .gitignore.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D2d1e=
426650fc93e5dfdd0178023485d38b03b102

- Object access hook framework, with post-creation hook. After a SQL
object is created, we provide an opportunity for security or logging
plugins to get control; for example, a security label provider could
use this to assign an initial security label to newly created
objects. The basic infrastructure is (hopefully) reusable for other
types of events that might require similar treatment. KaiGai Kohei,
with minor adjustments.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dcc1e=
d40d57aa68322e43a7b0a3320a6c5aff010a

- Add more ALTER .. SET SCHEMA commands. This adds support
for changing the schema of a conversion, operator, operator class,
operator family, text search configuration, text search dictionary,
text search parser, or text search template. Dimitri Fontaine, with
assorted corrections and other kibitzing.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5510=
9313f96fb5c7d671fe8954b6f7fc0cca9631

- New contrib module, auth_delay. KaiGai Kohei, with a few changes by
me.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dfe7a=
32fc87e68edf014ee7e575f92cb027437ff4

- Fix typo. Fujii Masao.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dfab7=
fdb988f25438ded6c4a5c4b4f112f9decddb

Peter Eisentraut pushed:

- Propagate ALTER TYPE operations to typed tables. This adds
RESTRICT/CASCADE flags to ALTER TYPE ... ADD/DROP/ALTER/ RENAME
ATTRIBUTE to control whether to alter typed tables as well.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Df2a4=
278330ae12cd56b61c92a7debb9c9fca7b41

- Remove useless whitespace at end of lines.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dfc94=
6c39aeacdff7df60c83fca6582985e8546c8

- Add index entries for more functions. Also, move index entries into
the tables, closer to the function description, for easier editing
in the future. Resort some tables to be more alphabetical. Remove
the entries for count, max, min, and sum in the tutorial area,
because that was felt to be confusing. Thom Brown.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4fc0=
9ad00c3cc95003a5523d85999da1dd4f9d75

Tom Lane pushed:

- Create the system catalog infrastructure needed for KNNGIST. This
commit adds columns amoppurpose and amopsortfamily to pg_amop, and
column amcanorderbyop to pg_am. For the moment all the entries in
amcanorderbyop are "false", since the underlying support isn't there
yet. Also, extend the CREATE OPERATOR CLASS/ALTER OPERATOR FAMILY
commands with [ FOR SEARCH | FOR ORDER BY sort_operator_family ]
clauses to allow the new columns of pg_amop to be populated, and
create pg_dump support for dumping that information. I also added
some documentation, although it's perhaps a bit premature given that
the feature doesn't do anything useful yet. Teodor Sigaev, Robert
Haas, Tom Lane.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D725d=
52d0c27cffe8c99bb78e2b0d2480d5cd702b

- Fix significant memory leak in contrib/xml2 functions. Most of the
functions that execute XPath queries leaked the data structures
created by libxml2. This memory would not be recovered until end of
session, so it mounts up pretty quickly in any serious use of the
feature. Per report from Pavel Stehule, though this isn't his
patch. Back-patch to all supported branches.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4a25=
16a7f976e2f6671930904d4e97a4832eff9f

- Remove bogus use of PGDLLIMPORT. That macro should be attached to
extern declarations, not actual definitions of variables.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D1d9a=
0abec1224193fea3acf766b587fc3963a3b8

- Fix portability issues in new src/port/inet_net_ntop.c file. 1.
Don't #include postgres.h in a frontend build. 2. Don't assume that
the backend's symbol PGSQL_AF_INET6 has anything to do with the
constant that will be used by system library functions (because, in
point of fact, it usually doesn't). Fortunately, PGSQL_AF_INET is
equal to AF_INET, so we can just cater for both sets of values in
one case construct without fear of conflict.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D3840=
bc0847aa1b635127ff4a55b5257c9ebc79b8

- Clean up IPv4 vs IPv6 bogosity in connectFailureMessage(). Newly
added code was supposing that "struct sockaddr_in" applies to IPv6.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dbe3b=
666eb810089fd9a1d42e3888be52ab9ddb63

- Rewrite PQping to be more like what we agreed to last week.
Basically, we want to distinguish all cases where the connection was
not made from those where it was. A convenient proxy for this is to
see if we got a message with a SQLSTATE code back from the
postmaster. This presumes that the postmaster will always send us a
SQLSTATE in a failure message, which is true for 7.4 and later
postmasters in every case except fork failure. (We could possibly
complicate the postmaster code to do something about that, but it
seems not worth the trouble, especially since pg_ctl's response for
that case should be to keep waiting anyway.) If we did get a
SQLSTATE from the postmaster, there are basically only two cases, as
per last week's discussion: ERRCODE_CANNOT_CONNECT_NOW and
everything else. Any other error code implies that the postmaster
is in principle willing to accept connections, it just didn't like
or couldn't handle this particular request. We want to make a
special case for ERRCODE_CANNOT_CONNECT_NOW so that "pg_ctl start
-w" knows it should keep waiting. In passing, pick names for the
enum constants that are a tad less likely to present collision
hazards in future.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Ddb96=
e1ccfcb8f3514eef931bea9435974ec7ad28

- On further testing, PQping also needs an explicit check for
AUTH_REQ. The pg_fe_sendauth code might fail if it can't handle the
authentication request message type --- if so, ping should still say
the server is up.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D49cd=
8a3f810467632260f16c7779f19212c1d094

- A bit more wordsmithing on the PQping documentation.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dd53c=
1255d9730b07d56166ace1191250ca76f496

- Point out in default_tablespace's description that CREATE DATABASE
ignores it. Per gripe from Andreas Scherbaum.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dc623=
365ff9a5ef937e05b85c2feb5a5c5cde9b3b

Bruce Momjian pushed:

- When reporting the server as not responding, if the hostname was
supplied, also print the IP address. This allows IPv4 and IPv6
failures to be distinguished. Also useful when a hostname resolves
to multiple IP addresses. Also, remove use of inet_ntoa() and use
our own inet_net_ntop() in all places, including in libpq, because
it is thread-safe.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dba11=
258ccbf364d85de48b8b7fd46953ea7bb4f4

- Document that a CHECKPOINT before taking a file system snapshot can
reduce recovery time.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D7276=
ab5888d85782d988fc297ad2e176c7ad1bca

- Properly add new inet_net_ntop file to libpq Makefile.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D58df=
b07b5d84c0088033e2d22fc44df812fa6eb5

- Restructure how libpq includes external C files, for clarity.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dc697=
8ecd6f761388d8479c8b32cfd0dd2d2bd4ac

- Fix getaddrinfo() in pgport to use proper parameters, as detected by
Win32 buildfarm members.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D212a=
1c7b0b4164e15381af327ee6656ae7e02298

- Add PQping and PQpingParams to libpq to allow detection of the
server's status, including a status where the server is running but
refuses a postgres connection. Have pg_ctl use this new function.
This fixes the case where pg_ctl reports that the server is not
running (cannot connect) but in fact it is running.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dafd7=
d9adca971d9aae97e87ce617d8608d25ab10

- Improve pg_ctl "cannot connect" warning, per suggestion from Magnus.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4646=
e0cef70d2f9a6bb1764cee5c13b7bbd23625

- Improve pg_ctl "cannot connect" spacing, per Tom Lane, and wording.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D5f4b=
3d750b7648d90486827a3de58c226daa2c58

- In libpq/Makefile, merge PERM_PGPORT and OPT_PGPORT into a single
Makefile variable PGPORT, for clarity.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Da9b0=
2ec654434e7e395b8677ba142a99eed7eb5e

- Abandon use of Makefile variables in libpq/Makefile because MSVC
scrapes the OBJS lines from that file. Cleanup where possible.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D4f6d=
eef2fb7ddc6b3c6b901db66072cf65ccaa27

- Use only addr_cur when reporting connection failures in libpq.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Ded51=
bd4968a903e13bdcded869a644fd0d28353c

- Update comment that says we only report last libpq connection
failure, per Peter Eisentraut.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dbad8=
277f13c31350abd7571af51d272bd1401f3c

- Use conn->raddr consistently for non-connect libpq error reporting.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Df2eb=
a413db99fcde9a4d3a9f52578dc4e7f5d5ec

- Add inet_net_ntop.c as needed by MSVC, per Magnus Hagander.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3De6e3=
8b4ac21cc25fb8187e573a672ff17d9b2801

- In libpq/Makefile, use OBJS +=3D as a way to break up long link lines
into something that can be documented.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3D1f48=
290a9d6d000d1b5012b9304b734ecb9cc759

ITAGAKI Takahiro pushed:

- Don't raise "identifier will be truncated" messages in dblink except
creating new connections.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Dd3c1=
26544342728ab4b5c167b4f4b01a39270db5

Simon Riggs pushed:

- Move call to GetTopTransactionId() earlier in LockAcquire(),
removing an infrequently occurring race condition in Hot Standby.
An xid must be assigned before a lock appears in shared memory,
rather than immediately after, else GetRunningTransactionLocks() may
see InvalidTransactionId, causing assertion failures during lock
processing on standby. Bug report and diagnosis by Fujii Masao, fix
by me.
=20
http://git.postgresql.org/gitweb?p=3Dpostgresql.git;a=3Dcomm itdiff;h=3Ded78=
384acd691e3336e170aa18af69d15d088027

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Gurjeet Singh sent in another revision of the patch to allow ALTER
TABLE to create a primary key from an existing index.

Pavel Stehule sent in a patch to make de-TOAST only once when needed
in PL/pgsql.

Dimitri Fontaine sent in three more revisions of the unified
configuration file parser patch.

David Wheeler sent in a doc patch for the new ALTER ENUM..ADD VALUE.

Shigeru HANADA split the SQL/MED into three separate patches and
updated same.

Pursuant to a review by Josh Tolley, Dimitri Fontaine sent in another
revision of the execute_from_file() patch.

Heikki Linnakangas and Robert Haas traded patches for to lighten the
overhead assocated with connecting to the database.

Steve Singer sent in another version of the patch to use an existing
index for a primary key.

KaiGai Kohei sent in another revision of the label switcher function.

Fujii Masao sent in another revision of the libpq patches intended to
enable synchronous replication.

ITAGAKI Takahiro sent in another revision of the patch to add a
format() function with to_char().

Heikki Linnakangas sent in another revision of the GiST insert
algorithm rewrite.

Tom Lane sent in two revisions of a patch redo the representation of
sorting and hashing in queries and plans.

Quan Zongliang sent in a patch to fix a bug where pg_ctl -w (re)start
fails with a custom unix_socket_directory.

Marti Raudsepp sent in a patch to return the command tag, 'REPLACE X'
for CREATE OR REPLACE statements.

Joachim Wieland sent in another revision of the patches which allow
pluggable compression algorithms in pg_dump and add a directory format
to pg_dump/pg_restore's formats.

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




--=20
Sent via pgsql-de-allgemein mailing list (pgsql-de-allgemein@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-de-allgemein