ports/145003: Port update

[Khee Chin]

>Number:         145003
>Category:       ports
>Synopsis:       Port update
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          update
>Submitter-Id:   current-users
>Arrival-Date:   Wed Mar 24 10:10:02 UTC 2010
>Closed-Date:
>Last-Modified:
>Originator:     Khee Chin
>Release:        8.0
>Organization:
>Environment:
FreeBSD leonidas 8.0-RELEASE FreeBSD 8.0-RELEASE #0: Sat Nov 21 15:02:08 UTC 2009     root at mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  amd64
>Description:
Port update for database/skytools/
from 2.1.10 to 2.1.11

List of bugfixes (lifted verbatim from http://pgfoundry.org/frs/shownotes.php?release_id=1580 ):
= Fixes =

  * londiste, pgq smart triggers: crash in case the table info cache
    invalidation callback was called from signal handler.  Fix it by
    moving cache operations out of callback.

  * walmgr:
    - symlink handling for pg_log and pg_xlog
    - Set archive_command to "/bin/true" for restored postgresql.conf
    (Martin Pihlak, Mark Kirkwood)

  * londiste copy:
    - Make constraint dropping work for inherited tables
      (Hannu Krosing)

    - Do not restore fkeys to tables with unknown replication status
      or coming from different queue.  (Hannu Krosing)

    - Use TRUNCATE ONLY on 8.4+.  (Sergey Konoplev)

    - Replace last copy pidfile check with signal_pidfile,
      thus avoiding potential infinite stall with dead copy.

  * londiste repair: set LC_ALL=C when calling 'sort' to have
    byte based sorting.

  * skytools.DBScript:
    - Add --version switch to show skytools version.  (Hannu Krosing)

    - Safer pidfile handling - avoid creating zero-length files
      on disk full situation by deleting them on write error.

  * pgq.Event: ev.retry, ev.ev_retry fields for retry count.
    (Nico Mandery)

  * pgq.maint_retry_events(): lock table to allow only single mover.

  * pgq.logutriga() did not put custom pkey= value into events.

  * pgq.logutriga() and pgq.sqltriga() did allow UPDATE and DELETE
    on tables without pkey, running into SQL errors downstream.
    They should throw error in such case.

  * Fix DeprecationWarning on Python 2.6 vs. 'import sets'.

  * make deb: Work around Debian's --install-layout related braindamage.


>How-To-Repeat:

>Fix:
Patch attached.

Patch attached with submission follows:

diff -ruN skytools/Makefile skytools-new/Makefile
--- skytools/Makefile	2010-03-24 17:16:08.000000000 +0800
+++ skytools-new/Makefile	2010-03-24 16:49:56.000000000 +0800
@@ -6,10 +6,10 @@
 #
 
 PORTNAME=	skytools
-PORTVERSION=	2.1.10
+PORTVERSION=	2.1.11
 PORTREVISION=	1
 CATEGORIES=	databases
-MASTER_SITES=	http://pgfoundry.org/frs/download.php/2370/
+MASTER_SITES=	http://pgfoundry.org/frs/download.php/2561/
 
 MAINTAINER=	kheechin at gmail.com
 COMMENT=	PostgreSQL tools from Skype: walshipping, queueing, replication
diff -ruN skytools/distinfo skytools-new/distinfo
--- skytools/distinfo	2010-03-24 17:16:08.000000000 +0800
+++ skytools-new/distinfo	2010-03-24 16:52:21.000000000 +0800
@@ -1,3 +1,3 @@
-MD5 (skytools-2.1.10.tar.gz) = 1fe735f5599f479ba0a52b222f3100b2
-SHA256 (skytools-2.1.10.tar.gz) = 1e61993ca6b62dd1d36bbc6bb7add9d08951ef6364a8714c0985c7de91f811e0
-SIZE (skytools-2.1.10.tar.gz) = 257629
+MD5 (skytools-2.1.11.tar.gz) = 1451a5fc47bf9a28339f7dff28d8b11a
+SHA256 (skytools-2.1.11.tar.gz) = fdfbb428d41a5f16c3cf7b7a3a0dcc5e500e102c898311825310a30889a82c71
+SIZE (skytools-2.1.11.tar.gz) = 249019


>Release-Note:
>Audit-Trail:
>Unformatted: