Offres d'emplois autour de PostgreSQL en novembre

PostgreSQL Local

  • [ndt] Le PgDay 2012 argentin, programmé pour le 13 novembre à Buenos Aires, a été déménagé dans un nouvel endroit, plus proche du centre ville, afin de pouvoir satisfaire le grand nombre d'inscrits : http://www.pgday.com.ar/buenosaires2012/venue/index?lang=en
  • Le PgDay argentin 2012 se tiendra à l'Université Nationale de Quilmes, à Bernal près de Buenos Aires, le 13 novembre. Les sujets couverts concerneront aussi bien les utilisateurs, développeurs et contributeurs, que les décideurs et hauts responsables. Pour plus d'informations à propos de la conférence, consultez le site suivant : http://www.pgday.com.ar/quilmes2012?lang=en
  • Le PGDay équatorien de cette année se tiendra à Quito le 17 novembre. L'appel à conférenciers est lancé jusqu'au 10 octobre. Envoyez vos propositions à Jaime Casanova : jaime <AT> 2ndquadrant <DOT> com : https://wiki.postgresql.org/wiki/PGDay_Ecuador_2012
  • La sixième édition du PGDay italien aura lieu à Prato, Toscane, le 23 novembre 2012. Un appel international à conférenciers est lancé, conférences et présentations en anglais sont acceptées. Informations anglophones sur le processus de candidature disponibles ci-après : http://2012.pgday.it/call-for-papers/international-call-for-papers/

PostgreSQL dans les média

PostgreSQL Weekly News / les nouvelles hebdomadaires vous sont offertes cette semaine par David Fetter. Traduction par l'équipe PostgreSQLFr sous licence CC BY-NC-SA.

Proposez vos articles ou annonces avant dimanche 15:00 (heure du Pacifique). Merci de les envoyer en anglais à david (a) fetter.org, en allemand à pwn (a) pgug.de, en italien à pwn (a) itpug.org et en espagnol à pwn (a) arpug.com.ar.

(lien vers l'article original)

Correctifs appliqués

Tom Lane a poussé :

  • Fix handling of inherited check constraints in ALTER COLUMN TYPE. This case got broken in 8.4 by the addition of an error check that complains if ALTER TABLE ONLY is used on a table that has children. We do use ONLY for this situation, but it's okay because the necessary recursion occurs at a higher level. So we need to have a separate flag to suppress recursion without making the error check. Reported and patched by Pavan Deolasee, with some editorial adjustments by me. Back-patch to 8.4, since this is a regression of functionality that worked in earlier branches. http://git.postgresql.org/pg/commitdiff/5ed6546cf75623ba426942a3b71659a66cf7ed68
  • Fix missing inclusions. Some platforms require including <netinet/in.h> and/or <arpa/inet.h> to use htonl() and ntohl(). Per build failure locally. http://git.postgresql.org/pg/commitdiff/9e45e03886c75dd049bcc1b063e0bf34e46a3a62
  • Don't trash input list structure in does_not_exist_skipping(). The trigger and rule cases need to split up the input name list, but they mustn't corrupt the passed-in data structure, since it could be part of a cached utility-statement parsetree. Per bug #7641. http://git.postgresql.org/pg/commitdiff/75af5ae9c017d70531bd49178adfd3103cd40a76
  • Rename ResolveNew() to ReplaceVarsFromTargetList(), and tweak its API. This function currently lacks the option to throw error if the provided targetlist doesn't have any matching entry for a Var to be replaced. Two of the four existing call sites would be better off with an error, as would the usage in the pending auto-updatable-views patch, so it seems past time to extend the API to support that. To do so, replace the "event" parameter (historically of type CmdType, though it was declared plain int) with a special-purpose enum type. It's unclear whether this function might be called by third-party code. Since many C compilers wouldn't warn about a call site continuing to use the old calling convention, rename the function to forcibly break any such code that hasn't been updated. The old name was none too well chosen anyhow. http://git.postgresql.org/pg/commitdiff/dcc55dd21aa2ba18b28ba9fa441885ef9c99d3c6
  • Fix WaitLatch() to return promptly when the requested timeout expires. If the sleep is interrupted by a signal, we must recompute the remaining time to wait; otherwise, a steady stream of non-wait-terminating interrupts could delay return from WaitLatch indefinitely. This has been shown to be a problem for the autovacuum launcher, and there may well be other places now or in the future with similar issues. So we'd better make the function robust, even though this'll add at least one gettimeofday call per wait. Back-patch to 9.2. We might eventually need to fix 9.1 as well, but the code is quite different there, and the usage of WaitLatch in 9.1 is so limited that it's not clearly important to do so. Reported and diagnosed by Jeff Janes, though I rewrote his patch rather heavily. http://git.postgresql.org/pg/commitdiff/3e7fdcffd6f77187b72b0496d61d782932973af6
  • Check for stack overflow in transformSetOperationTree(). Since transformSetOperationTree() recurses, it can be driven to stack overflow with enough UNION/INTERSECT/EXCEPT clauses in a query. Add a check to ensure it fails cleanly instead of crashing. Per report from Matthew Gerber (though it's not clear whether this is the only thing going wrong for him). Historical note: I think the reasoning behind not putting a check here in the beginning was that the check in transformExpr() ought to be sufficient to guard the whole parser. However, because transformSetOperationTree() recurses all the way to the bottom of the set-operation tree before doing any analysis of the statement's expressions, that check doesn't save it. http://git.postgresql.org/pg/commitdiff/34f3b396a6554903007031b0541781b7ecdd6e4d

Bruce Momjian a poussé :

Heikki Linnakangas a poussé :

  • Make the streaming replication protocol messages architecture-independent. We used to send structs wrapped in CopyData messages, which works as long as the client and server agree on things like endianess, timestamp format and alignment. That's good enough for running a standby server, which has to run on the same platform anyway, but it's useful for tools like pg_receivexlog to work across platforms. This breaks protocol compatibility of streaming replication, but we never promised that to be compatible across versions, anyway. http://git.postgresql.org/pg/commitdiff/add6c3179a4d4fa3e62dd3e86a00f23303336bac
  • Teach pg_basebackup and pg_receivexlog to reply to server keepalives. Without this, the connection will be killed after timeout if wal_sender_timeout is set in the server. Original patch by Amit Kapila, modified by me to fit recent changes in the code. http://git.postgresql.org/pg/commitdiff/a9dad56441e4bc5d20c34bd56daf8e72df1b22d3

Alvaro Herrera a poussé :

Peter Eisentraut a poussé :

Correctifs rejetés (à ce jour)

  • Chen Huajun's patch to fix the errcontext() function. Not all compilers support the varargs macros on which it depends.

Correctifs en attente

  • Pavel Stehule sent in another revision of the \gset patch for psql.
  • Karl O. Pinc sent in two more revisions of a patch to fix some table formatting in the docs.
  • Robert Haas sent in a patch to fix a failure to infer types in functions.
  • Laurenz Albe sent in a patch extending libpq to support combinations of text and binary results.
  • Amit Kapila sent in another revision of the patch to improve performance for update operations by reducing WAL activity.
  • Fujii Masao sent in a patch which adds a pgstatginindex() function.
  • Fujii Masao sent in two patches to make walreceiver detect network partitions faster, one by not checking for integer_datetimes, the other by removing redundant GetCurrentTimestamp() calls from XLogWalRcvSendReply() and XLogWalRcvSendHSFeedback(), where --enable-integer-datetimes is on.
  • Jeff Janes sent in a patch to fix the bug where autovacuum is being starved by sinval messages. The approach taken involves adding a poll timeout.
  • Jeff Janes sent in a patch to fix pg_dump for pg_upgrade purposes.
  • Jon Erdman sent in two revisions of a patch to indicate a function's security status (invoker or definer) in \df+ output.
  • Tom Lane sent in three revisions of a patch to fix an oversight in buffer locking during hot standby replay.
  • Tomas Vondra sent in another revision of a patch to allow admins to cut down the amount of output in pg_bench via sampling every five seconds rather than constantly.
  • Tomas Vondra sent in another revision of the patch to make dropping multiple tables quicker.
  • Tomas Vondra sent in another revision of a patch to enable writing aggregate input to the log.