Subject: CVS commit: pkgsrc/databases
To: None <>
From: Johnny C. Lam <>
List: pkgsrc-changes
Date: 01/05/2003 22:12:31
Module Name:	pkgsrc
Committed By:	jlam
Date:		Sun Jan  5 20:12:31 UTC 2003

Modified Files:
	pkgsrc/databases/postgresql: Makefile Makefile.common distinfo
	pkgsrc/databases/postgresql-client: Makefile PLIST
	pkgsrc/databases/postgresql-client/files: exclude
	pkgsrc/databases/postgresql-docs: Makefile PLIST
	pkgsrc/databases/postgresql-lib: Makefile PLIST
	pkgsrc/databases/postgresql-plperl: Makefile
	pkgsrc/databases/postgresql-pltcl: Makefile PLIST
	pkgsrc/databases/postgresql-server: Makefile
	pkgsrc/databases/postgresql/patches: patch-aa patch-ac patch-ad
	    patch-ae patch-af
	pkgsrc/databases/tcl-postgresql: Makefile PLIST
	pkgsrc/databases/tk-postgresql: Makefile
Added Files:
	pkgsrc/databases/postgresql/patches: patch-ag
Removed Files:
	pkgsrc/databases/postgresql/patches: patch-ab patch-ah patch-ai
	    patch-al patch-am

Log Message:
Updated databases/postgresql to 7.3.1.

      | NOTE:  A dump-and-restore is required to update your databases |
      |        if you wish to update postgresql-server. If your        |
      |        application examines the system catalogs, additional    |
      |        changes will be required due to the introduction of     |
      |        schemas in 7.3; for more information, see:              |
      |                                                                |
      |   |

Major changes from version 7.2.3 include:

          Schemas allow users to create objects in separate namespaces,
          so two people or applications can have tables with the same
          name. There is also a public schema for shared tables.
          Table/index creation can be restricted by removing permissions
          on the public schema.

   Drop Column
          PostgreSQL now supports the ALTER TABLE ... DROP COLUMN

   Table Functions
          Functions returning multiple rows and/or multiple columns are
          now much easier to use than before. You can call such a "table
          function" in the SELECT FROM clause, treating its output like a
          table. Also, PL/pgSQL functions can now return sets.

   Prepared Queries
          PostgreSQL now supports prepared queries, for improved

   Dependency Tracking
          PostgreSQL now records object dependencies, which allows
          improvements in many areas. "DROP" statements now take either
          CASCADE or RESTRICT to control whether dependent objects are
          also dropped.

          Functions and procedural languages now have privileges, and
          functions can be defined to run with the privileges of their

          Both multibyte and locale support are now always enabled.

          A variety of logging options have been enhanced.

          A large number of interfaces have been moved to
 where they can be developed and
          released independently.

          By default, functions can now take up to 32 parameters, and
          identifiers can be up to 63 bytes long. Also, OPAQUE is now
          deprecated: there are specific "pseudo-datatypes" to represent
          each of the former meanings of OPAQUE in function argument and
          result types.

To generate a diff of this commit:
cvs rdiff -r1.68 -r1.69 pkgsrc/databases/postgresql/Makefile
cvs rdiff -r1.31 -r1.32 pkgsrc/databases/postgresql/Makefile.common
cvs rdiff -r1.13 -r1.14 pkgsrc/databases/postgresql/distinfo
cvs rdiff -r1.16 -r1.17 pkgsrc/databases/postgresql-client/Makefile
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql-client/PLIST
cvs rdiff -r1.1.1.1 -r1.2 pkgsrc/databases/postgresql-client/files/exclude
cvs rdiff -r1.4 -r1.5 pkgsrc/databases/postgresql-docs/Makefile
cvs rdiff -r1.3 -r1.4 pkgsrc/databases/postgresql-docs/PLIST
cvs rdiff -r1.7 -r1.8 pkgsrc/databases/postgresql-lib/Makefile
cvs rdiff -r1.3 -r1.4 pkgsrc/databases/postgresql-lib/PLIST
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql-lib/
cvs rdiff -r1.8 -r1.9 pkgsrc/databases/postgresql-plperl/Makefile
cvs rdiff -r1.6 -r1.7 pkgsrc/databases/postgresql-pltcl/Makefile
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql-pltcl/PLIST
cvs rdiff -r1.25 -r1.26 pkgsrc/databases/postgresql-server/Makefile
cvs rdiff -r1.9 -r1.10 pkgsrc/databases/postgresql/patches/patch-aa
cvs rdiff -r1.13 -r0 pkgsrc/databases/postgresql/patches/patch-ab
cvs rdiff -r1.11 -r1.12 pkgsrc/databases/postgresql/patches/patch-ac \
cvs rdiff -r1.13 -r1.14 pkgsrc/databases/postgresql/patches/patch-ae
cvs rdiff -r1.14 -r1.15 pkgsrc/databases/postgresql/patches/patch-af
cvs rdiff -r0 -r1.10 pkgsrc/databases/postgresql/patches/patch-ag
cvs rdiff -r1.10 -r0 pkgsrc/databases/postgresql/patches/patch-ah
cvs rdiff -r1.8 -r0 pkgsrc/databases/postgresql/patches/patch-ai
cvs rdiff -r1.6 -r0 pkgsrc/databases/postgresql/patches/patch-al
cvs rdiff -r1.7 -r0 pkgsrc/databases/postgresql/patches/patch-am
cvs rdiff -r1.13 -r1.14 pkgsrc/databases/tcl-postgresql/Makefile
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/tcl-postgresql/PLIST \
cvs rdiff -r1.14 -r1.15 pkgsrc/databases/tk-postgresql/Makefile

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.