shared_ispell \

pg_hint_plan

Copyright (c) 2012-2016, NIPPON TELEGRAPH AND TELEPHONE CORPORATION

All rights reserved.

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

* Redistributions of source code must retain the above copyright notice,

this list of conditions and the following disclaimer.

* Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

* Neither the name of the NIPPON TELEGRAPH AND TELEPHONE CORPORATION

(NTT) nor the names of its contributors may be used to endorse or

promote products derived from this software without specific prior

written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"

AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE

IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE

DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE

FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL

DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR

SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,

OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE

OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

core.c and make_join_rel.c are parts of PostgreSQL Database Management System.

(formerly known as Postgres, then as Postgres95)

Copyright holders of those files are following organizations:

Portions Copyright (c) 1996-2016, PostgreSQL Global Development Group

Portions Copyright (c) 1994, The Regents of the University of California

Permission to use, copy, modify, and distribute this software and its

documentation for any purpose, without fee, and without a written agreement

is hereby granted, provided that the above copyright notice and this

paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR

DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING

LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS

DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE

POSSIBILITY OF SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,

INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY

AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS

ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO

PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

MODULES = pg_hint_plan

HINTPLANVER = 1.1.3

REGRESS = init base_plan pg_hint_plan ut-init ut-A ut-S ut-J ut-L ut-G ut-R ut-fdw ut-fini

REGRESSION_EXPECTED = expected/init.out expected/base_plan.out expected/pg_hint_plan.out expected/ut-A.out expected/ut-S.out expected/ut-J.out expected/ut-L.out expected/ut-G.out

REGRESS_OPTS = --encoding=UTF8

EXTENSION = pg_hint_plan

DATA = pg_hint_plan--1.1.3.sql

EXTRA_CLEAN = sql/ut-fdw.sql expected/ut-fdw.out

ifdef USE_PGXS

PG_CONFIG = pg_config

PGXS := $(shell $(PG_CONFIG) --pgxs)

include $(PGXS)

else

subdir = contrib/pg_hint_plan

top_builddir = ../..

include $(top_builddir)/src/Makefile.global

include $(top_srcdir)/contrib/contrib-global.mk

override CFLAGS += -I$(top_builddir)/src/pl/plpgsql/src

REGRESS = init base_plan pg_hint_plan

STARBALL96 = pg_hint_plan96-$(HINTPLANVER).tar.gz

STARBALLS = $(STARBALL96)

TARSOURCES = Makefile *.c *.h COPYRIGHT* \

pg_hint_plan--*.sql \

pg_hint_plan.control \

doc/* expected/*.out sql/*.sql sql/maskout.sh \

data/data.csv input/*.source output/*.source SPECS/*.spec

installcheck: $(REGRESSION_EXPECTED)

rpms: rpm96

pg_hint_plan.o: core.c make_join_rel.c # pg_stat_statements.c

$(STARBALLS): $(TARSOURCES)

if [ -h $(subst .tar.gz,,$@) ]; then rm $(subst .tar.gz,,$@); fi

if [ -e $(subst .tar.gz,,$@) ]; then \

echo "$(subst .tar.gz,,$@) is not a symlink. Stop."; \

exit 1; \

fi

ln -s . $(subst .tar.gz,,$@)

tar -chzf $@ $(addprefix $(subst .tar.gz,,$@)/, $^)

rm $(subst .tar.gz,,$@)

rpm96: $(STARBALL96)

MAKE_ROOT=`pwd` rpmbuild -bb SPECS/pg_hint_plan96.spec

# SPEC file for pg_store_plans

# Copyright(C) 2016 NIPPON TELEGRAPH AND TELEPHONE CORPORATION

%define _pgdir /usr/pgsql-9.6

%define _bindir %{_pgdir}/bin

%define _libdir %{_pgdir}/lib

%define _datadir %{_pgdir}/share

%if "%(echo ${MAKE_ROOT})" != ""

%define _rpmdir %(echo ${MAKE_ROOT})/RPMS

%define _sourcedir %(echo ${MAKE_ROOT})

## Set general information for pg_store_plans.

Summary: Optimizer hint on PostgreSQL 9.6

Name: pg_hint_plan96

Version: 1.1.3

Release: 1%{?dist}

License: BSD

Group: Applications/Databases

Source0: %{name}-%{version}.tar.gz

#URL: http://example.com/pg_hint_plan/

BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-%(%{__id_u} -n)

Vendor: NIPPON TELEGRAPH AND TELEPHONE CORPORATION

## We use postgresql-devel package

BuildRequires: postgresql96-devel

Requires: postgresql96-libs

## Description for "pg_hint_plan"

pg_hint_plan provides capability to tweak execution plans to be

executed on PostgreSQL.

Note that this package is available for only PostgreSQL 9.6.

## pre work for build pg_hint_plan

PATH=/usr/pgsql-9.6/bin:$PATH

if [ "${MAKE_ROOT}" != "" ]; then

pushd ${MAKE_ROOT}

make clean %{name}-%{version}.tar.gz

popd

if [ ! -d %{_rpmdir} ]; then mkdir -p %{_rpmdir}; fi

%setup -q

## Set variables for build environment

PATH=/usr/pgsql-9.6/bin:$PATH

make USE_PGXS=1 %{?_smp_mflags}

## Set variables for install

rm -rf %{buildroot}

install -d %{buildroot}%{_libdir}

install pg_hint_plan.so %{buildroot}%{_libdir}/pg_hint_plan.so

install -d %{buildroot}%{_datadir}/extension

install -m 644 pg_hint_plan--1.1.3.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.3.sql

install -m 644 pg_hint_plan.control %{buildroot}%{_datadir}/extension/pg_hint_plan.control

rm -rf %{buildroot}

%{_libdir}/pg_hint_plan.so

%{_datadir}/extension/pg_hint_plan--1.1.3.sql

%{_datadir}/extension/pg_hint_plan.control

# History of pg_hint_plan.

* Thu Jul 21 2016 Kyotaro Horiguchi

- Support PostgreSQL 9.6