Hello community, here is the log from the commit of package postgresql-plr for openSUSE:Factory checked in at 2013-08-01 16:01:58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/postgresql-plr (Old) and /work/SRC/openSUSE:Factory/.postgresql-plr.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "postgresql-plr" Changes: -------- --- /work/SRC/openSUSE:Factory/postgresql-plr/postgresql-plr.changes 2013-01-10 13:52:06.000000000 +0100 +++ /work/SRC/openSUSE:Factory/.postgresql-plr.new/postgresql-plr.changes 2013-08-01 16:02:00.000000000 +0200 @@ -1,0 +2,12 @@ +Wed Jul 24 14:57:26 UTC 2013 - [email protected] + +- Upgrade to 8.3.0.14 + Update copyright for 2013 + Remove hack to take signal back from R interpreter (Mark Kirkwood) + Set R_SignalHandlers = 0, the proper way to prevent R from taking signals in the first place (Mark Kirkwood) + Adjust RPM spec file + As of pg9.2 the syntax "LANGUAGE 'C'" no longer works. Use "LANGUAGE C" instead. + The MacPorts installation has the header filed distributed across two different directories, so there is no single "rincludedir" to query from pkg-config. Instead, do it the proper way and ask pkg-config for the cflags, which should work for all installation variants. (Peter Eisentraut) + + +------------------------------------------------------------------- Old: ---- plr-8.3.0.13.1.tar.gz New: ---- plr-8.3.0.14.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ postgresql-plr.spec ++++++ --- /var/tmp/diff_new_pack.fmYtAP/_old 2013-08-01 16:02:01.000000000 +0200 +++ /var/tmp/diff_new_pack.fmYtAP/_new 2013-08-01 16:02:01.000000000 +0200 @@ -30,7 +30,7 @@ License: GPL-2.0+ Group: Productivity/Databases/Servers Name: postgresql-%{sname} -Version: 8.3.0.13.1 +Version: 8.3.0.14 Release: 1.0 Source0: %{sname}-%{version}.tar.gz Source1: readme.SUSE ++++++ patch-Makefile-ldflags.patch ++++++ --- /var/tmp/diff_new_pack.fmYtAP/_old 2013-08-01 16:02:01.000000000 +0200 +++ /var/tmp/diff_new_pack.fmYtAP/_new 2013-08-01 16:02:01.000000000 +0200 @@ -1,13 +1,13 @@ ---- Makefile 2011-08-30 00:42:56.000000000 +0200 -+++ Makefile.fix 2012-03-03 19:44:50.021665030 +0100 +--- Makefile 2013-02-26 23:19:30.000000000 +0100 ++++ Makefile.fix 2013-07-24 16:53:09.978013465 +0200 @@ -21,7 +21,7 @@ - PG_CPPFLAGS += -I$(r_includespec) + PG_CPPFLAGS += $(r_includespec) SRCS += plr.c pg_conversion.c pg_backend_support.c pg_userfuncs.c pg_rsupport.c OBJS := $(SRCS:.c=.o) -SHLIB_LINK += -L$(r_libdir1x) -L$(r_libdir2x) -lR +SHLIB_LINK += -L$(r_libdir1x) -L$(r_libdir2x) -lR $(LDFLAGS) DATA_built = plr.sql - DATA = plr--8.3.0.13.sql plr--unpackaged--8.3.0.13.sql + DATA = plr--8.3.0.14.sql plr--unpackaged--8.3.0.14.sql DOCS = README.plr @@ -72,6 +72,7 @@ override CPPFLAGS := -I"$(srcdir)" -I"$(r_includespec)" $(CPPFLAGS) ++++++ plr-8.3.0.13.1.tar.gz -> plr-8.3.0.14.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/Makefile new/plr/Makefile --- old/plr/Makefile 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/Makefile 2013-02-26 23:19:30.000000000 +0100 @@ -4,13 +4,13 @@ r_libdir1x = ${R_HOME}/bin r_libdir2x = ${R_HOME}/lib # location of R includes -r_includespec = ${R_HOME}/include +r_includespec = -I${R_HOME}/include rhomedef = ${R_HOME} else R_HOME := $(shell pkg-config --variable=rhome libR) r_libdir1x := $(shell pkg-config --variable=rlibdir libR) r_libdir2x := $(shell pkg-config --variable=rlibdir libR) -r_includespec := $(shell pkg-config --variable=rincludedir libR) +r_includespec := $(shell pkg-config --cflags-only-I libR) rhomedef := $(shell pkg-config --variable=rhome libR) endif @@ -18,12 +18,12 @@ EXTENSION = plr MODULE_big = plr -PG_CPPFLAGS += -I$(r_includespec) +PG_CPPFLAGS += $(r_includespec) SRCS += plr.c pg_conversion.c pg_backend_support.c pg_userfuncs.c pg_rsupport.c OBJS := $(SRCS:.c=.o) SHLIB_LINK += -L$(r_libdir1x) -L$(r_libdir2x) -lR DATA_built = plr.sql -DATA = plr--8.3.0.13.sql plr--unpackaged--8.3.0.13.sql +DATA = plr--8.3.0.14.sql plr--unpackaged--8.3.0.14.sql DOCS = README.plr REGRESS = plr EXTRA_CLEAN = doc/html/* doc/plr-US.aux doc/plr-*.log doc/plr-*.out doc/plr-*.pdf doc/plr-*.tex-pdf diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/README.plr new/plr/README.plr --- old/plr/README.plr 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/README.plr 2013-02-26 23:19:30.000000000 +0100 @@ -2,7 +2,7 @@ * PL/R - PostgreSQL support for R as a * procedural language (PL) * - * Copyright (c) 2003-2010 by Joseph E. Conway + * Copyright (c) 2003-2013 by Joseph E. Conway * ALL RIGHTS RESERVED * * Joe Conway <[email protected]> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/index.html new/plr/doc/html/index.html --- old/plr/doc/html/index.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/index.html 2013-02-26 23:19:30.000000000 +0100 @@ -17,7 +17,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="BOOK" ><DIV diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-aggregate-funcs.html new/plr/doc/html/plr-aggregate-funcs.html --- old/plr/doc/html/plr-aggregate-funcs.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-aggregate-funcs.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="PostgreSQL Support Functions" -HREF="plr-pgsql-support-funcs.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Window Functions" -HREF="plr-window-funcs.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-data.html new/plr/doc/html/plr-data.html --- old/plr/doc/html/plr-data.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-data.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Functions and Arguments" -HREF="plr-funcs.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Using Global Data" -HREF="plr-global-data.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-func-naming.html new/plr/doc/html/plr-func-naming.html --- old/plr/doc/html/plr-func-naming.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-func-naming.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Loading R Modules at Startup" -HREF="plr-module-funcs.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Trigger Procedures" -HREF="plr-trigger-func.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-funcs.html new/plr/doc/html/plr-funcs.html --- old/plr/doc/html/plr-funcs.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-funcs.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Installation" -HREF="plr-install.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Passing Data Values" -HREF="plr-data.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-global-data.html new/plr/doc/html/plr-global-data.html --- old/plr/doc/html/plr-global-data.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-global-data.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Passing Data Values" -HREF="plr-data.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Database Access and Support Functions" -HREF="plr-spi-rsupport-funcs.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-install.html new/plr/doc/html/plr-install.html --- old/plr/doc/html/plr-install.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-install.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Overview" -HREF="plr-overview.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Functions and Arguments" -HREF="plr-funcs.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-license.html new/plr/doc/html/plr-license.html --- old/plr/doc/html/plr-license.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-license.html 2013-02-26 23:19:30.000000000 +0100 @@ -20,7 +20,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -57,9 +57,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Trigger Procedures" -HREF="plr-trigger-func.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -67,12 +67,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -> </TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" > </TD diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-module-funcs.html new/plr/doc/html/plr-module-funcs.html --- old/plr/doc/html/plr-module-funcs.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-module-funcs.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Window Functions" -HREF="plr-window-funcs.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="R Function Names" -HREF="plr-func-naming.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-overview.html new/plr/doc/html/plr-overview.html --- old/plr/doc/html/plr-overview.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-overview.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="" -HREF="index.html#AEN3" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Installation" -HREF="plr-install.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-pgsql-support-funcs.html new/plr/doc/html/plr-pgsql-support-funcs.html --- old/plr/doc/html/plr-pgsql-support-funcs.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-pgsql-support-funcs.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Database Access and Support Functions" -HREF="plr-spi-rsupport-funcs.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Aggregate Functions" -HREF="plr-aggregate-funcs.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-spi-rsupport-funcs-compat.html new/plr/doc/html/plr-spi-rsupport-funcs-compat.html --- old/plr/doc/html/plr-spi-rsupport-funcs-compat.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-spi-rsupport-funcs-compat.html 2013-02-26 23:19:30.000000000 +0100 @@ -26,7 +26,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="SECT1" ><DIV @@ -63,9 +63,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Database Access and Support Functions" HREF="plr-spi-rsupport-funcs.html" ->Fast Backward</A +ACCESSKEY="U" +>Up</A ></TD ><TD WIDTH="60%" @@ -73,16 +73,7 @@ VALIGN="bottom" >Chapter 6. Database Access and Support Functions</TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Database Access and Support Functions" -HREF="plr-spi-rsupport-funcs.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-spi-rsupport-funcs-normal.html new/plr/doc/html/plr-spi-rsupport-funcs-normal.html --- old/plr/doc/html/plr-spi-rsupport-funcs-normal.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-spi-rsupport-funcs-normal.html 2013-02-26 23:19:30.000000000 +0100 @@ -26,7 +26,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="SECT1" ><DIV @@ -63,9 +63,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Database Access and Support Functions" HREF="plr-spi-rsupport-funcs.html" ->Fast Backward</A +ACCESSKEY="U" +>Up</A ></TD ><TD WIDTH="60%" @@ -73,16 +73,7 @@ VALIGN="bottom" >Chapter 6. Database Access and Support Functions</TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Database Access and Support Functions" -HREF="plr-spi-rsupport-funcs.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-spi-rsupport-funcs.html new/plr/doc/html/plr-spi-rsupport-funcs.html --- old/plr/doc/html/plr-spi-rsupport-funcs.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-spi-rsupport-funcs.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Using Global Data" -HREF="plr-global-data.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="PostgreSQL Support Functions" -HREF="plr-pgsql-support-funcs.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-trigger-func.html new/plr/doc/html/plr-trigger-func.html --- old/plr/doc/html/plr-trigger-func.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-trigger-func.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="R Function Names" -HREF="plr-func-naming.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="License" -HREF="plr-license.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/doc/html/plr-window-funcs.html new/plr/doc/html/plr-window-funcs.html --- old/plr/doc/html/plr-window-funcs.html 2011-09-10 20:41:12.000000000 +0200 +++ new/plr/doc/html/plr-window-funcs.html 2013-02-26 23:19:30.000000000 +0100 @@ -23,7 +23,7 @@ HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" -CONTENT="2011-09-10T18:39:12"></HEAD +CONTENT="2013-02-26T22:14:43"></HEAD ><BODY CLASS="CHAPTER" ><DIV @@ -60,9 +60,9 @@ ALIGN="left" VALIGN="top" ><A -TITLE="Aggregate Functions" -HREF="plr-aggregate-funcs.html" ->Fast Backward</A +HREF="index.html" +ACCESSKEY="H" +>Home</A ></TD ><TD WIDTH="60%" @@ -70,16 +70,7 @@ VALIGN="bottom" ></TD ><TD -WIDTH="10%" -ALIGN="right" -VALIGN="top" -><A -TITLE="Loading R Modules at Startup" -HREF="plr-module-funcs.html" ->Fast Forward</A -></TD -><TD -WIDTH="10%" +WIDTH="20%" ALIGN="right" VALIGN="top" ><A Files old/plr/doc/plr-US.pdf and new/plr/doc/plr-US.pdf differ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/expected/plr.out new/plr/expected/plr.out --- old/plr/expected/plr.out 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/expected/plr.out 2013-02-26 23:19:30.000000000 +0100 @@ -7,7 +7,7 @@ SELECT plr_version(); plr_version ------------- - 08.03.00.13 + 08.03.00.14 (1 row) -- make typenames available in the global namespace diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/pg_backend_support.c new/plr/pg_backend_support.c --- old/plr/pg_backend_support.c 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/pg_backend_support.c 2013-02-26 23:19:30.000000000 +0100 @@ -2,7 +2,7 @@ * PL/R - PostgreSQL support for R as a * procedural language (PL) * - * Copyright (c) 2003-2010 by Joseph E. Conway + * Copyright (c) 2003-2013 by Joseph E. Conway * ALL RIGHTS RESERVED * * Joe Conway <[email protected]> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/pg_conversion.c new/plr/pg_conversion.c --- old/plr/pg_conversion.c 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/pg_conversion.c 2013-02-26 23:19:30.000000000 +0100 @@ -2,7 +2,7 @@ * PL/R - PostgreSQL support for R as a * procedural language (PL) * - * Copyright (c) 2003-2010 by Joseph E. Conway + * Copyright (c) 2003-2013 by Joseph E. Conway * ALL RIGHTS RESERVED * * Joe Conway <[email protected]> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/pg_rsupport.c new/plr/pg_rsupport.c --- old/plr/pg_rsupport.c 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/pg_rsupport.c 2013-02-26 23:19:30.000000000 +0100 @@ -2,7 +2,7 @@ * PL/R - PostgreSQL support for R as a * procedural language (PL) * - * Copyright (c) 2003-2010 by Joseph E. Conway + * Copyright (c) 2003-2013 by Joseph E. Conway * ALL RIGHTS RESERVED * * Joe Conway <[email protected]> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/pg_userfuncs.c new/plr/pg_userfuncs.c --- old/plr/pg_userfuncs.c 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/pg_userfuncs.c 2013-02-26 23:19:30.000000000 +0100 @@ -2,7 +2,7 @@ * PL/R - PostgreSQL support for R as a * procedural language (PL) * - * Copyright (c) 2003-2010 by Joseph E. Conway + * Copyright (c) 2003-2013 by Joseph E. Conway * ALL RIGHTS RESERVED * * Joe Conway <[email protected]> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/plr--8.3.0.13.sql new/plr/plr--8.3.0.13.sql --- old/plr/plr--8.3.0.13.sql 2012-12-28 18:54:56.000000000 +0100 +++ new/plr/plr--8.3.0.13.sql 1970-01-01 01:00:00.000000000 +0100 @@ -1,100 +0,0 @@ --- keep this in sync with the plr.sql.in legacy install file - -CREATE FUNCTION plr_call_handler() -RETURNS LANGUAGE_HANDLER -AS 'MODULE_PATHNAME' LANGUAGE C; - -CREATE LANGUAGE plr HANDLER plr_call_handler; - -CREATE OR REPLACE FUNCTION plr_version () -RETURNS text -AS 'MODULE_PATHNAME','plr_version' -LANGUAGE C; - -CREATE OR REPLACE FUNCTION reload_plr_modules () -RETURNS text -AS 'MODULE_PATHNAME','reload_plr_modules' -LANGUAGE C; - -CREATE OR REPLACE FUNCTION install_rcmd (text) -RETURNS text -AS 'MODULE_PATHNAME','install_rcmd' -LANGUAGE C WITH (isstrict); -REVOKE EXECUTE ON FUNCTION install_rcmd (text) FROM PUBLIC; - -CREATE OR REPLACE FUNCTION plr_singleton_array (float8) -RETURNS float8[] -AS 'MODULE_PATHNAME','plr_array' -LANGUAGE C WITH (isstrict); - -CREATE OR REPLACE FUNCTION plr_array_push (_float8, float8) -RETURNS float8[] -AS 'MODULE_PATHNAME','plr_array_push' -LANGUAGE C WITH (isstrict); - -CREATE OR REPLACE FUNCTION plr_array_accum (_float8, float8) -RETURNS float8[] -AS 'MODULE_PATHNAME','plr_array_accum' -LANGUAGE C; - -CREATE TYPE plr_environ_type AS (name text, value text); -CREATE OR REPLACE FUNCTION plr_environ () -RETURNS SETOF plr_environ_type -AS 'MODULE_PATHNAME','plr_environ' -LANGUAGE C; - -REVOKE EXECUTE ON FUNCTION plr_environ() FROM PUBLIC; - -CREATE TYPE r_typename AS (typename text, typeoid oid); -CREATE OR REPLACE FUNCTION r_typenames() -RETURNS SETOF r_typename AS ' - x <- ls(name = .GlobalEnv, pat = "OID") - y <- vector() - for (i in 1:length(x)) {y[i] <- eval(parse(text = x[i]))} - data.frame(typename = x, typeoid = y) -' language 'plr'; - -CREATE OR REPLACE FUNCTION load_r_typenames() -RETURNS text AS ' - sql <- "select upper(typname::text) || ''OID'' as typename, oid from pg_catalog.pg_type where typtype = ''b'' order by typname" - rs <- pg.spi.exec(sql) - for(i in 1:nrow(rs)) - { - typobj <- rs[i,1] - typval <- rs[i,2] - if (substr(typobj,1,1) == "_") - typobj <- paste("ARRAYOF", substr(typobj,2,nchar(typobj)), sep="") - assign(typobj, typval, .GlobalEnv) - } - return("OK") -' language 'plr'; - -CREATE TYPE r_version_type AS (name text, value text); -CREATE OR REPLACE FUNCTION r_version() -RETURNS setof r_version_type as ' - cbind(names(version),unlist(version)) -' language 'plr'; - -CREATE OR REPLACE FUNCTION plr_set_rhome (text) -RETURNS text -AS 'MODULE_PATHNAME','plr_set_rhome' -LANGUAGE C WITH (isstrict); -REVOKE EXECUTE ON FUNCTION plr_set_rhome (text) FROM PUBLIC; - -CREATE OR REPLACE FUNCTION plr_unset_rhome () -RETURNS text -AS 'MODULE_PATHNAME','plr_unset_rhome' -LANGUAGE C; -REVOKE EXECUTE ON FUNCTION plr_unset_rhome () FROM PUBLIC; - -CREATE OR REPLACE FUNCTION plr_set_display (text) -RETURNS text -AS 'MODULE_PATHNAME','plr_set_display' -LANGUAGE C WITH (isstrict); -REVOKE EXECUTE ON FUNCTION plr_set_display (text) FROM PUBLIC; - -CREATE OR REPLACE FUNCTION plr_get_raw (bytea) -RETURNS bytea -AS 'MODULE_PATHNAME','plr_get_raw' -LANGUAGE C WITH (isstrict); - diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/plr--8.3.0.14.sql new/plr/plr--8.3.0.14.sql --- old/plr/plr--8.3.0.14.sql 1970-01-01 01:00:00.000000000 +0100 +++ new/plr/plr--8.3.0.14.sql 2013-02-26 23:19:30.000000000 +0100 @@ -0,0 +1,100 @@ +-- keep this in sync with the plr.sql.in legacy install file + +CREATE FUNCTION plr_call_handler() +RETURNS LANGUAGE_HANDLER +AS 'MODULE_PATHNAME' LANGUAGE C; + +CREATE LANGUAGE plr HANDLER plr_call_handler; + +CREATE OR REPLACE FUNCTION plr_version () +RETURNS text +AS 'MODULE_PATHNAME','plr_version' +LANGUAGE C; + +CREATE OR REPLACE FUNCTION reload_plr_modules () +RETURNS text +AS 'MODULE_PATHNAME','reload_plr_modules' +LANGUAGE C; + +CREATE OR REPLACE FUNCTION install_rcmd (text) +RETURNS text +AS 'MODULE_PATHNAME','install_rcmd' +LANGUAGE C WITH (isstrict); +REVOKE EXECUTE ON FUNCTION install_rcmd (text) FROM PUBLIC; + +CREATE OR REPLACE FUNCTION plr_singleton_array (float8) +RETURNS float8[] +AS 'MODULE_PATHNAME','plr_array' +LANGUAGE C WITH (isstrict); + +CREATE OR REPLACE FUNCTION plr_array_push (_float8, float8) +RETURNS float8[] +AS 'MODULE_PATHNAME','plr_array_push' +LANGUAGE C WITH (isstrict); + +CREATE OR REPLACE FUNCTION plr_array_accum (_float8, float8) +RETURNS float8[] +AS 'MODULE_PATHNAME','plr_array_accum' +LANGUAGE C; + +CREATE TYPE plr_environ_type AS (name text, value text); +CREATE OR REPLACE FUNCTION plr_environ () +RETURNS SETOF plr_environ_type +AS 'MODULE_PATHNAME','plr_environ' +LANGUAGE C; + +REVOKE EXECUTE ON FUNCTION plr_environ() FROM PUBLIC; + +CREATE TYPE r_typename AS (typename text, typeoid oid); +CREATE OR REPLACE FUNCTION r_typenames() +RETURNS SETOF r_typename AS ' + x <- ls(name = .GlobalEnv, pat = "OID") + y <- vector() + for (i in 1:length(x)) {y[i] <- eval(parse(text = x[i]))} + data.frame(typename = x, typeoid = y) +' language 'plr'; + +CREATE OR REPLACE FUNCTION load_r_typenames() +RETURNS text AS ' + sql <- "select upper(typname::text) || ''OID'' as typename, oid from pg_catalog.pg_type where typtype = ''b'' order by typname" + rs <- pg.spi.exec(sql) + for(i in 1:nrow(rs)) + { + typobj <- rs[i,1] + typval <- rs[i,2] + if (substr(typobj,1,1) == "_") + typobj <- paste("ARRAYOF", substr(typobj,2,nchar(typobj)), sep="") + assign(typobj, typval, .GlobalEnv) + } + return("OK") +' language 'plr'; + +CREATE TYPE r_version_type AS (name text, value text); +CREATE OR REPLACE FUNCTION r_version() +RETURNS setof r_version_type as ' + cbind(names(version),unlist(version)) +' language 'plr'; + +CREATE OR REPLACE FUNCTION plr_set_rhome (text) +RETURNS text +AS 'MODULE_PATHNAME','plr_set_rhome' +LANGUAGE C WITH (isstrict); +REVOKE EXECUTE ON FUNCTION plr_set_rhome (text) FROM PUBLIC; + +CREATE OR REPLACE FUNCTION plr_unset_rhome () +RETURNS text +AS 'MODULE_PATHNAME','plr_unset_rhome' +LANGUAGE C; +REVOKE EXECUTE ON FUNCTION plr_unset_rhome () FROM PUBLIC; + +CREATE OR REPLACE FUNCTION plr_set_display (text) +RETURNS text +AS 'MODULE_PATHNAME','plr_set_display' +LANGUAGE C WITH (isstrict); +REVOKE EXECUTE ON FUNCTION plr_set_display (text) FROM PUBLIC; + +CREATE OR REPLACE FUNCTION plr_get_raw (bytea) +RETURNS bytea +AS 'MODULE_PATHNAME','plr_get_raw' +LANGUAGE C WITH (isstrict); + diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/plr--unpackaged--8.3.0.13.sql new/plr/plr--unpackaged--8.3.0.13.sql --- old/plr/plr--unpackaged--8.3.0.13.sql 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/plr--unpackaged--8.3.0.13.sql 1970-01-01 01:00:00.000000000 +0100 @@ -1,23 +0,0 @@ -/* plr/plr--unpackaged--8.3.0.13.sql */ - -ALTER EXTENSION plr ADD type plr_environ_type; -ALTER EXTENSION plr ADD type r_typename; -ALTER EXTENSION plr ADD type r_version_type; - -ALTER EXTENSION plr ADD function plr_call_handler(); -ALTER EXTENSION plr ADD function plr_version(); -ALTER EXTENSION plr ADD function reload_plr_modules(); -ALTER EXTENSION plr ADD function install_rcmd(text); -ALTER EXTENSION plr ADD function plr_singleton_array (float8); -ALTER EXTENSION plr ADD function plr_array_push (_float8, float8); -ALTER EXTENSION plr ADD function plr_array_accum (_float8, float8); -ALTER EXTENSION plr ADD function plr_environ (); -ALTER EXTENSION plr ADD function r_typenames(); -ALTER EXTENSION plr ADD function load_r_typenames(); -ALTER EXTENSION plr ADD function r_version(); -ALTER EXTENSION plr ADD function plr_set_rhome (text); -ALTER EXTENSION plr ADD function plr_unset_rhome (); -ALTER EXTENSION plr ADD function plr_set_display (text); -ALTER EXTENSION plr ADD function plr_get_raw (bytea); - -ALTER EXTENSION plr ADD LANGUAGE plr; \ No newline at end of file diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/plr--unpackaged--8.3.0.14.sql new/plr/plr--unpackaged--8.3.0.14.sql --- old/plr/plr--unpackaged--8.3.0.14.sql 1970-01-01 01:00:00.000000000 +0100 +++ new/plr/plr--unpackaged--8.3.0.14.sql 2013-02-26 23:19:30.000000000 +0100 @@ -0,0 +1,23 @@ +/* plr/plr--unpackaged--8.3.0.14.sql */ + +ALTER EXTENSION plr ADD type plr_environ_type; +ALTER EXTENSION plr ADD type r_typename; +ALTER EXTENSION plr ADD type r_version_type; + +ALTER EXTENSION plr ADD function plr_call_handler(); +ALTER EXTENSION plr ADD function plr_version(); +ALTER EXTENSION plr ADD function reload_plr_modules(); +ALTER EXTENSION plr ADD function install_rcmd(text); +ALTER EXTENSION plr ADD function plr_singleton_array (float8); +ALTER EXTENSION plr ADD function plr_array_push (_float8, float8); +ALTER EXTENSION plr ADD function plr_array_accum (_float8, float8); +ALTER EXTENSION plr ADD function plr_environ (); +ALTER EXTENSION plr ADD function r_typenames(); +ALTER EXTENSION plr ADD function load_r_typenames(); +ALTER EXTENSION plr ADD function r_version(); +ALTER EXTENSION plr ADD function plr_set_rhome (text); +ALTER EXTENSION plr ADD function plr_unset_rhome (); +ALTER EXTENSION plr ADD function plr_set_display (text); +ALTER EXTENSION plr ADD function plr_get_raw (bytea); + +ALTER EXTENSION plr ADD LANGUAGE plr; \ No newline at end of file diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/plr.c new/plr/plr.c --- old/plr/plr.c 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/plr.c 2013-02-26 23:19:30.000000000 +0100 @@ -2,7 +2,7 @@ * PL/R - PostgreSQL support for R as a * procedural language (PL) * - * Copyright (c) 2003-2010 by Joseph E. Conway + * Copyright (c) 2003-2013 by Joseph E. Conway * ALL RIGHTS RESERVED * * Joe Conway <[email protected]> @@ -31,7 +31,6 @@ * plr.c - Language handler and support functions */ #include "plr.h" -#include "libpq/pqsignal.h" PG_MODULE_MAGIC; @@ -49,6 +48,8 @@ /* namespace OID for the PL/R language handler function */ static Oid plr_nspOid = InvalidOid; +int R_SignalHandlers = 1; /* Exposed in R_interface.h */ + /* * defines */ @@ -369,6 +370,11 @@ atexit(plr_atexit); /* + * Stop R using its own signal handlers + */ + R_SignalHandlers = 0; + + /* * When initialization fails, R currently exits. Check the return * value anyway in case this ever gets fixed */ @@ -392,10 +398,6 @@ R_Interactive = false; #endif - /* - * R seems to try to steal SIGINT in recent releases, so steal it back - */ - pqsignal(SIGINT, StatementCancelHandler); /* cancel current query */ plr_pm_init_done = true; } diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/plr.control new/plr/plr.control --- old/plr/plr.control 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/plr.control 2013-02-26 23:19:30.000000000 +0100 @@ -1,5 +1,5 @@ # plr extension comment = 'load R interpreter and execute R script from within a database' -default_version = '8.3.0.13' +default_version = '8.3.0.14' module_pathname = '$libdir/plr' relocatable = true diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/plr.h new/plr/plr.h --- old/plr/plr.h 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/plr.h 2013-02-26 23:19:30.000000000 +0100 @@ -2,7 +2,7 @@ * PL/R - PostgreSQL support for R as a * procedural language (PL) * - * Copyright (c) 2003-2010 by Joseph E. Conway + * Copyright (c) 2003-2013 by Joseph E. Conway * ALL RIGHTS RESERVED * * Joe Conway <[email protected]> @@ -33,7 +33,7 @@ #ifndef PLR_H #define PLR_H -#define PLR_VERSION "08.03.00.13" +#define PLR_VERSION "08.03.00.14" #include "postgres.h" @@ -103,6 +103,8 @@ #endif #if !defined(WIN32) && !defined(WIN64) #include "Rinterface.h" +#else +extern int R_SignalHandlers; #endif #include "Rinternals.h" #include "Rdefines.h" diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/plr/plr.spec new/plr/plr.spec --- old/plr/plr.spec 2011-08-30 00:42:56.000000000 +0200 +++ new/plr/plr.spec 2013-02-26 23:19:30.000000000 +0100 @@ -1,6 +1,6 @@ Summary: A loadable procedural language that enables you to write PostgreSQL functions and triggers in the R programming language. Name: plr -Version: 8.3.0.11 +Version: 8.3.0.14 Release: 1%{?dist} License: BSD Group: Applications/Databases @@ -46,6 +46,9 @@ %files %defattr(644,root,root,755) -%doc %{_docdir}/pgsql/contrib/README.plr -%{_datadir}/pgsql/contrib/plr.sql -%{_libdir}/pgsql/%{name}.so* +%doc %{_docdir}/README.plr +%{_datadir}/pgsql/extension/plr.sql +%{_datadir}/pgsql/extension/plr.control +%{_datadir}/pgsql/extension/plr--8.3.0.14.sql +%{_datadir}/pgsql/extension/plr--unpackaged--8.3.0.14.sql +%{_libdir}/pgsql/plr.so* -- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
