diff options
| author | jdolecek <jdolecek> | 2005-02-06 12:32:05 +0000 |
|---|---|---|
| committer | jdolecek <jdolecek> | 2005-02-06 12:32:05 +0000 |
| commit | 6444f0682179142827f98b0d812a03c5de94bd54 (patch) | |
| tree | ca025c7eef396d233c2e4340a7c68a2a92ecf72b | |
| parent | 7f0c56087d2b56ae05f634623d4fc8dd952fb5cb (diff) | |
| download | pkgsrc-6444f0682179142827f98b0d812a03c5de94bd54.tar.gz | |
PostgreSQL 8.0.1 packages. A dump/restore using pg_dump is required
for those wishing to migrate data from any previous release.
Major changes relative to 7.4.x:
* Savepoints
* Point-in-Time recovery
* Tablespaces
* Improved buffer management
* ALTER TABLE column management improvements
Full list of changes is available at:
http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0
Also note that PostgreSQL server listens also on localhost (127.0.0.1)
by default now.
30 files changed, 2257 insertions, 0 deletions
diff --git a/databases/postgresql80-client/DESCR b/databases/postgresql80-client/DESCR new file mode 100644 index 00000000000..a485664e6f1 --- /dev/null +++ b/databases/postgresql80-client/DESCR @@ -0,0 +1,9 @@ +PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), +derived from the Berkeley Postgres database management system. While +PostgreSQL retains the powerful object-relational data model, rich data types +and easy extensibility of Postgres, it replaces the PostQuel query language +with an extended subset of SQL. + +PostgreSQL is free and the complete source is available. + +This package contains the database client programs. diff --git a/databases/postgresql80-client/Makefile b/databases/postgresql80-client/Makefile new file mode 100644 index 00000000000..9ef65f164ed --- /dev/null +++ b/databases/postgresql80-client/Makefile @@ -0,0 +1,38 @@ +# $NetBSD: Makefile,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ + +PKGNAME= postgresql80-client-${BASE_VERS} +PKGREVISION= # empty +COMMENT= PostgreSQL database client programs + +.include "../../wip/postgresql80/Makefile.common" + +# XXX work around core dumps with the native libedit +USE_GNU_READLINE= yes + +CONFIGURE_ARGS+= --with-openssl +CONFIGURE_ARGS+= --with-zlib +CONFIGURE_ARGS+= --with-readline +MAKE_ENV+= INSTALLED_LIBPQ=1 + +BUILD_DIRS= ${WRKSRC}/src/bin + +pre-build: + ${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}cd ${WRKSRC}/src/backend && \ + ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} \ + ../../src/include/parser/parse.h ../../src/include/utils/fmgroids.h + +post-install: + ${EGREP} -v "^#" ${FILESDIR}/man.exclude > ${WRKDIR}/man_tar_exclude + ${TAR} -zxm -C ${PG_DIR}/man -X ${WRKDIR}/man_tar_exclude \ + -f ${WRKSRC}/doc/man.tar.gz + +.include "../../mk/bsd.prefs.mk" +.if ${OPSYS} == "FreeBSD" && ${LOWER_OPSYS_VERSUFFIX} == "4" +USE_GNU_READLINE=yes +.endif + +.include "../../wip/postgresql80-lib/buildlink3.mk" +.include "../../devel/readline/buildlink3.mk" +.include "../../devel/zlib/buildlink3.mk" + +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql80-client/PLIST b/databases/postgresql80-client/PLIST new file mode 100644 index 00000000000..cd3afb02600 --- /dev/null +++ b/databases/postgresql80-client/PLIST @@ -0,0 +1,294 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ +bin/clusterdb +bin/createdb +bin/createlang +bin/createuser +bin/dropdb +bin/droplang +bin/dropuser +bin/initdb +bin/ipcclean +bin/pg_config +bin/pg_controldata +bin/pg_ctl +bin/pg_dump +bin/pg_dumpall +bin/pg_resetxlog +bin/pg_restore +bin/psql +bin/vacuumdb +man/man1/clusterdb.1 +man/man1/createdb.1 +man/man1/createlang.1 +man/man1/createuser.1 +man/man1/dropdb.1 +man/man1/droplang.1 +man/man1/dropuser.1 +man/man1/initdb.1 +man/man1/ipcclean.1 +man/man1/pg_config.1 +man/man1/pg_controldata.1 +man/man1/pg_ctl.1 +man/man1/pg_dump.1 +man/man1/pg_dumpall.1 +man/man1/pg_resetxlog.1 +man/man1/pg_restore.1 +man/man1/vacuumdb.1 +man/manl/abort.l +man/manl/alter_aggregate.l +man/manl/alter_conversion.l +man/manl/alter_database.l +man/manl/alter_domain.l +man/manl/alter_function.l +man/manl/alter_group.l +man/manl/alter_index.l +man/manl/alter_language.l +man/manl/alter_operator.l +man/manl/alter_operator_class.l +man/manl/alter_schema.l +man/manl/alter_sequence.l +man/manl/alter_table.l +man/manl/alter_trigger.l +man/manl/alter_type.l +man/manl/alter_user.l +man/manl/analyze.l +man/manl/begin.l +man/manl/checkpoint.l +man/manl/close.l +man/manl/cluster.l +man/manl/comment.l +man/manl/commit.l +man/manl/copy.l +man/manl/create_aggregate.l +man/manl/create_cast.l +man/manl/create_constraint_trigger.l +man/manl/create_conversion.l +man/manl/create_database.l +man/manl/create_domain.l +man/manl/create_function.l +man/manl/create_group.l +man/manl/create_index.l +man/manl/create_language.l +man/manl/create_operator.l +man/manl/create_operator_class.l +man/manl/create_rule.l +man/manl/create_schema.l +man/manl/create_sequence.l +man/manl/create_table.l +man/manl/create_table_as.l +man/manl/create_tablespace.l +man/manl/create_trigger.l +man/manl/create_type.l +man/manl/create_user.l +man/manl/create_view.l +man/manl/deallocate.l +man/manl/declare.l +man/manl/delete.l +man/manl/drop_aggregate.l +man/manl/drop_cast.l +man/manl/drop_conversion.l +man/manl/drop_database.l +man/manl/drop_domain.l +man/manl/drop_function.l +man/manl/drop_group.l +man/manl/drop_index.l +man/manl/drop_language.l +man/manl/drop_operator.l +man/manl/drop_operator_class.l +man/manl/drop_rule.l +man/manl/drop_schema.l +man/manl/drop_sequence.l +man/manl/drop_table.l +man/manl/drop_tablespace.l +man/manl/drop_trigger.l +man/manl/drop_type.l +man/manl/drop_user.l +man/manl/drop_view.l +man/manl/end.l +man/manl/execute.l +man/manl/explain.l +man/manl/fetch.l +man/manl/grant.l +man/manl/insert.l +man/manl/listen.l +man/manl/load.l +man/manl/lock.l +man/manl/move.l +man/manl/notify.l +man/manl/prepare.l +man/manl/reindex.l +man/manl/release_savepoint.l +man/manl/reset.l +man/manl/revoke.l +man/manl/rollback.l +man/manl/rollback_to_savepoint.l +man/manl/savepoint.l +man/manl/select.l +man/manl/select_into.l +man/manl/set.l +man/manl/set_constraints.l +man/manl/set_session_authorization.l +man/manl/set_transaction.l +man/manl/show.l +man/manl/spi_connect.l +man/manl/spi_copytuple.l +man/manl/spi_cursor_close.l +man/manl/spi_cursor_fetch.l +man/manl/spi_cursor_find.l +man/manl/spi_cursor_move.l +man/manl/spi_cursor_open.l +man/manl/spi_exec.l +man/manl/spi_execp.l +man/manl/spi_execute.l +man/manl/spi_execute_plan.l +man/manl/spi_finish.l +man/manl/spi_fname.l +man/manl/spi_fnumber.l +man/manl/spi_freeplan.l +man/manl/spi_freetuple.l +man/manl/spi_freetuptable.l +man/manl/spi_getargcount.l +man/manl/spi_getargtypeid.l +man/manl/spi_getbinval.l +man/manl/spi_getrelname.l +man/manl/spi_gettype.l +man/manl/spi_gettypeid.l +man/manl/spi_getvalue.l +man/manl/spi_is_cursor_plan.l +man/manl/spi_modifytuple.l +man/manl/spi_palloc.l +man/manl/spi_pfree.l +man/manl/spi_pop.l +man/manl/spi_prepare.l +man/manl/spi_push.l +man/manl/spi_repalloc.l +man/manl/spi_returntuple.l +man/manl/spi_saveplan.l +man/manl/start_transaction.l +man/manl/truncate.l +man/manl/unlisten.l +man/manl/update.l +man/manl/vacuum.l +${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/de/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/de/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/es/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/es/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/es/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/es/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/es/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/es/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/es/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/fa/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/fa/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/hu/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/hu/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/hu/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/it/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/it/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/it/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/it/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/it/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/it/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/pl/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/pl/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/pl/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/psql.mo +${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/initdb.mo +${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pg_config.mo +${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pg_controldata.mo +${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pg_ctl.mo +${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pg_dump.mo +${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pg_resetxlog.mo +${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pgscripts.mo +${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/psql.mo +share/postgresql/psqlrc.sample +@comment in postgresql80-lib: @dirrm man/man1 +@comment in postgresql80-lib: @dirrm man +@comment in postgresql80-lib: @dirrm bin +@comment in postgresql80-lib: @dirrm share/postgresql diff --git a/databases/postgresql80-client/files/man.exclude b/databases/postgresql80-client/files/man.exclude new file mode 100644 index 00000000000..e28339c3ffa --- /dev/null +++ b/databases/postgresql80-client/files/man.exclude @@ -0,0 +1,7 @@ +# $NetBSD: man.exclude,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ +# +man1/ecpg.1 +man1/pgtclsh.1 +man1/pgtksh.1 +man1/postgres.1 +man1/postmaster.1 diff --git a/databases/postgresql80-docs/DESCR b/databases/postgresql80-docs/DESCR new file mode 100644 index 00000000000..89dd99e91c2 --- /dev/null +++ b/databases/postgresql80-docs/DESCR @@ -0,0 +1,9 @@ +PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), +derived from the Berkeley Postgres database management system. While +PostgreSQL retains the powerful object-relational data model, rich data types +and easy extensibility of Postgres, it replaces the PostQuel query language +with an extended subset of SQL. + +PostgreSQL is free and the complete source is available. + +This package contains the database documentation. diff --git a/databases/postgresql80-docs/Makefile b/databases/postgresql80-docs/Makefile new file mode 100644 index 00000000000..938354cd5f7 --- /dev/null +++ b/databases/postgresql80-docs/Makefile @@ -0,0 +1,32 @@ +# $NetBSD: Makefile,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ + +PKGNAME= postgresql80-docs-${BASE_VERS} +COMMENT= PostgreSQL database system documentation + +.include "../../wip/postgresql80/Makefile.common" + +NO_BUILD= yes +NO_BUILDLINK= yes +NO_CONFIGURE= yes + +#BUILD_DIRS= ${WRKSRC}/doc +DOCDIR= ${PREFIX}/share/doc/postgresql80 + +# The manpage documentation is installed with the relevant packages. +#pre-build: +# cd ${WRKSRC}/doc && ${RM} -f man.tar.gz + +do-install: + ${INSTALL_DATA_DIR} ${DOCDIR} + ${INSTALL_DATA_DIR} ${DOCDIR}/TODO.detail + cd ${WRKSRC}/doc; for file in \ + FAQ* KNOWN_BUGS MISSING_FEATURES README.* TODO \ + bug.template; \ + do \ + ${INSTALL_DATA} $${file} ${DOCDIR}/$${file}; \ + done + cd ${WRKSRC}/doc/TODO.detail && \ + ${PAX} -rwppm . ${DOCDIR}/TODO.detail + ${TAR} -zxm -C ${DOCDIR} -f ${WRKSRC}/doc/postgres.tar.gz + +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql80-docs/PLIST b/databases/postgresql80-docs/PLIST new file mode 100644 index 00000000000..e73bb73c722 --- /dev/null +++ b/databases/postgresql80-docs/PLIST @@ -0,0 +1,640 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ +share/doc/postgresql80/FAQ +share/doc/postgresql80/FAQ_AIX +share/doc/postgresql80/FAQ_CYGWIN +share/doc/postgresql80/FAQ_DEV +share/doc/postgresql80/FAQ_HPUX +share/doc/postgresql80/FAQ_IRIX +share/doc/postgresql80/FAQ_MINGW +share/doc/postgresql80/FAQ_QNX4 +share/doc/postgresql80/FAQ_SCO +share/doc/postgresql80/FAQ_Solaris +share/doc/postgresql80/FAQ_brazilian +share/doc/postgresql80/FAQ_czech +share/doc/postgresql80/FAQ_farsi +share/doc/postgresql80/FAQ_french +share/doc/postgresql80/FAQ_german +share/doc/postgresql80/FAQ_hungarian +share/doc/postgresql80/FAQ_japanese +share/doc/postgresql80/FAQ_polish +share/doc/postgresql80/FAQ_russian +share/doc/postgresql80/FAQ_turkish +share/doc/postgresql80/KNOWN_BUGS +share/doc/postgresql80/LEGALNOTICE.html +share/doc/postgresql80/MISSING_FEATURES +share/doc/postgresql80/README.mb.big5 +share/doc/postgresql80/README.mb.jp +share/doc/postgresql80/TODO +share/doc/postgresql80/TODO.detail/README +share/doc/postgresql80/TODO.detail/psql +share/doc/postgresql80/TODO.detail/thread +share/doc/postgresql80/TODO.detail/trigger +share/doc/postgresql80/TODO.detail/update +share/doc/postgresql80/TODO.detail/wal +share/doc/postgresql80/admin.html +share/doc/postgresql80/app-clusterdb.html +share/doc/postgresql80/app-createdb.html +share/doc/postgresql80/app-createlang.html +share/doc/postgresql80/app-createuser.html +share/doc/postgresql80/app-dropdb.html +share/doc/postgresql80/app-droplang.html +share/doc/postgresql80/app-dropuser.html +share/doc/postgresql80/app-ecpg.html +share/doc/postgresql80/app-initdb.html +share/doc/postgresql80/app-ipcclean.html +share/doc/postgresql80/app-pg-ctl.html +share/doc/postgresql80/app-pg-dumpall.html +share/doc/postgresql80/app-pgconfig.html +share/doc/postgresql80/app-pgcontroldata.html +share/doc/postgresql80/app-pgdump.html +share/doc/postgresql80/app-pgresetxlog.html +share/doc/postgresql80/app-pgrestore.html +share/doc/postgresql80/app-postgres.html +share/doc/postgresql80/app-postmaster.html +share/doc/postgresql80/app-psql.html +share/doc/postgresql80/app-vacuumdb.html +share/doc/postgresql80/appendixes.html +share/doc/postgresql80/applevel-consistency.html +share/doc/postgresql80/arrays.html +share/doc/postgresql80/auth-methods.html +share/doc/postgresql80/backup-file.html +share/doc/postgresql80/backup-online.html +share/doc/postgresql80/backup.html +share/doc/postgresql80/biblio.html +share/doc/postgresql80/bki-commands.html +share/doc/postgresql80/bki-example.html +share/doc/postgresql80/bki.html +share/doc/postgresql80/bookindex.html +share/doc/postgresql80/bug-reporting.html +share/doc/postgresql80/bug.template +share/doc/postgresql80/catalog-pg-aggregate.html +share/doc/postgresql80/catalog-pg-am.html +share/doc/postgresql80/catalog-pg-amop.html +share/doc/postgresql80/catalog-pg-amproc.html +share/doc/postgresql80/catalog-pg-attrdef.html +share/doc/postgresql80/catalog-pg-attribute.html +share/doc/postgresql80/catalog-pg-cast.html +share/doc/postgresql80/catalog-pg-class.html +share/doc/postgresql80/catalog-pg-constraint.html +share/doc/postgresql80/catalog-pg-conversion.html +share/doc/postgresql80/catalog-pg-database.html +share/doc/postgresql80/catalog-pg-depend.html +share/doc/postgresql80/catalog-pg-description.html +share/doc/postgresql80/catalog-pg-group.html +share/doc/postgresql80/catalog-pg-index.html +share/doc/postgresql80/catalog-pg-inherits.html +share/doc/postgresql80/catalog-pg-language.html +share/doc/postgresql80/catalog-pg-largeobject.html +share/doc/postgresql80/catalog-pg-listener.html +share/doc/postgresql80/catalog-pg-namespace.html +share/doc/postgresql80/catalog-pg-opclass.html +share/doc/postgresql80/catalog-pg-operator.html +share/doc/postgresql80/catalog-pg-proc.html +share/doc/postgresql80/catalog-pg-rewrite.html +share/doc/postgresql80/catalog-pg-shadow.html +share/doc/postgresql80/catalog-pg-statistic.html +share/doc/postgresql80/catalog-pg-tablespace.html +share/doc/postgresql80/catalog-pg-trigger.html +share/doc/postgresql80/catalog-pg-type.html +share/doc/postgresql80/catalogs.html +share/doc/postgresql80/charset.html +share/doc/postgresql80/client-authentication-problems.html +share/doc/postgresql80/client-authentication.html +share/doc/postgresql80/client-interfaces.html +share/doc/postgresql80/connect-estab.html +share/doc/postgresql80/creating-cluster.html +share/doc/postgresql80/cvs-tree.html +share/doc/postgresql80/cvs.html +share/doc/postgresql80/cvsup.html +share/doc/postgresql80/datatype-binary.html +share/doc/postgresql80/datatype-bit.html +share/doc/postgresql80/datatype-boolean.html +share/doc/postgresql80/datatype-character.html +share/doc/postgresql80/datatype-datetime.html +share/doc/postgresql80/datatype-geometric.html +share/doc/postgresql80/datatype-money.html +share/doc/postgresql80/datatype-net-types.html +share/doc/postgresql80/datatype-oid.html +share/doc/postgresql80/datatype-pseudo.html +share/doc/postgresql80/datatype.html +share/doc/postgresql80/datetime-appendix.html +share/doc/postgresql80/datetime-keywords.html +share/doc/postgresql80/datetime-units-history.html +share/doc/postgresql80/ddl-alter.html +share/doc/postgresql80/ddl-constraints.html +share/doc/postgresql80/ddl-default.html +share/doc/postgresql80/ddl-depend.html +share/doc/postgresql80/ddl-inherit.html +share/doc/postgresql80/ddl-others.html +share/doc/postgresql80/ddl-priv.html +share/doc/postgresql80/ddl-schemas.html +share/doc/postgresql80/ddl-system-columns.html +share/doc/postgresql80/ddl.html +share/doc/postgresql80/disk-full.html +share/doc/postgresql80/diskusage.html +share/doc/postgresql80/dml-delete.html +share/doc/postgresql80/dml-update.html +share/doc/postgresql80/dml.html +share/doc/postgresql80/docguide-authoring.html +share/doc/postgresql80/docguide-build.html +share/doc/postgresql80/docguide-style.html +share/doc/postgresql80/docguide-toolsets.html +share/doc/postgresql80/docguide.html +share/doc/postgresql80/ecpg-commands.html +share/doc/postgresql80/ecpg-connect.html +share/doc/postgresql80/ecpg-descriptors.html +share/doc/postgresql80/ecpg-develop.html +share/doc/postgresql80/ecpg-disconnect.html +share/doc/postgresql80/ecpg-dynamic.html +share/doc/postgresql80/ecpg-errors.html +share/doc/postgresql80/ecpg-include.html +share/doc/postgresql80/ecpg-library.html +share/doc/postgresql80/ecpg-process.html +share/doc/postgresql80/ecpg-set-connection.html +share/doc/postgresql80/ecpg-variables.html +share/doc/postgresql80/ecpg.html +share/doc/postgresql80/errcodes-appendix.html +share/doc/postgresql80/error-message-reporting.html +share/doc/postgresql80/error-style-guide.html +share/doc/postgresql80/examples.html +share/doc/postgresql80/executor.html +share/doc/postgresql80/explicit-joins.html +share/doc/postgresql80/explicit-locking.html +share/doc/postgresql80/extend-type-system.html +share/doc/postgresql80/extend.html +share/doc/postgresql80/extensibility.html +share/doc/postgresql80/external-extensions.html +share/doc/postgresql80/external-projects.html +share/doc/postgresql80/features.html +share/doc/postgresql80/functions-admin.html +share/doc/postgresql80/functions-aggregate.html +share/doc/postgresql80/functions-array.html +share/doc/postgresql80/functions-binarystring.html +share/doc/postgresql80/functions-bitstring.html +share/doc/postgresql80/functions-comparison.html +share/doc/postgresql80/functions-comparisons.html +share/doc/postgresql80/functions-conditional.html +share/doc/postgresql80/functions-datetime.html +share/doc/postgresql80/functions-formatting.html +share/doc/postgresql80/functions-geometry.html +share/doc/postgresql80/functions-info.html +share/doc/postgresql80/functions-matching.html +share/doc/postgresql80/functions-math.html +share/doc/postgresql80/functions-net.html +share/doc/postgresql80/functions-sequence.html +share/doc/postgresql80/functions-srf.html +share/doc/postgresql80/functions-string.html +share/doc/postgresql80/functions-subquery.html +share/doc/postgresql80/functions.html +share/doc/postgresql80/geqo-biblio.html +share/doc/postgresql80/geqo-intro2.html +share/doc/postgresql80/geqo-pg-intro.html +share/doc/postgresql80/geqo.html +share/doc/postgresql80/gist.html +share/doc/postgresql80/groups.html +share/doc/postgresql80/history.html +share/doc/postgresql80/implementation.html +share/doc/postgresql80/index.html +share/doc/postgresql80/indexcost.html +share/doc/postgresql80/indexes-examine.html +share/doc/postgresql80/indexes-expressional.html +share/doc/postgresql80/indexes-multicolumn.html +share/doc/postgresql80/indexes-opclass.html +share/doc/postgresql80/indexes-partial.html +share/doc/postgresql80/indexes-types.html +share/doc/postgresql80/indexes-unique.html +share/doc/postgresql80/indexes.html +share/doc/postgresql80/information-schema.html +share/doc/postgresql80/infoschema-applicable-roles.html +share/doc/postgresql80/infoschema-check-constraints.html +share/doc/postgresql80/infoschema-column-domain-usage.html +share/doc/postgresql80/infoschema-column-privileges.html +share/doc/postgresql80/infoschema-column-udt-usage.html +share/doc/postgresql80/infoschema-columns.html +share/doc/postgresql80/infoschema-constraint-column-usage.html +share/doc/postgresql80/infoschema-constraint-table-usage.html +share/doc/postgresql80/infoschema-data-type-privileges.html +share/doc/postgresql80/infoschema-datatypes.html +share/doc/postgresql80/infoschema-domain-constraints.html +share/doc/postgresql80/infoschema-domain-udt-usage.html +share/doc/postgresql80/infoschema-domains.html +share/doc/postgresql80/infoschema-element-types.html +share/doc/postgresql80/infoschema-enabled-roles.html +share/doc/postgresql80/infoschema-information-schema-catalog-name.html +share/doc/postgresql80/infoschema-key-column-usage.html +share/doc/postgresql80/infoschema-parameters.html +share/doc/postgresql80/infoschema-referential-constraints.html +share/doc/postgresql80/infoschema-role-column-grants.html +share/doc/postgresql80/infoschema-role-routine-grants.html +share/doc/postgresql80/infoschema-role-table-grants.html +share/doc/postgresql80/infoschema-role-usage-grants.html +share/doc/postgresql80/infoschema-routine-privileges.html +share/doc/postgresql80/infoschema-routines.html +share/doc/postgresql80/infoschema-schemata.html +share/doc/postgresql80/infoschema-sql-features.html +share/doc/postgresql80/infoschema-sql-implementation-info.html +share/doc/postgresql80/infoschema-sql-languages.html +share/doc/postgresql80/infoschema-sql-packages.html +share/doc/postgresql80/infoschema-sql-sizing-profiles.html +share/doc/postgresql80/infoschema-sql-sizing.html +share/doc/postgresql80/infoschema-table-constraints.html +share/doc/postgresql80/infoschema-table-privileges.html +share/doc/postgresql80/infoschema-tables.html +share/doc/postgresql80/infoschema-triggers.html +share/doc/postgresql80/infoschema-usage-privileges.html +share/doc/postgresql80/infoschema-view-column-usage.html +share/doc/postgresql80/infoschema-view-table-usage.html +share/doc/postgresql80/infoschema-views.html +share/doc/postgresql80/install-getsource.html +share/doc/postgresql80/install-post.html +share/doc/postgresql80/install-procedure.html +share/doc/postgresql80/install-requirements.html +share/doc/postgresql80/install-upgrading.html +share/doc/postgresql80/install-win32.html +share/doc/postgresql80/installation.html +share/doc/postgresql80/internals.html +share/doc/postgresql80/kernel-resources.html +share/doc/postgresql80/largeobjects.html +share/doc/postgresql80/libpq-async.html +share/doc/postgresql80/libpq-build.html +share/doc/postgresql80/libpq-cancel.html +share/doc/postgresql80/libpq-control.html +share/doc/postgresql80/libpq-copy.html +share/doc/postgresql80/libpq-envars.html +share/doc/postgresql80/libpq-example.html +share/doc/postgresql80/libpq-exec.html +share/doc/postgresql80/libpq-fastpath.html +share/doc/postgresql80/libpq-notice-processing.html +share/doc/postgresql80/libpq-notify.html +share/doc/postgresql80/libpq-pgpass.html +share/doc/postgresql80/libpq-ssl.html +share/doc/postgresql80/libpq-status.html +share/doc/postgresql80/libpq-threading.html +share/doc/postgresql80/libpq.html +share/doc/postgresql80/limitations.html +share/doc/postgresql80/lo-examplesect.html +share/doc/postgresql80/lo-funcs.html +share/doc/postgresql80/lo-implementation.html +share/doc/postgresql80/lo-interfaces.html +share/doc/postgresql80/locking-indexes.html +share/doc/postgresql80/logfile-maintenance.html +share/doc/postgresql80/maintenance.html +share/doc/postgresql80/manage-ag-config.html +share/doc/postgresql80/manage-ag-createdb.html +share/doc/postgresql80/manage-ag-dropdb.html +share/doc/postgresql80/manage-ag-tablespaces.html +share/doc/postgresql80/manage-ag-templatedbs.html +share/doc/postgresql80/managing-databases.html +share/doc/postgresql80/migration.html +share/doc/postgresql80/monitoring-locks.html +share/doc/postgresql80/monitoring-stats.html +share/doc/postgresql80/monitoring.html +share/doc/postgresql80/multibyte.html +share/doc/postgresql80/mvcc.html +share/doc/postgresql80/nls-programmer.html +share/doc/postgresql80/nls.html +share/doc/postgresql80/notation.html +share/doc/postgresql80/overview.html +share/doc/postgresql80/parser-stage.html +share/doc/postgresql80/performance-tips.html +share/doc/postgresql80/perm-functions.html +share/doc/postgresql80/planner-optimizer.html +share/doc/postgresql80/planner-stats.html +share/doc/postgresql80/plhandler.html +share/doc/postgresql80/plperl-data.html +share/doc/postgresql80/plperl-database.html +share/doc/postgresql80/plperl-global.html +share/doc/postgresql80/plperl-missing.html +share/doc/postgresql80/plperl-triggers.html +share/doc/postgresql80/plperl-trusted.html +share/doc/postgresql80/plperl.html +share/doc/postgresql80/plpgsql-control-structures.html +share/doc/postgresql80/plpgsql-cursors.html +share/doc/postgresql80/plpgsql-declarations.html +share/doc/postgresql80/plpgsql-development-tips.html +share/doc/postgresql80/plpgsql-errors-and-messages.html +share/doc/postgresql80/plpgsql-expressions.html +share/doc/postgresql80/plpgsql-porting.html +share/doc/postgresql80/plpgsql-statements.html +share/doc/postgresql80/plpgsql-structure.html +share/doc/postgresql80/plpgsql-trigger.html +share/doc/postgresql80/plpgsql.html +share/doc/postgresql80/plpython-database.html +share/doc/postgresql80/plpython-trigger.html +share/doc/postgresql80/plpython.html +share/doc/postgresql80/pltcl-data.html +share/doc/postgresql80/pltcl-dbaccess.html +share/doc/postgresql80/pltcl-functions.html +share/doc/postgresql80/pltcl-global.html +share/doc/postgresql80/pltcl-procnames.html +share/doc/postgresql80/pltcl-trigger.html +share/doc/postgresql80/pltcl-unknown.html +share/doc/postgresql80/pltcl.html +share/doc/postgresql80/populate.html +share/doc/postgresql80/postmaster-shutdown.html +share/doc/postgresql80/postmaster-start.html +share/doc/postgresql80/preface.html +share/doc/postgresql80/privileges.html +share/doc/postgresql80/protocol-changes.html +share/doc/postgresql80/protocol-error-fields.html +share/doc/postgresql80/protocol-flow.html +share/doc/postgresql80/protocol-message-formats.html +share/doc/postgresql80/protocol-message-types.html +share/doc/postgresql80/protocol.html +share/doc/postgresql80/queries-limit.html +share/doc/postgresql80/queries-order.html +share/doc/postgresql80/queries-select-lists.html +share/doc/postgresql80/queries-table-expressions.html +share/doc/postgresql80/queries-union.html +share/doc/postgresql80/queries.html +share/doc/postgresql80/reference-client.html +share/doc/postgresql80/reference-server.html +share/doc/postgresql80/reference.html +share/doc/postgresql80/regress-evaluation.html +share/doc/postgresql80/regress-platform.html +share/doc/postgresql80/regress.html +share/doc/postgresql80/release-0-01.html +share/doc/postgresql80/release-0-02.html +share/doc/postgresql80/release-0-03.html +share/doc/postgresql80/release-1-0.html +share/doc/postgresql80/release-1-01.html +share/doc/postgresql80/release-1-02.html +share/doc/postgresql80/release-1-09.html +share/doc/postgresql80/release-6-0.html +share/doc/postgresql80/release-6-1-1.html +share/doc/postgresql80/release-6-1.html +share/doc/postgresql80/release-6-2-1.html +share/doc/postgresql80/release-6-2.html +share/doc/postgresql80/release-6-3-1.html +share/doc/postgresql80/release-6-3-2.html +share/doc/postgresql80/release-6-3.html +share/doc/postgresql80/release-6-4-1.html +share/doc/postgresql80/release-6-4-2.html +share/doc/postgresql80/release-6-4.html +share/doc/postgresql80/release-6-5-1.html +share/doc/postgresql80/release-6-5-2.html +share/doc/postgresql80/release-6-5-3.html +share/doc/postgresql80/release-6-5.html +share/doc/postgresql80/release-7-0-1.html +share/doc/postgresql80/release-7-0-2.html +share/doc/postgresql80/release-7-0-3.html +share/doc/postgresql80/release-7-0.html +share/doc/postgresql80/release-7-1-1.html +share/doc/postgresql80/release-7-1-2.html +share/doc/postgresql80/release-7-1-3.html +share/doc/postgresql80/release-7-1.html +share/doc/postgresql80/release-7-2-1.html +share/doc/postgresql80/release-7-2-2.html +share/doc/postgresql80/release-7-2-3.html +share/doc/postgresql80/release-7-2-4.html +share/doc/postgresql80/release-7-2-5.html +share/doc/postgresql80/release-7-2-6.html +share/doc/postgresql80/release-7-2-7.html +share/doc/postgresql80/release-7-2.html +share/doc/postgresql80/release-7-3-1.html +share/doc/postgresql80/release-7-3-2.html +share/doc/postgresql80/release-7-3-3.html +share/doc/postgresql80/release-7-3-4.html +share/doc/postgresql80/release-7-3-5.html +share/doc/postgresql80/release-7-3-6.html +share/doc/postgresql80/release-7-3-7.html +share/doc/postgresql80/release-7-3-8.html +share/doc/postgresql80/release-7-3-9.html +share/doc/postgresql80/release-7-3.html +share/doc/postgresql80/release-7-4-1.html +share/doc/postgresql80/release-7-4-2.html +share/doc/postgresql80/release-7-4-3.html +share/doc/postgresql80/release-7-4-4.html +share/doc/postgresql80/release-7-4-5.html +share/doc/postgresql80/release-7-4-6.html +share/doc/postgresql80/release-7-4-7.html +share/doc/postgresql80/release-7-4.html +share/doc/postgresql80/release-8-0.html +share/doc/postgresql80/release.html +share/doc/postgresql80/resources.html +share/doc/postgresql80/routine-reindex.html +share/doc/postgresql80/rowtypes.html +share/doc/postgresql80/rule-system.html +share/doc/postgresql80/rules-privileges.html +share/doc/postgresql80/rules-status.html +share/doc/postgresql80/rules-triggers.html +share/doc/postgresql80/rules-update.html +share/doc/postgresql80/rules-views.html +share/doc/postgresql80/rules.html +share/doc/postgresql80/runtime-config.html +share/doc/postgresql80/runtime.html +share/doc/postgresql80/server-programming.html +share/doc/postgresql80/source.html +share/doc/postgresql80/spi-examples.html +share/doc/postgresql80/spi-interface-support.html +share/doc/postgresql80/spi-memory.html +share/doc/postgresql80/spi-realloc.html +share/doc/postgresql80/spi-spi-connect.html +share/doc/postgresql80/spi-spi-copytuple.html +share/doc/postgresql80/spi-spi-cursor-close.html +share/doc/postgresql80/spi-spi-cursor-fetch.html +share/doc/postgresql80/spi-spi-cursor-find.html +share/doc/postgresql80/spi-spi-cursor-move.html +share/doc/postgresql80/spi-spi-cursor-open.html +share/doc/postgresql80/spi-spi-exec.html +share/doc/postgresql80/spi-spi-execp.html +share/doc/postgresql80/spi-spi-execute-plan.html +share/doc/postgresql80/spi-spi-execute.html +share/doc/postgresql80/spi-spi-finish.html +share/doc/postgresql80/spi-spi-fname.html +share/doc/postgresql80/spi-spi-fnumber.html +share/doc/postgresql80/spi-spi-freeplan.html +share/doc/postgresql80/spi-spi-freetuple.html +share/doc/postgresql80/spi-spi-freetupletable.html +share/doc/postgresql80/spi-spi-getargcount.html +share/doc/postgresql80/spi-spi-getargtypeid.html +share/doc/postgresql80/spi-spi-getbinval.html +share/doc/postgresql80/spi-spi-getrelname.html +share/doc/postgresql80/spi-spi-gettype.html +share/doc/postgresql80/spi-spi-gettypeid.html +share/doc/postgresql80/spi-spi-getvalue.html +share/doc/postgresql80/spi-spi-is-cursor-plan.html +share/doc/postgresql80/spi-spi-modifytuple.html +share/doc/postgresql80/spi-spi-palloc.html +share/doc/postgresql80/spi-spi-pfree.html +share/doc/postgresql80/spi-spi-pop.html +share/doc/postgresql80/spi-spi-prepare.html +share/doc/postgresql80/spi-spi-push.html +share/doc/postgresql80/spi-spi-returntuple.html +share/doc/postgresql80/spi-spi-saveplan.html +share/doc/postgresql80/spi-visibility.html +share/doc/postgresql80/spi.html +share/doc/postgresql80/sql-abort.html +share/doc/postgresql80/sql-alteraggregate.html +share/doc/postgresql80/sql-alterconversion.html +share/doc/postgresql80/sql-alterdatabase.html +share/doc/postgresql80/sql-alterdomain.html +share/doc/postgresql80/sql-alterfunction.html +share/doc/postgresql80/sql-altergroup.html +share/doc/postgresql80/sql-alterindex.html +share/doc/postgresql80/sql-alterlanguage.html +share/doc/postgresql80/sql-alteropclass.html +share/doc/postgresql80/sql-alteroperator.html +share/doc/postgresql80/sql-alterschema.html +share/doc/postgresql80/sql-altersequence.html +share/doc/postgresql80/sql-altertable.html +share/doc/postgresql80/sql-altertablespace.html +share/doc/postgresql80/sql-altertrigger.html +share/doc/postgresql80/sql-altertype.html +share/doc/postgresql80/sql-alteruser.html +share/doc/postgresql80/sql-analyze.html +share/doc/postgresql80/sql-begin.html +share/doc/postgresql80/sql-checkpoint.html +share/doc/postgresql80/sql-close.html +share/doc/postgresql80/sql-cluster.html +share/doc/postgresql80/sql-commands.html +share/doc/postgresql80/sql-comment.html +share/doc/postgresql80/sql-commit.html +share/doc/postgresql80/sql-copy.html +share/doc/postgresql80/sql-createaggregate.html +share/doc/postgresql80/sql-createcast.html +share/doc/postgresql80/sql-createconstraint.html +share/doc/postgresql80/sql-createconversion.html +share/doc/postgresql80/sql-createdatabase.html +share/doc/postgresql80/sql-createdomain.html +share/doc/postgresql80/sql-createfunction.html +share/doc/postgresql80/sql-creategroup.html +share/doc/postgresql80/sql-createindex.html +share/doc/postgresql80/sql-createlanguage.html +share/doc/postgresql80/sql-createopclass.html +share/doc/postgresql80/sql-createoperator.html +share/doc/postgresql80/sql-createrule.html +share/doc/postgresql80/sql-createschema.html +share/doc/postgresql80/sql-createsequence.html +share/doc/postgresql80/sql-createtable.html +share/doc/postgresql80/sql-createtableas.html +share/doc/postgresql80/sql-createtablespace.html +share/doc/postgresql80/sql-createtrigger.html +share/doc/postgresql80/sql-createtype.html +share/doc/postgresql80/sql-createuser.html +share/doc/postgresql80/sql-createview.html +share/doc/postgresql80/sql-deallocate.html +share/doc/postgresql80/sql-declare.html +share/doc/postgresql80/sql-delete.html +share/doc/postgresql80/sql-dropaggregate.html +share/doc/postgresql80/sql-dropcast.html +share/doc/postgresql80/sql-dropconversion.html +share/doc/postgresql80/sql-dropdatabase.html +share/doc/postgresql80/sql-dropdomain.html +share/doc/postgresql80/sql-dropfunction.html +share/doc/postgresql80/sql-dropgroup.html +share/doc/postgresql80/sql-dropindex.html +share/doc/postgresql80/sql-droplanguage.html +share/doc/postgresql80/sql-dropopclass.html +share/doc/postgresql80/sql-dropoperator.html +share/doc/postgresql80/sql-droprule.html +share/doc/postgresql80/sql-dropschema.html +share/doc/postgresql80/sql-dropsequence.html +share/doc/postgresql80/sql-droptable.html +share/doc/postgresql80/sql-droptablespace.html +share/doc/postgresql80/sql-droptrigger.html +share/doc/postgresql80/sql-droptype.html +share/doc/postgresql80/sql-dropuser.html +share/doc/postgresql80/sql-dropview.html +share/doc/postgresql80/sql-end.html +share/doc/postgresql80/sql-execute.html +share/doc/postgresql80/sql-explain.html +share/doc/postgresql80/sql-expressions.html +share/doc/postgresql80/sql-fetch.html +share/doc/postgresql80/sql-grant.html +share/doc/postgresql80/sql-insert.html +share/doc/postgresql80/sql-keywords-appendix.html +share/doc/postgresql80/sql-listen.html +share/doc/postgresql80/sql-load.html +share/doc/postgresql80/sql-lock.html +share/doc/postgresql80/sql-move.html +share/doc/postgresql80/sql-notify.html +share/doc/postgresql80/sql-prepare.html +share/doc/postgresql80/sql-reindex.html +share/doc/postgresql80/sql-release-savepoint.html +share/doc/postgresql80/sql-reset.html +share/doc/postgresql80/sql-revoke.html +share/doc/postgresql80/sql-rollback-to.html +share/doc/postgresql80/sql-rollback.html +share/doc/postgresql80/sql-savepoint.html +share/doc/postgresql80/sql-select.html +share/doc/postgresql80/sql-selectinto.html +share/doc/postgresql80/sql-set-constraints.html +share/doc/postgresql80/sql-set-session-authorization.html +share/doc/postgresql80/sql-set-transaction.html +share/doc/postgresql80/sql-set.html +share/doc/postgresql80/sql-show.html +share/doc/postgresql80/sql-start-transaction.html +share/doc/postgresql80/sql-syntax.html +share/doc/postgresql80/sql-truncate.html +share/doc/postgresql80/sql-unlisten.html +share/doc/postgresql80/sql-update.html +share/doc/postgresql80/sql-vacuum.html +share/doc/postgresql80/sql.html +share/doc/postgresql80/ssh-tunnels.html +share/doc/postgresql80/ssl-tcp.html +share/doc/postgresql80/storage-page-layout.html +share/doc/postgresql80/storage-toast.html +share/doc/postgresql80/storage.html +share/doc/postgresql80/stylesheet.css +share/doc/postgresql80/supported-platforms.html +share/doc/postgresql80/transaction-iso.html +share/doc/postgresql80/trigger-datachanges.html +share/doc/postgresql80/trigger-example.html +share/doc/postgresql80/trigger-interface.html +share/doc/postgresql80/triggers.html +share/doc/postgresql80/tutorial-accessdb.html +share/doc/postgresql80/tutorial-advanced.html +share/doc/postgresql80/tutorial-agg.html +share/doc/postgresql80/tutorial-arch.html +share/doc/postgresql80/tutorial-concepts.html +share/doc/postgresql80/tutorial-conclusion.html +share/doc/postgresql80/tutorial-createdb.html +share/doc/postgresql80/tutorial-delete.html +share/doc/postgresql80/tutorial-fk.html +share/doc/postgresql80/tutorial-inheritance.html +share/doc/postgresql80/tutorial-join.html +share/doc/postgresql80/tutorial-populate.html +share/doc/postgresql80/tutorial-select.html +share/doc/postgresql80/tutorial-sql.html +share/doc/postgresql80/tutorial-start.html +share/doc/postgresql80/tutorial-table.html +share/doc/postgresql80/tutorial-transactions.html +share/doc/postgresql80/tutorial-update.html +share/doc/postgresql80/tutorial-views.html +share/doc/postgresql80/tutorial.html +share/doc/postgresql80/typeconv-func.html +share/doc/postgresql80/typeconv-oper.html +share/doc/postgresql80/typeconv-query.html +share/doc/postgresql80/typeconv-union-case.html +share/doc/postgresql80/typeconv.html +share/doc/postgresql80/unsupported-features-sql-standard.html +share/doc/postgresql80/user-attributes.html +share/doc/postgresql80/user-manag.html +share/doc/postgresql80/view-pg-indexes.html +share/doc/postgresql80/view-pg-locks.html +share/doc/postgresql80/view-pg-rules.html +share/doc/postgresql80/view-pg-settings.html +share/doc/postgresql80/view-pg-stats.html +share/doc/postgresql80/view-pg-tables.html +share/doc/postgresql80/view-pg-user.html +share/doc/postgresql80/view-pg-views.html +share/doc/postgresql80/views-overview.html +share/doc/postgresql80/wal-configuration.html +share/doc/postgresql80/wal-internals.html +share/doc/postgresql80/wal.html +share/doc/postgresql80/xaggr.html +share/doc/postgresql80/xfunc-c.html +share/doc/postgresql80/xfunc-internal.html +share/doc/postgresql80/xfunc-overload.html +share/doc/postgresql80/xfunc-pl.html +share/doc/postgresql80/xfunc-sql.html +share/doc/postgresql80/xfunc-volatility.html +share/doc/postgresql80/xfunc.html +share/doc/postgresql80/xindex.html +share/doc/postgresql80/xoper-optimization.html +share/doc/postgresql80/xoper.html +share/doc/postgresql80/xplang.html +share/doc/postgresql80/xtypes.html +@dirrm share/doc/postgresql80/TODO.detail +@dirrm share/doc/postgresql80 diff --git a/databases/postgresql80-lib/DESCR b/databases/postgresql80-lib/DESCR new file mode 100644 index 00000000000..8e9d35b4af6 --- /dev/null +++ b/databases/postgresql80-lib/DESCR @@ -0,0 +1,9 @@ +PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), +derived from the Berkeley Postgres database management system. While +PostgreSQL retains the powerful object-relational data model, rich data types +and easy extensibility of Postgres, it replaces the PostQuel query language +with an extended subset of SQL. + +PostgreSQL is free and the complete source is available. + +This package contains the database headers and libraries. diff --git a/databases/postgresql80-lib/Makefile b/databases/postgresql80-lib/Makefile new file mode 100644 index 00000000000..5c9c245edc9 --- /dev/null +++ b/databases/postgresql80-lib/Makefile @@ -0,0 +1,61 @@ +# $NetBSD: Makefile,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ + +PKGNAME= postgresql80-lib-${BASE_VERS} +PKGREVISION= # empty +COMMENT= PostgreSQL database headers and libraries + +.include "../../wip/postgresql80/Makefile.common" + +CONFIGURE_ARGS+= --with-openssl + +.include "../../mk/bsd.prefs.mk" + +BUILD_DIRS+= ${WRKSRC}/src/include +BUILD_DIRS+= ${WRKSRC}/src/interfaces + +# without this the Darwin build fails +# (-bundle_loader related) +BUILD_DIRS+= ${WRKSRC}/src/backend + +BUILD_DIRS+= ${WRKSRC}/src/pl + +# As told by Josh Berkus +.include "../../mk/pthread.buildlink3.mk" +.if defined(PTHREAD_TYPE) && ${PTHREAD_TYPE} == "native" \ + && ${OPSYS} != "NetBSD" +CONFIGURE_ARGS+= --enable-thread-safety +.endif + +# handle additional headers installed by hierarchical queries patch +.if defined(PGSQL_USE_HIER) && !empty(PGSQL_USE_HIER:M[yY][eE][sS]) +PLIST_SUBST+= PG_HIER= +.else +PLIST_SUBST+= PG_HIER="@comment " +.endif + +post-buildlink: +# +# Avoid conflict between "${LOCALBASE}/include/openssl/des.h" and +# "/usr/include/crypt.h" -- we want the definitions in the former. +# +.if (${OPSYS} == "SunOS") + ${TOUCH} ${BUILDLINK_DIR}/include/crypt.h +.endif +do-install: + cd ${WRKSRC} && ${SETENV} ${MAKE_ENV} \ + ${MAKE_PROGRAM} -C src/include install + cd ${WRKSRC} && ${SETENV} ${MAKE_ENV} \ + ${MAKE_PROGRAM} -C src/interfaces install + cd ${WRKSRC} && ${SETENV} ${MAKE_ENV} \ + ${MAKE_PROGRAM} -C src/pl install +# cd ${WRKSRC}/src/include && ${SETENV} ${MAKE_ENV} \ +# ${MAKE_PROGRAM} install-all-headers + +post-install: + ${INSTALL_MAN_DIR} ${PG_DIR}/man + ${EGREP} -v "^#" ${FILESDIR}/man.lib > ${WRKDIR}/man_tar + cd ${PG_DIR}/man && ${TAR} -zxm -T ${WRKDIR}/man_tar \ + -f ${WRKSRC}/doc/man.tar.gz + +.include "../../security/openssl/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql80-lib/PLIST b/databases/postgresql80-lib/PLIST new file mode 100644 index 00000000000..1bf6ce5cbb8 --- /dev/null +++ b/databases/postgresql80-lib/PLIST @@ -0,0 +1,438 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ +bin/ecpg +include/ecpg_informix.h +include/ecpgerrno.h +include/ecpglib.h +include/ecpgtype.h +include/libpq-fe.h +include/libpq/libpq-fs.h +include/pg_config.h +include/pg_config_manual.h +include/pg_config_os.h +include/pgtypes_date.h +include/pgtypes_error.h +include/pgtypes_interval.h +include/pgtypes_numeric.h +include/pgtypes_timestamp.h +include/postgres_ext.h +include/postgresql/informix/esql/datetime.h +include/postgresql/informix/esql/decimal.h +include/postgresql/informix/esql/sqlda.h +include/postgresql/informix/esql/sqltypes.h +include/postgresql/internal/c.h +include/postgresql/internal/libpq-int.h +include/postgresql/internal/libpq/pqcomm.h +include/postgresql/internal/port.h +include/postgresql/internal/postgres_fe.h +include/postgresql/internal/pqexpbuffer.h +include/postgresql/server/access/attnum.h +include/postgresql/server/access/clog.h +include/postgresql/server/access/genam.h +include/postgresql/server/access/gist.h +include/postgresql/server/access/gistscan.h +include/postgresql/server/access/hash.h +include/postgresql/server/access/heapam.h +include/postgresql/server/access/hio.h +include/postgresql/server/access/htup.h +include/postgresql/server/access/ibit.h +include/postgresql/server/access/iqual.h +include/postgresql/server/access/itup.h +include/postgresql/server/access/nbtree.h +include/postgresql/server/access/printtup.h +include/postgresql/server/access/relscan.h +include/postgresql/server/access/rmgr.h +include/postgresql/server/access/rtree.h +include/postgresql/server/access/rtscan.h +include/postgresql/server/access/sdir.h +include/postgresql/server/access/skey.h +include/postgresql/server/access/slru.h +include/postgresql/server/access/subtrans.h +include/postgresql/server/access/transam.h +include/postgresql/server/access/tupdesc.h +include/postgresql/server/access/tupmacs.h +include/postgresql/server/access/tuptoaster.h +include/postgresql/server/access/valid.h +include/postgresql/server/access/xact.h +include/postgresql/server/access/xlog.h +include/postgresql/server/access/xlog_internal.h +include/postgresql/server/access/xlogdefs.h +include/postgresql/server/access/xlogutils.h +include/postgresql/server/bootstrap/bootstrap.h +include/postgresql/server/c.h +include/postgresql/server/catalog/catalog.h +include/postgresql/server/catalog/catname.h +include/postgresql/server/catalog/catversion.h +include/postgresql/server/catalog/dependency.h +include/postgresql/server/catalog/heap.h +include/postgresql/server/catalog/index.h +include/postgresql/server/catalog/indexing.h +include/postgresql/server/catalog/namespace.h +include/postgresql/server/catalog/pg_aggregate.h +include/postgresql/server/catalog/pg_am.h +include/postgresql/server/catalog/pg_amop.h +include/postgresql/server/catalog/pg_amproc.h +include/postgresql/server/catalog/pg_attrdef.h +include/postgresql/server/catalog/pg_attribute.h +include/postgresql/server/catalog/pg_cast.h +include/postgresql/server/catalog/pg_class.h +include/postgresql/server/catalog/pg_constraint.h +include/postgresql/server/catalog/pg_control.h +include/postgresql/server/catalog/pg_conversion.h +include/postgresql/server/catalog/pg_database.h +include/postgresql/server/catalog/pg_depend.h +include/postgresql/server/catalog/pg_description.h +include/postgresql/server/catalog/pg_group.h +include/postgresql/server/catalog/pg_index.h +include/postgresql/server/catalog/pg_inherits.h +include/postgresql/server/catalog/pg_language.h +include/postgresql/server/catalog/pg_largeobject.h +include/postgresql/server/catalog/pg_listener.h +include/postgresql/server/catalog/pg_namespace.h +include/postgresql/server/catalog/pg_opclass.h +include/postgresql/server/catalog/pg_operator.h +include/postgresql/server/catalog/pg_proc.h +include/postgresql/server/catalog/pg_rewrite.h +include/postgresql/server/catalog/pg_shadow.h +include/postgresql/server/catalog/pg_statistic.h +include/postgresql/server/catalog/pg_tablespace.h +include/postgresql/server/catalog/pg_trigger.h +include/postgresql/server/catalog/pg_type.h +include/postgresql/server/catalog/pg_version.h +include/postgresql/server/commands/alter.h +include/postgresql/server/commands/async.h +include/postgresql/server/commands/cluster.h +include/postgresql/server/commands/comment.h +include/postgresql/server/commands/conversioncmds.h +include/postgresql/server/commands/copy.h +include/postgresql/server/commands/dbcommands.h +include/postgresql/server/commands/defrem.h +include/postgresql/server/commands/explain.h +include/postgresql/server/commands/lockcmds.h +include/postgresql/server/commands/portalcmds.h +include/postgresql/server/commands/prepare.h +include/postgresql/server/commands/proclang.h +include/postgresql/server/commands/schemacmds.h +include/postgresql/server/commands/sequence.h +include/postgresql/server/commands/tablecmds.h +include/postgresql/server/commands/tablespace.h +include/postgresql/server/commands/trigger.h +include/postgresql/server/commands/typecmds.h +include/postgresql/server/commands/user.h +include/postgresql/server/commands/vacuum.h +include/postgresql/server/commands/variable.h +include/postgresql/server/commands/version.h +include/postgresql/server/commands/view.h +include/postgresql/server/dynloader.h +include/postgresql/server/executor/execdebug.h +include/postgresql/server/executor/execdefs.h +include/postgresql/server/executor/execdesc.h +include/postgresql/server/executor/executor.h +include/postgresql/server/executor/functions.h +include/postgresql/server/executor/hashjoin.h +include/postgresql/server/executor/instrument.h +include/postgresql/server/executor/nodeAgg.h +include/postgresql/server/executor/nodeAppend.h +include/postgresql/server/executor/nodeFunctionscan.h +include/postgresql/server/executor/nodeGroup.h +include/postgresql/server/executor/nodeHash.h +include/postgresql/server/executor/nodeHashjoin.h +include/postgresql/server/executor/nodeIndexscan.h +include/postgresql/server/executor/nodeLimit.h +include/postgresql/server/executor/nodeMaterial.h +include/postgresql/server/executor/nodeMergejoin.h +include/postgresql/server/executor/nodeNestloop.h +include/postgresql/server/executor/nodeResult.h +include/postgresql/server/executor/nodeSeqscan.h +include/postgresql/server/executor/nodeSetOp.h +include/postgresql/server/executor/nodeSort.h +include/postgresql/server/executor/nodeSubplan.h +include/postgresql/server/executor/nodeSubqueryscan.h +include/postgresql/server/executor/nodeTidscan.h +include/postgresql/server/executor/nodeUnique.h +include/postgresql/server/executor/spi.h +include/postgresql/server/executor/spi_priv.h +include/postgresql/server/executor/tstoreReceiver.h +include/postgresql/server/executor/tuptable.h +include/postgresql/server/fmgr.h +include/postgresql/server/funcapi.h +include/postgresql/server/getaddrinfo.h +include/postgresql/server/getopt_long.h +include/postgresql/server/lib/dllist.h +include/postgresql/server/lib/stringinfo.h +include/postgresql/server/libpq/auth.h +include/postgresql/server/libpq/be-fsstubs.h +include/postgresql/server/libpq/crypt.h +include/postgresql/server/libpq/hba.h +include/postgresql/server/libpq/ip.h +include/postgresql/server/libpq/libpq-be.h +include/postgresql/server/libpq/libpq-fs.h +include/postgresql/server/libpq/libpq.h +include/postgresql/server/libpq/pqcomm.h +include/postgresql/server/libpq/pqformat.h +include/postgresql/server/libpq/pqsignal.h +include/postgresql/server/mb/pg_wchar.h +include/postgresql/server/miscadmin.h +include/postgresql/server/nodes/bitmapset.h +include/postgresql/server/nodes/execnodes.h +include/postgresql/server/nodes/makefuncs.h +include/postgresql/server/nodes/memnodes.h +include/postgresql/server/nodes/nodeFuncs.h +include/postgresql/server/nodes/nodes.h +include/postgresql/server/nodes/params.h +include/postgresql/server/nodes/parsenodes.h +include/postgresql/server/nodes/pg_list.h +include/postgresql/server/nodes/plannodes.h +include/postgresql/server/nodes/primnodes.h +include/postgresql/server/nodes/print.h +include/postgresql/server/nodes/readfuncs.h +include/postgresql/server/nodes/relation.h +include/postgresql/server/nodes/value.h +include/postgresql/server/optimizer/clauses.h +include/postgresql/server/optimizer/cost.h +include/postgresql/server/optimizer/geqo.h +include/postgresql/server/optimizer/geqo_copy.h +include/postgresql/server/optimizer/geqo_gene.h +include/postgresql/server/optimizer/geqo_misc.h +include/postgresql/server/optimizer/geqo_mutation.h +include/postgresql/server/optimizer/geqo_pool.h +include/postgresql/server/optimizer/geqo_random.h +include/postgresql/server/optimizer/geqo_recombination.h +include/postgresql/server/optimizer/geqo_selection.h +include/postgresql/server/optimizer/joininfo.h +include/postgresql/server/optimizer/pathnode.h +include/postgresql/server/optimizer/paths.h +include/postgresql/server/optimizer/plancat.h +include/postgresql/server/optimizer/planmain.h +include/postgresql/server/optimizer/planner.h +include/postgresql/server/optimizer/prep.h +include/postgresql/server/optimizer/restrictinfo.h +include/postgresql/server/optimizer/subselect.h +include/postgresql/server/optimizer/tlist.h +include/postgresql/server/optimizer/var.h +include/postgresql/server/parser/analyze.h +include/postgresql/server/parser/gramparse.h +include/postgresql/server/parser/keywords.h +include/postgresql/server/parser/parse.h +include/postgresql/server/parser/parse_agg.h +include/postgresql/server/parser/parse_clause.h +include/postgresql/server/parser/parse_coerce.h +include/postgresql/server/parser/parse_expr.h +include/postgresql/server/parser/parse_func.h +include/postgresql/server/parser/parse_node.h +include/postgresql/server/parser/parse_oper.h +include/postgresql/server/parser/parse_relation.h +include/postgresql/server/parser/parse_target.h +include/postgresql/server/parser/parse_type.h +include/postgresql/server/parser/parser.h +include/postgresql/server/parser/parsetree.h +include/postgresql/server/parser/scansup.h +include/postgresql/server/pg_config.h +include/postgresql/server/pg_config_manual.h +include/postgresql/server/pg_config_os.h +include/postgresql/server/pgstat.h +include/postgresql/server/pgtime.h +include/postgresql/server/port.h +include/postgresql/server/port/aix.h +include/postgresql/server/port/beos.h +include/postgresql/server/port/bsdi.h +include/postgresql/server/port/cygwin.h +include/postgresql/server/port/darwin.h +include/postgresql/server/port/dgux.h +include/postgresql/server/port/freebsd.h +include/postgresql/server/port/hpux.h +include/postgresql/server/port/irix.h +include/postgresql/server/port/linux.h +include/postgresql/server/port/netbsd.h +include/postgresql/server/port/nextstep.h +include/postgresql/server/port/openbsd.h +include/postgresql/server/port/osf.h +include/postgresql/server/port/qnx4.h +include/postgresql/server/port/sco.h +include/postgresql/server/port/solaris.h +include/postgresql/server/port/sunos4.h +include/postgresql/server/port/svr4.h +include/postgresql/server/port/ultrix4.h +include/postgresql/server/port/univel.h +include/postgresql/server/port/unixware.h +include/postgresql/server/port/win32.h +include/postgresql/server/port/win32/arpa/inet.h +include/postgresql/server/port/win32/dlfcn.h +include/postgresql/server/port/win32/grp.h +include/postgresql/server/port/win32/netdb.h +include/postgresql/server/port/win32/netinet/in.h +include/postgresql/server/port/win32/pwd.h +include/postgresql/server/port/win32/sys/socket.h +include/postgresql/server/port/win32/sys/wait.h +include/postgresql/server/postgres.h +include/postgresql/server/postgres_ext.h +include/postgresql/server/postgres_fe.h +include/postgresql/server/regex/regcustom.h +include/postgresql/server/regex/regerrs.h +include/postgresql/server/regex/regex.h +include/postgresql/server/regex/regguts.h +include/postgresql/server/rewrite/prs2lock.h +include/postgresql/server/rewrite/rewriteDefine.h +include/postgresql/server/rewrite/rewriteHandler.h +include/postgresql/server/rewrite/rewriteManip.h +include/postgresql/server/rewrite/rewriteRemove.h +include/postgresql/server/rewrite/rewriteSupport.h +include/postgresql/server/rusagestub.h +include/postgresql/server/storage/backendid.h +include/postgresql/server/storage/block.h +include/postgresql/server/storage/buf.h +include/postgresql/server/storage/buf_internals.h +include/postgresql/server/storage/buffile.h +include/postgresql/server/storage/bufmgr.h +include/postgresql/server/storage/bufpage.h +include/postgresql/server/storage/fd.h +include/postgresql/server/storage/freespace.h +include/postgresql/server/storage/ipc.h +include/postgresql/server/storage/item.h +include/postgresql/server/storage/itemid.h +include/postgresql/server/storage/itempos.h +include/postgresql/server/storage/itemptr.h +include/postgresql/server/storage/large_object.h +include/postgresql/server/storage/lmgr.h +include/postgresql/server/storage/lock.h +include/postgresql/server/storage/lwlock.h +include/postgresql/server/storage/off.h +include/postgresql/server/storage/pg_sema.h +include/postgresql/server/storage/pg_shmem.h +include/postgresql/server/storage/pmsignal.h +include/postgresql/server/storage/pos.h +include/postgresql/server/storage/proc.h +include/postgresql/server/storage/relfilenode.h +include/postgresql/server/storage/s_lock.h +include/postgresql/server/storage/shmem.h +include/postgresql/server/storage/sinval.h +include/postgresql/server/storage/sinvaladt.h +include/postgresql/server/storage/smgr.h +include/postgresql/server/storage/spin.h +include/postgresql/server/strdup.h +include/postgresql/server/tcop/dest.h +include/postgresql/server/tcop/fastpath.h +include/postgresql/server/tcop/pquery.h +include/postgresql/server/tcop/tcopdebug.h +include/postgresql/server/tcop/tcopprot.h +include/postgresql/server/tcop/utility.h +include/postgresql/server/utils/acl.h +include/postgresql/server/utils/array.h +include/postgresql/server/utils/ascii.h +include/postgresql/server/utils/builtins.h +include/postgresql/server/utils/cash.h +include/postgresql/server/utils/catcache.h +include/postgresql/server/utils/date.h +include/postgresql/server/utils/datetime.h +include/postgresql/server/utils/datum.h +include/postgresql/server/utils/dynahash.h +include/postgresql/server/utils/dynamic_loader.h +include/postgresql/server/utils/elog.h +include/postgresql/server/utils/errcodes.h +include/postgresql/server/utils/fmgroids.h +include/postgresql/server/utils/fmgrtab.h +include/postgresql/server/utils/formatting.h +include/postgresql/server/utils/geo_decls.h +include/postgresql/server/utils/guc.h +include/postgresql/server/utils/guc_tables.h +include/postgresql/server/utils/help_config.h +include/postgresql/server/utils/hsearch.h +include/postgresql/server/utils/inet.h +include/postgresql/server/utils/int8.h +include/postgresql/server/utils/inval.h +include/postgresql/server/utils/logtape.h +include/postgresql/server/utils/lsyscache.h +include/postgresql/server/utils/memutils.h +include/postgresql/server/utils/nabstime.h +include/postgresql/server/utils/numeric.h +include/postgresql/server/utils/palloc.h +include/postgresql/server/utils/pg_crc.h +include/postgresql/server/utils/pg_locale.h +include/postgresql/server/utils/pg_lzcompress.h +include/postgresql/server/utils/portal.h +include/postgresql/server/utils/ps_status.h +include/postgresql/server/utils/rel.h +include/postgresql/server/utils/relcache.h +include/postgresql/server/utils/resowner.h +include/postgresql/server/utils/selfuncs.h +include/postgresql/server/utils/syscache.h +include/postgresql/server/utils/timestamp.h +include/postgresql/server/utils/tqual.h +include/postgresql/server/utils/tuplesort.h +include/postgresql/server/utils/tuplestore.h +include/postgresql/server/utils/typcache.h +include/postgresql/server/utils/varbit.h +include/sql3types.h +include/sqlca.h +lib/libecpg.a +lib/libecpg.so +lib/libecpg.so.4 +lib/libecpg.so.4.2 +lib/libecpg_compat.a +lib/libecpg_compat.so +lib/libecpg_compat.so.1 +lib/libecpg_compat.so.1.1 +lib/libpgtypes.a +lib/libpgtypes.so +lib/libpgtypes.so.1 +lib/libpgtypes.so.1.2 +lib/libpq.a +lib/libpq.so +lib/libpq.so.3 +lib/libpq.so.3.2 +lib/postgresql/plpgsql.so +@comment lib/libecpg.4.2.dylib +@comment lib/libecpg.4.dylib +@comment lib/libecpg.dylib +@comment lib/libecpg_compat.1.1.dylib +@comment lib/libecpg_compat.1.dylib +@comment lib/libecpg_compat.dylib +@comment lib/libpgtypes.1.2.dylib +@comment lib/libpgtypes.1.dylib +@comment lib/libpgtypes.dylib +@comment lib/libpq.3.2.dylib +@comment lib/libpq.3.dylib +@comment lib/libpq.dylib +man/man1/ecpg.1 +${PKGLOCALEDIR}/locale/af/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/de/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/es/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/hr/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/it/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/libpq.mo +${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/libpq.mo +share/postgresql/pg_service.conf.sample +@dirrm include/postgresql/server/utils +@dirrm include/postgresql/server/tcop +@dirrm include/postgresql/server/storage +@dirrm include/postgresql/server/rewrite +@dirrm include/postgresql/server/regex +@dirrm include/postgresql/server/port/win32/sys +@dirrm include/postgresql/server/port/win32/netinet +@dirrm include/postgresql/server/port/win32/arpa +@dirrm include/postgresql/server/port/win32 +@dirrm include/postgresql/server/port +@dirrm include/postgresql/server/parser +@dirrm include/postgresql/server/optimizer +@dirrm include/postgresql/server/nodes +@dirrm include/postgresql/server/mb +@dirrm include/postgresql/server/libpq +@dirrm include/postgresql/server/lib +@dirrm include/postgresql/server/executor +@dirrm include/postgresql/server/commands +@dirrm include/postgresql/server/catalog +@dirrm include/postgresql/server/bootstrap +@dirrm include/postgresql/server/access +@dirrm include/postgresql/server +@dirrm include/postgresql/internal/libpq +@dirrm include/postgresql/internal +@dirrm include/postgresql/informix/esql +@dirrm include/postgresql/informix +@dirrm include/postgresql diff --git a/databases/postgresql80-lib/buildlink3.mk b/databases/postgresql80-lib/buildlink3.mk new file mode 100644 index 00000000000..911990ece45 --- /dev/null +++ b/databases/postgresql80-lib/buildlink3.mk @@ -0,0 +1,26 @@ +# $NetBSD: buildlink3.mk,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ + +BUILDLINK_DEPTH:= ${BUILDLINK_DEPTH}+ +POSTGRESQL80_LIB_BUILDLINK3_MK:= ${POSTGRESQL80_LIB_BUILDLINK3_MK}+ + +.if !empty(BUILDLINK_DEPTH:M+) +BUILDLINK_DEPENDS+= postgresql80-lib +.endif + +BUILDLINK_PACKAGES:= ${BUILDLINK_PACKAGES:Npostgresql80-lib} +BUILDLINK_PACKAGES+= postgresql80-lib + +.if !empty(POSTGRESQL80_LIB_BUILDLINK3_MK:M+) +BUILDLINK_DEPENDS.postgresql80-lib+= postgresql80-lib>=8.0.0beta4 +BUILDLINK_PKGSRCDIR.postgresql80-lib?= ../../wip/postgresql80-lib + +BUILDLINK_INCDIRS.postgresql80-lib+= pgsql80/include +BUILDLINK_LIBDIRS.postgresql80-lib+= pgsql80/lib + +.endif # POSTGRESQL80_LIB_BUILDLINK3_MK + +.include "../../security/openssl/buildlink3.mk" +.include "../../devel/gettext-lib/buildlink3.mk" +.include "../../devel/zlib/buildlink3.mk" + +BUILDLINK_DEPTH:= ${BUILDLINK_DEPTH:S/+$//} diff --git a/databases/postgresql80-lib/files/man.lib b/databases/postgresql80-lib/files/man.lib new file mode 100644 index 00000000000..686084a20c1 --- /dev/null +++ b/databases/postgresql80-lib/files/man.lib @@ -0,0 +1,3 @@ +# $NetBSD: man.lib,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ +# +man1/ecpg.1 diff --git a/databases/postgresql80-server/DEINSTALL b/databases/postgresql80-server/DEINSTALL new file mode 100644 index 00000000000..761da62253f --- /dev/null +++ b/databases/postgresql80-server/DEINSTALL @@ -0,0 +1,20 @@ +# $NetBSD: DEINSTALL,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ + +case ${STAGE} in +DEINSTALL) + ${CAT} << EOF +=========================================================================== + +If you intend to upgrade your PostgreSQL installation, you may need to +perform a dump-and-restore to move your current databases into the newer +PostgreSQL installation. Please dump your databases *prior* to installing +the new PostgreSQL. + +Please see the Backup and Restore section of the PostgreSQL Administrator's +Guide (databases/postgresql-docs) for complete information on how to +perform the databases dump. + +=========================================================================== +EOF + ;; +esac diff --git a/databases/postgresql80-server/DESCR b/databases/postgresql80-server/DESCR new file mode 100644 index 00000000000..68bb2b05748 --- /dev/null +++ b/databases/postgresql80-server/DESCR @@ -0,0 +1,9 @@ +PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), +derived from the Berkeley Postgres database management system. While +PostgreSQL retains the powerful object-relational data model, rich data types +and easy extensibility of Postgres, it replaces the PostQuel query language +with an extended subset of SQL. + +PostgreSQL is free and the complete source is available. + +This package contains the database server programs. diff --git a/databases/postgresql80-server/MESSAGE b/databases/postgresql80-server/MESSAGE new file mode 100644 index 00000000000..7981e9017d8 --- /dev/null +++ b/databases/postgresql80-server/MESSAGE @@ -0,0 +1,19 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ + +To enable this package, put the following into your /etc/rc.conf: + + pgsql=yes + pgsql_flags="-l" # enables SSL connections (TCP/IP and + # ~pgsql/data/server.crt required) + +and ensure that + + ${RCD_SCRIPTS_DIR}/pgsql start + +is run at the appropriate time. + +Note: PostgreSQL 8.0 accepts TCP/IP connections on localhost address +by default. + +=========================================================================== diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile new file mode 100644 index 00000000000..5ae50325f47 --- /dev/null +++ b/databases/postgresql80-server/Makefile @@ -0,0 +1,80 @@ +# $NetBSD: Makefile,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ + +PKGNAME= postgresql80-server-${BASE_VERS} +PKGREVISION= # empty +COMMENT= PostgreSQL database server programs + +DEPENDS+= postgresql80-client>=${BASE_VERS}:../../wip/postgresql80-client + +# mips has no TAS implementation +NOT_FOR_PLATFORM= *-*-mips + +.include "../../wip/postgresql80/Makefile.common" + +USE_PKGINSTALL= yes +DEINSTALL_EXTRA_TMPL+= ${.CURDIR}/DEINSTALL +MESSAGE_SRC= ${.CURDIR}/MESSAGE + +CONFIGURE_ARGS+= --with-openssl +BUILD_DIRS= ${WRKSRC}/src/backend +BUILD_DIRS+= ${WRKSRC}/src/backend/utils/mb/conversion_procs + +.if defined(USE_PAM) +. include "../../security/PAM/buildlink3.mk" +CONFIGURE_ARGS+= --with-pam +.endif + +# PGUSER username of the database administrator +# PGGROUP group of the database administrator +# PGHOME home directory of the database administrator and location of +# the databases +# +PGUSER?= pgsql +PGGROUP?= pgsql +PGHOME?= ${PREFIX}/${PGUSER} +FILES_SUBST+= PGUSER=${PGUSER} +FILES_SUBST+= PGGROUP=${PGGROUP} +FILES_SUBST+= PGHOME=${PGHOME} +BUILD_DEFS= PGUSER PGGROUP PGHOME + +PKG_USERS= ${PGUSER}:${PGGROUP}::PostgreSQL\\ database\\ administrator:${PGHOME}:${SH} +PKG_GROUPS= ${PGGROUP} + +RCD_SCRIPTS= pgsql + +post-buildlink: +# +# Avoid conflict between "${LOCALBASE}/include/openssl/des.h" and +# "/usr/include/crypt.h" -- we want the definitions in the former. +# +.if (${OPSYS} == "SunOS") + ${TOUCH} ${BUILDLINK_DIR}/include/crypt.h +.endif + +pre-build: + ${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}cd ${WRKSRC}/src/backend && \ + ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} \ + ../../src/include/parser/parse.h ../../src/include/utils/fmgroids.h + ${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}cd ${WRKSRC}/src/port && \ + ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} + +pre-install: + @case "X${PGUSER}" in \ + Xbin|Xetc|Xinclude|Xinfo|Xlib|Xlibdata|Xlibexec|Xman|Xsbin|Xshare) \ + ${ECHO} "You have chosen PGUSER=${PGUSER} which will"; \ + ${ECHO} "cause trouble, because the postgres home directory"; \ + ${ECHO} "would be ${PGHOME}. Please"; \ + ${ECHO} "set PGUSER to something more reasonable"; \ + ${ECHO} "like pgsql."; \ + ${ECHO} ""; \ + ${FALSE}; \ + ;; \ + esac + +post-install: + ${EGREP} -v "^#" ${FILESDIR}/man.server > ${WRKDIR}/man_tar + cd ${PG_DIR}/man && ${TAR} -zxm -T ${WRKDIR}/man_tar \ + -f ${WRKSRC}/doc/man.tar.gz + +.include "../../wip/postgresql80-lib/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql80-server/PLIST b/databases/postgresql80-server/PLIST new file mode 100644 index 00000000000..957df03487f --- /dev/null +++ b/databases/postgresql80-server/PLIST @@ -0,0 +1,61 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ +bin/postgres +bin/postmaster +lib/postgresql/ascii_and_mic.so +lib/postgresql/cyrillic_and_mic.so +lib/postgresql/euc_cn_and_mic.so +lib/postgresql/euc_jp_and_sjis.so +lib/postgresql/euc_kr_and_mic.so +lib/postgresql/euc_tw_and_big5.so +lib/postgresql/latin2_and_win1250.so +lib/postgresql/latin_and_mic.so +lib/postgresql/utf8_and_ascii.so +lib/postgresql/utf8_and_big5.so +lib/postgresql/utf8_and_cyrillic.so +lib/postgresql/utf8_and_euc_cn.so +lib/postgresql/utf8_and_euc_jp.so +lib/postgresql/utf8_and_euc_kr.so +lib/postgresql/utf8_and_euc_tw.so +lib/postgresql/utf8_and_gb18030.so +lib/postgresql/utf8_and_gbk.so +lib/postgresql/utf8_and_iso8859.so +lib/postgresql/utf8_and_iso8859_1.so +lib/postgresql/utf8_and_johab.so +lib/postgresql/utf8_and_sjis.so +lib/postgresql/utf8_and_tcvn.so +lib/postgresql/utf8_and_uhc.so +lib/postgresql/utf8_and_win1250.so +lib/postgresql/utf8_and_win1256.so +lib/postgresql/utf8_and_win874.so +man/man1/postgres.1 +man/man1/postmaster.1 +share/postgresql/conversion_create.sql +share/postgresql/information_schema.sql +${PKGLOCALEDIR}/locale/af/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/de/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/es/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/hr/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/hu/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/it/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/postgres.mo +${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/postgres.mo +share/postgresql/pg_hba.conf.sample +share/postgresql/pg_ident.conf.sample +share/postgresql/postgres.bki +share/postgresql/postgres.description +share/postgresql/postgresql.conf.sample +share/postgresql/recovery.conf.sample +share/postgresql/sql_features.txt +share/postgresql/system_views.sql +@comment in postgresql80-client: @dirrm share +@comment in postgresql80-lib: @dirrm man/man1 +@comment in postgresql80-lib: @dirrm lib/postgresql +@comment in postgresql80-lib: @dirrm bin diff --git a/databases/postgresql80-server/files/man.server b/databases/postgresql80-server/files/man.server new file mode 100644 index 00000000000..7a76d2c3193 --- /dev/null +++ b/databases/postgresql80-server/files/man.server @@ -0,0 +1,4 @@ +# $NetBSD: man.server,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ +# +man1/postgres.1 +man1/postmaster.1 diff --git a/databases/postgresql80-server/files/pgsql.sh b/databases/postgresql80-server/files/pgsql.sh new file mode 100644 index 00000000000..481fc1e9d14 --- /dev/null +++ b/databases/postgresql80-server/files/pgsql.sh @@ -0,0 +1,142 @@ +#!@RCD_SCRIPTS_SHELL@ +# +# $NetBSD: pgsql.sh,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ +# +# PostgreSQL database rc.d control script +# +# PROVIDE: pgsql +# REQUIRE: DAEMON +# KEYWORD: shutdown +# +# You will need to set some variables in /etc/rc.conf to start PostgreSQL: +# +# pgsql=YES +# +# The following variables are optional: +# +# pgsql_flags="-i" # allows TCP/IP connections +# pgsql_flags="-i -l" # enables SSL connections +# pgsql_home="/path/to/home" # path to pgsql database directory +# +# "pgsql_flags" contains options for the PostgreSQL postmaster. See +# postmaster(1) for possible options. + +if [ -f /etc/rc.subr ]; then + . /etc/rc.subr +fi + +name="pgsql" +rcvar=$name +pgsql_user="@PGUSER@" +pgsql_group="@PGGROUP@" +eval pgsql_home="~$pgsql_user" + +command="@PREFIX@/bin/postmaster" +ctl_command="@PREFIX@/bin/pg_ctl" +extra_commands="initdb" + +if [ -f /etc/rc.subr -a -d /etc/rc.d -a -f /etc/rc.d/DAEMON ]; then + load_rc_config $name +elif [ -f /etc/rc.conf ]; then + . /etc/rc.conf +fi + +pidfile="${pgsql_home}/data/postmaster.pid" +common_args="-D ${pgsql_home}/data" +start_command_args="-w -s -l ${pgsql_home}/errlog" +stop_command_args="-s -m fast" + +initdb_cmd="pgsql_initdb" +start_precmd="pgsql_precmd" +start_cmd="pgsql_doit start" +restart_cmd="pgsql_doit restart" +stop_cmd="pgsql_doit stop" + +ulimit -n 4096 + +pgsql_precmd() +{ + if [ ! -d ${pgsql_home}/data/base ]; then + pgsql_initdb + fi +} + +pgsql_initdb() +{ + initdb="@PREFIX@/bin/initdb" + + if [ ! -x ${initdb} ]; then + return 1 + fi + if [ -d ${pgsql_home}/data/base ]; then + @ECHO@ "The PostgreSQL template databases have already been initialized." + @ECHO@ "Skipping database initialization." + else + @ECHO@ "Initializing PostgreSQL databases." + @MKDIR@ -p ${pgsql_home} + @CHOWN@ ${pgsql_user} ${pgsql_home} + @CHGRP@ ${pgsql_group} ${pgsql_home} + @CHMOD@ 0750 ${pgsql_home} + eval doit_command=\"${initdb} ${common_args} ${flags}\" + doit="@SU@ -m ${pgsql_user} -c '${doit_command}'" + eval $doit + fi +} + +pgsql_doit() +{ + action=$1 + + case ${action} in + start|restart) + if [ -n "${pgsql_flags}" ]; then + start_command_args="${start_command_args} -o \\\"${pgsql_flags}\\\"" + fi + command_args="${common_args} ${start_command_args} ${command_args}" + ;; + stop) + command_args="${common_args} ${stop_command_args} ${command_args}" + ;; + *) + command_args="${common_args} ${command_args}" + ;; + esac + + if [ ! -x ${ctl_command} ]; then + return + fi + + case ${action} in + start) @ECHO@ "Starting ${name}." ;; + stop) @ECHO@ "Stopping ${name}." ;; + restart) @ECHO@ "Restarting ${name}." ;; + esac + + eval doit_command=\"${ctl_command} ${action} ${command_args}\" + doit="@SU@ -m ${pgsql_user} -c '${doit_command}'" + eval $doit +} + +if [ -f /etc/rc.subr -a -d /etc/rc.d -a -f /etc/rc.d/DAEMON ]; then + load_rc_config $name + run_rc_command "$1" +else + if [ -f /etc/rc.conf ]; then + . /etc/rc.conf + fi + case "$1" in + initdb) + eval ${initdb_cmd} + ;; + restart) + eval ${restart_cmd} + ;; + stop) + eval ${stop_cmd} + ;; + *) + eval ${start_precmd} + eval ${start_cmd} + ;; + esac +fi diff --git a/databases/postgresql80/DESCR b/databases/postgresql80/DESCR new file mode 100644 index 00000000000..9f6b5b5b0f9 --- /dev/null +++ b/databases/postgresql80/DESCR @@ -0,0 +1,9 @@ +PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), +derived from the Berkeley Postgres database management system. While +PostgreSQL retains the powerful object-relational data model, rich data types +and easy extensibility of Postgres, it replaces the PostQuel query language +with an extended subset of SQL. + +PostgreSQL is free and the complete source is available. + +This is the meta-package for the PostgreSQL database system. diff --git a/databases/postgresql80/Makefile b/databases/postgresql80/Makefile new file mode 100644 index 00000000000..2d29f27c5e9 --- /dev/null +++ b/databases/postgresql80/Makefile @@ -0,0 +1,19 @@ + +PKGNAME= postgresql80-${BASE_VERS} +COMMENT= Robust, next generation, object-relational DBMS + +DEPENDS+= postgresql80-client>=${BASE_VERS}:../../wip/postgresql80-client +DEPENDS+= postgresql80-server>=${BASE_VERS}:../../wip/postgresql80-server +DEPENDS+= postgresql80-docs>=${BASE_VERS}:../../wip/postgresql80-docs + +.include "Makefile.common" + +EXTRACT_ONLY= # empty +NO_CHECKSUM= YES +NO_CONFIGURE= YES +NO_BUILD= YES + +do-install: # empty +do-patch: # empty + +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql80/Makefile.common b/databases/postgresql80/Makefile.common new file mode 100644 index 00000000000..93991c625a7 --- /dev/null +++ b/databases/postgresql80/Makefile.common @@ -0,0 +1,117 @@ +# $NetBSD: Makefile.common,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ +# +# This Makefile fragment is included by all PostgreSQL packages built from +# the main sources of the PostgreSQL distribution except jdbc-postgresql. +# +# The PostgreSQL package naming scheme, aside from the obvious piecewise +# packages, is as follows: +# +# <lang>-postgresql client-side interface to PostgreSQL +# postgresql-<lang> server-side module for PostgreSQL backend + +DISTNAME?= postgresql-${DIST_VERS} +CATEGORIES+= databases +MASTER_SITES?= \ + ftp://ftp.de.postgresql.org/mirror/postgresql/source/v${DIST_VERS}/ \ + ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/source/v${DIST_VERS}/ \ + ftp://ftp.sunsite.auc.dk/mirrors/postgresql/source/v${DIST_VERS}/ \ + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/source/v${DIST_VERS}/ \ + http://www.postgresql.org/ftpsite/source/v${DIST_VERS}/ \ + ftp://ftp.postgresql.org/pub/source/v${DIST_VERS}/ + +EXTRACT_SUFX= .tar.bz2 + +MAINTAINER?= recht@NetBSD.org +HOMEPAGE?= http://www.postgresql.org/ + +CONFLICTS+= postgresql-[0-9]* postgresql73-* postgresql74-* + +DISTINFO_FILE?= ${.CURDIR}/../postgresql80/distinfo +COMMON_FILESDIR?= ${.CURDIR}/../postgresql80/files +PATCHDIR?= ${.CURDIR}/../postgresql80/patches + +# Version numbering scheme: +# +# DIST_VERS version number on the postgresql distfile +# BASE_VERS pkgsrc-mangled version number (convert pl -> .) +# +# Note: Do not forget jdbc-postgresql when updating version +DIST_VERS?= 8.0.1 +BASE_VERS?= ${DIST_VERS} + +BUILDLINK_DEPENDS.postgresql80-lib?= postgresql80-lib>=${BASE_VERS} +#BUILDLINK_DEPENDS.tcl-postgresql80?= tcl-postgresql80>=${BASE_VERS} + +USE_BUILDLINK3= yes +GNU_CONFIGURE= yes +BUILD_USES_MSGFMT= yes +USE_GNU_TOOLS+= lex make yacc +PKG_SYSCONFSUBDIR= postgresql + +# in 7.4.2, this is done by autoconf stuff which has leading whitespace +#USE_PKGLOCALEDIR= yes +#SUBST_CLASSES+= pkglocaledir2 +#SUBST_FILES.pkglocaledir2= configure config/programs.m4 +#SUBST_STAGE.pkglocaledir2= pre-configure +#SUBST_SED.pkglocaledir2= -e 's|\( localedir[ :]*=\).*|\1${_PKGLOCALEDIR}|' + +.include "../../mk/bsd.prefs.mk" + +# Add support for hierarchical queries with Oracle like CONNECT BY syntax. +# see http://gppl.terminal.ru/README.html for details. +.if defined(PGSQL_USE_HIER) && !empty(PGSQL_USE_HIER:M[yY][eE][sS]) +PATCH_SITES= http://gppl.moonbone.ru/ +PATCHFILES= hier-Pg7.4-0.5.3.tar.gz +PATCH_DIST_STRIP= -p1 +.endif +BUILD_DEFS+= PGSQL_USE_HIER + +PGSQL_TEMPLATE.SunOS= solaris +.if !defined(PGSQL_TEMPLATE.${OPSYS}) +PGSQL_TEMPLATE.${OPSYS}= ${LOWER_OPSYS} +.endif + +PG_DIR= ${PREFIX} +GNU_CONFIGURE_PREFIX= ${PG_DIR} +INSTALLATION_DIRS+= ${PG_DIR} + +#CONFIGURE_ARGS+= --sysconfdir=${PKG_SYSCONFDIR} +CONFIGURE_ARGS+= --with-docdir=${PREFIX}/share/doc/postgresql80 +CONFIGURE_ARGS+= --with-template="${PGSQL_TEMPLATE.${OPSYS}}" +CONFIGURE_ARGS+= --without-readline +CONFIGURE_ARGS+= --with-zlib +CONFIGURE_ARGS+= --enable-nls + +CONFIGURE_ARGS+= --without-java +CONFIGURE_ARGS+= --without-perl +CONFIGURE_ARGS+= --without-python +CONFIGURE_ARGS+= --without-tcl +CONFIGURE_ARGS+= --without-tk + +# Postgresql explicitly forbids any use of -ffast-math +CFLAGS:= ${CFLAGS:S/-ffast-math//} + +post-extract: + if [ -d ${WRKSRC}/src ]; then \ + ${RM} -f ${WRKSRC}/src/Makefile.custom; \ + ${CP} -f ${COMMON_FILESDIR}/Makefile.custom \ + ${WRKSRC}/src/Makefile.custom; \ + fi + if [ -d ${WRKSRC}/src/interfaces/libpq ]; then \ + ${RM} -f ${WRKSRC}/src/interfaces/libpq/GNUmakefile; \ + ${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpq \ + ${WRKSRC}/src/interfaces/libpq/GNUmakefile; \ + fi + if [ -d ${WRKSRC}/src/interfaces/libpgtcl ]; then \ + ${RM} -f ${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile; \ + ${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpgtcl \ + ${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile; \ + fi + if [ -d ${WRKSRC}/src/backend/port/dynloader ]; then \ + ${RM} -f ${WRKSRC}/src/backend/port/dynloader/netbsd.[ch];\ + ${CP} -f ${COMMON_FILESDIR}/netbsd.[ch] \ + ${WRKSRC}/src/backend/port/dynloader/; \ + fi + +.include "../../devel/gettext-lib/buildlink3.mk" +.include "../../devel/zlib/buildlink3.mk" diff --git a/databases/postgresql80/PLIST b/databases/postgresql80/PLIST new file mode 100644 index 00000000000..42ad3c2e849 --- /dev/null +++ b/databases/postgresql80/PLIST @@ -0,0 +1,2 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ +@comment this plist intentionally left empty diff --git a/databases/postgresql80/distinfo b/databases/postgresql80/distinfo new file mode 100644 index 00000000000..48b7c2ae471 --- /dev/null +++ b/databases/postgresql80/distinfo @@ -0,0 +1,5 @@ +$NetBSD: distinfo,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ + +SHA1 (postgresql-8.0.1.tar.bz2) = 42a16fe13a6271b1612fb0a9f41f7da0a2e307b6 +Size (postgresql-8.0.1.tar.bz2) = 11049626 bytes +SHA1 (patch-aa) = 20492216de0e5238a02b4cdd18c297731cf6462a diff --git a/databases/postgresql80/files/GNUmakefile.libpgtcl b/databases/postgresql80/files/GNUmakefile.libpgtcl new file mode 100644 index 00000000000..b1ea47d2775 --- /dev/null +++ b/databases/postgresql80/files/GNUmakefile.libpgtcl @@ -0,0 +1,20 @@ +# $NetBSD: GNUmakefile.libpgtcl,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ +# +# This GNUmakefile overrides the `all' target of $(libpgtcl_srcdir)/Makefile +# to be empty if INSTALLED_LIBPGTCL is defined. This handles the submake +# targets sprinkled throughout the PostgreSQL Makefiles that execute +# +# @$(MAKE) -C $(libpgtcl_builddir) all +# +# to ensure that the libpgtcl libraries are built first. If INSTALLED_LIBPGTCL +# is defined, then have the `all' target simple return success. + +ifdef INSTALLED_LIBPGTCL +all: + @test -f libpgtcl.a || touch libpgtcl.a +endif + +%: force + @$(MAKE) -f Makefile $@ + +force: ; diff --git a/databases/postgresql80/files/GNUmakefile.libpq b/databases/postgresql80/files/GNUmakefile.libpq new file mode 100644 index 00000000000..16a1e9834fc --- /dev/null +++ b/databases/postgresql80/files/GNUmakefile.libpq @@ -0,0 +1,20 @@ +# $NetBSD: GNUmakefile.libpq,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ +# +# This GNUmakefile overrides the `all' target of $(libpq_srcdir)/Makefile +# to be empty if INSTALLED_LIBPQ is defined. This handles the submake +# targets sprinkled throughout the PostgreSQL Makefiles that execute +# +# @$(MAKE) -C $(libpq_builddir) all +# +# to ensure that the libpq libraries are built first. If INSTALLED_LIBPQ +# is defined, then have the `all' target simple return success. + +ifdef INSTALLED_LIBPQ +all: + @test -f libpq.a || touch libpq.a +endif + +%: force + @$(MAKE) -f Makefile $@ + +force: ; diff --git a/databases/postgresql80/files/Makefile.custom b/databases/postgresql80/files/Makefile.custom new file mode 100644 index 00000000000..2c27efbc3a4 --- /dev/null +++ b/databases/postgresql80/files/Makefile.custom @@ -0,0 +1,15 @@ +# $NetBSD: Makefile.custom,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ +# +# This file is included by Makefile.global, which is included by every +# sub-Makefile in the build tree. Makefiles for shared libraries include +# Makefile.global then Makefile.shlib. + +pkglibdir = $(exec_prefix)/lib/postgresql + +ifdef INSTALLED_LIBPQ +libpq = -lpq +endif + +ifdef INSTALLED_LIBPGTCL +libpgtcl = -lpgtcl +endif diff --git a/databases/postgresql80/files/netbsd.c b/databases/postgresql80/files/netbsd.c new file mode 100644 index 00000000000..d2ef8e70699 --- /dev/null +++ b/databases/postgresql80/files/netbsd.c @@ -0,0 +1,73 @@ +/*- + * Portions Copyright (c) 1996-2003, PostgreSQL Global Development Group + * Portions Copyright (c) 1990 The Regents of the University of California. + * All rights reserved. + * + * Redistribution and use in source and binary forms, with or without + * modification, are permitted provided that the following conditions + * are met: + * 1. Redistributions of source code must retain the above copyright + * notice, this list of conditions and the following disclaimer. + * 2. 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. + * 3. All advertising materials mentioning features or use of this software + * must display the following acknowledgement: + * This product includes software developed by the University of + * California, Berkeley and its contributors. + * 4. Neither the name of the University 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 REGENTS 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 REGENTS 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. + */ + +#if defined(LIBC_SCCS) && !defined(lint) +static char sccsid[] = "@(#)dl.c 5.4 (Berkeley) 2/23/91"; +#endif /* LIBC_SCCS and not lint */ + +#include "postgres.h" + +#include <nlist.h> +#include <link.h> +#include <dlfcn.h> + +#include "dynloader.h" + +#ifndef HAVE_DLOPEN + +char * +pg_dlerror(void) +{ + return "dynaloader unsupported"; +} + +void * +pg_dlopen(const char *file, int num) +{ + elog(ERROR, "dynamic load not supported"); + return NULL; +} + +void * +pg_dlsym(void *handle, const char *name) +{ + return NULL; +} + +void +pg_dlclose(void *handle) +{ +} + +#endif /* ! HAVE_DLOPEN */ diff --git a/databases/postgresql80/files/netbsd.h b/databases/postgresql80/files/netbsd.h new file mode 100644 index 00000000000..b9ac224d9e5 --- /dev/null +++ b/databases/postgresql80/files/netbsd.h @@ -0,0 +1,45 @@ +/*------------------------------------------------------------------------- + * + * netbsd.h + * port-specific prototypes for NetBSD + * + * + * Portions Copyright (c) 1996-2003, PostgreSQL Global Development Group + * Portions Copyright (c) 1994, Regents of the University of California + * + * $Id: netbsd.h,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ + * + *------------------------------------------------------------------------- + */ +#ifndef PORT_PROTOS_H +#define PORT_PROTOS_H + +#include <sys/types.h> +#include <nlist.h> +#include <link.h> +#include <dlfcn.h> + +#include "utils/dynamic_loader.h" + +#ifdef HAVE_DLOPEN +/* + * In some older systems, the RTLD_NOW flag isn't defined and the mode + * argument to dlopen must always be 1. The RTLD_GLOBAL flag is wanted + * if available, but it doesn't exist everywhere. + * If it doesn't exist, set it to 0 so it has no effect. + */ +#ifndef RTLD_NOW +#define RTLD_NOW 1 +#endif +#ifndef RTLD_GLOBAL +#define RTLD_GLOBAL 0 +#endif + +#define pg_dlopen(f) dlopen((f), RTLD_NOW | RTLD_GLOBAL) +#define pg_dlsym dlsym +#define pg_dlclose dlclose +#define pg_dlerror dlerror + +#endif /* HAVE_DLOPEN */ + +#endif /* PORT_PROTOS_H */ diff --git a/databases/postgresql80/patches/patch-aa b/databases/postgresql80/patches/patch-aa new file mode 100644 index 00000000000..a6592ae3d6f --- /dev/null +++ b/databases/postgresql80/patches/patch-aa @@ -0,0 +1,31 @@ +$NetBSD: patch-aa,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $ + +--- src/Makefile.shlib.orig Tue Nov 9 17:02:42 2004 ++++ src/Makefile.shlib +@@ -132,7 +132,7 @@ endif + + ifeq ($(PORTNAME), freebsd) + ifdef ELF_SYSTEM +- shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION) ++ shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION) + LINK.shared = $(COMPILER) -shared -Wl,-x,-soname,$(soname) + else + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION) +@@ -149,7 +149,7 @@ ifeq ($(PORTNAME), netbsd) + endif + + ifeq ($(PORTNAME), hpux) +- shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION) ++ shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION) + ifeq ($(GCC), yes) + SHLIB_LINK += `$(CC) $(LDFLAGS) -print-libgcc-file-name` + endif +@@ -161,7 +161,7 @@ ifeq ($(PORTNAME), hpux) + endif + + ifeq ($(PORTNAME), irix) +- shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION) ++ shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION) + LINK.shared = $(COMPILER) -shared -Wl,-set_version,sgi$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION) + endif + |