Skip site navigation (1) Skip section navigation (2)

pgsql: Create extension infrastructure for the core procedurallanguage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Create extension infrastructure for the core procedurallanguage
Date: 2011-03-05 02:52:04
Message-ID: E1PvhbA-0000cb-4T@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Create extension infrastructure for the core procedural languages.

This mostly just involves creating control, install, and
update-from-unpackaged scripts for them.  However, I had to adjust plperl
and plpython to not share the same support functions between variants,
because we can't put the same function into multiple extensions.

catversion bump forced due to new contents of pg_pltemplate, and because
initdb now installs plpgsql as an extension not a bare language.

Add support for regression testing these as extensions not bare
languages.

Fix a couple of other issues that popped up while testing this: my initial
hack at pg_dump binary-upgrade support didn't work right, and we don't want
an extra schema permissions test after all.

Documentation changes still to come, but I'm committing now to see
whether the MSVC build scripts need work (likely they do).

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/63b656b7bf39beb5b6095ab2b5e1e4e9d8c6a965

Modified Files
--------------
src/backend/commands/extension.c                |   13 +++----
src/bin/initdb/initdb.c                         |    2 +-
src/bin/pg_dump/pg_dump.c                       |   44 ++++++++++++++++-------
src/include/catalog/catversion.h                |    2 +-
src/include/catalog/pg_pltemplate.h             |    4 +-
src/pl/plperl/GNUmakefile                       |   23 ++++++++++--
src/pl/plperl/plperl--1.0.sql                   |    9 +++++
src/pl/plperl/plperl--unpackaged--1.0.sql       |    7 ++++
src/pl/plperl/plperl.c                          |   36 ++++++++++++++++++
src/pl/plperl/plperl.control                    |    7 ++++
src/pl/plperl/plperlu--1.0.sql                  |    9 +++++
src/pl/plperl/plperlu--unpackaged--1.0.sql      |    7 ++++
src/pl/plperl/plperlu.control                   |    7 ++++
src/pl/plpgsql/src/Makefile                     |   20 +++++++++--
src/pl/plpgsql/src/plpgsql--1.0.sql             |    9 +++++
src/pl/plpgsql/src/plpgsql--unpackaged--1.0.sql |    7 ++++
src/pl/plpgsql/src/plpgsql.control              |    7 ++++
src/pl/plpython/Makefile                        |   27 ++++++++++++--
src/pl/plpython/expected/plpython_drop.out      |    3 +-
src/pl/plpython/expected/plpython_test.out      |    2 +-
src/pl/plpython/plpython.c                      |   33 +++++++++++++++++
src/pl/plpython/plpython2u--1.0.sql             |    9 +++++
src/pl/plpython/plpython2u--unpackaged--1.0.sql |    7 ++++
src/pl/plpython/plpython2u.control              |    7 ++++
src/pl/plpython/plpython3u--1.0.sql             |    9 +++++
src/pl/plpython/plpython3u--unpackaged--1.0.sql |    7 ++++
src/pl/plpython/plpython3u.control              |    7 ++++
src/pl/plpython/plpythonu--1.0.sql              |    9 +++++
src/pl/plpython/plpythonu--unpackaged--1.0.sql  |    7 ++++
src/pl/plpython/plpythonu.control               |    7 ++++
src/pl/plpython/sql/plpython_drop.sql           |    4 ++-
src/pl/plpython/sql/plpython_test.sql           |    2 +-
src/pl/tcl/Makefile                             |   26 +++++++++++--
src/pl/tcl/pltcl--1.0.sql                       |    9 +++++
src/pl/tcl/pltcl--unpackaged--1.0.sql           |    5 +++
src/pl/tcl/pltcl.control                        |    7 ++++
src/pl/tcl/pltclu--1.0.sql                      |    9 +++++
src/pl/tcl/pltclu--unpackaged--1.0.sql          |    5 +++
src/pl/tcl/pltclu.control                       |    7 ++++
src/test/regress/pg_regress.c                   |   17 +++++++++
src/tools/msvc/vcregress.pl                     |    4 +-
41 files changed, 399 insertions(+), 43 deletions(-)

pgsql-committers by date

Next:From: Tom LaneDate: 2011-03-05 06:08:53
Subject: pgsql: Update documentation to reflect that standard PLs are nowextens
Previous:From: Robert HaasDate: 2011-03-04 22:28:36
Subject: pgsql: Refactor seclabel.c to use the new check_object_ownershipfuncti

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group