Contents

• Name
• Version
• Synopsis
• Description
• Terminology
• Data Types
  • Boolean
  • String
  • List
  • Map
  • License String
  • Term
  • Tag
  • URI
  • Version
  • Version Range
• Structure
  • Required Fields
    • abstract
    • maintainer
    • license
    • provides
    • meta-spec
    • name
    • version
  • Optional Fields
    • description
    • generated_by
    • tags
    • no_index
    • prereqs
    • release_status
    • resources
• Version Numbers
  • Version Format
  • Version Ranges
• Prerequisites
  • Prereq Spec
    • Phases
    • Relationships
  • Merging and Resolving Prerequisites
• Serialization
• Notes For Implementors
  • Comparing Version Numbers
• See Also
• Contributors

Name

PGXN Meta Spec - The PGXN distribution metadata specification

Version

1.0.0

Synopsis

{
   "name": "pgTAP",
   "abstract": "Unit testing for PostgreSQL",
   "description": "pgTAP is a suite of database functions that make it easy to write TAP-emitting unit tests in psql scripts or xUnit-style test functions.",
   "version": "0.2.5",
   "maintainer": [
      "David E. Wheeler <theory@pgxn.org>",
      "pgTAP List <pgtap-users@pgfoundry.org>"
   ],
   "license": {
      "PostgreSQL": "https://www.postgresql.org/about/licence"
   },
   "prereqs": {
      "runtime": {
         "requires": {
            "plpgsql": 0,
            "PostgreSQL": "8.0.0"
         },
         "recommends": {
            "PostgreSQL": "8.4.0"
         }
      }
   },
   "provides": {
     "pgtap": {
       "file": "sql/pgtap.sql",
       "docfile": "doc/pgtap.mmd",
       "version": "0.2.4",
       "abstract": "Unit testing assertions for PostgreSQL"
     },
     "schematap": {
       "file": "sql/schematap.sql",
       "docfile": "doc/schematap.mmd",
       "version": "0.2.4",
       "abstract": "Schema testing assertions for PostgreSQL"
     }
   },
   "resources": {
      "homepage": "https://pgtap.org/",
      "bugtracker": {
         "web": "https://github.com/theory/pgtap/issues"
      },
      "repository": {
        "url":  "https://github.com/theory/pgtap.git",
        "web":  "https://github.com/theory/pgtap",
        "type": "git"
      }
   },
   "generated_by": "David E. Wheeler",
   "meta-spec": {
      "version": "1.0.0",
      "url": "https://pgxn.org/meta/spec.txt"
   },
   "tags": [
      "testing",
      "unit testing",
      "tap",
      "tddd",
      "test driven database development"
   ]
}

Description

This document describes version 1.0.0 of the PGXN distribution metadata specification, also known as the “PGXN Meta Spec.” It is formatted using the [MultiMarkdown] variant of Markdown, and the canonical copy may always be found at master.pgxn.org/meta/spec.txt. A generated HTML-formatted copy found at pgxn.org/spec/ may also be considered canonical.

This document is stable. Any revisions to this specification for typo corrections and prose clarifications may be issued as “PGXN Meta Spec 1.0.x”. These revisions will never change semantics or add or remove specified behavior.

Distribution metadata describe important properties of PGXN distributions. Distribution building tools should create a metadata file in accordance with this specification and include it with the distribution for use by automated tools that index, examine, package, or install PGXN distributions.

Terminology

distribution

The primary object described by the metadata. In the context of this document it usually refers to a collection of extensions, source code, utilities, tests, and/or documents that are distributed together for other developers to use. Examples of distributions are [semver], [pair], and [pgTAP].

extension

A reusable library of code contained in a single file or within files referenced by the [CREATE EXTENSION statement]. Extensions usually contain one or more PostgreSQL objects — such as data types, functions, and operators — and are often referred to by the name of a primary object that can be mapped to the file name. For example, one might refer to pgTAP instead of sql/pgtap.sql.

consumer

Code that reads a metadata file, deserializes it into a data structure in memory, or interprets a data structure of metadata elements.

producer

Code that constructs a metadata data structure, serializes into a bytestream and/or writes it to disk.

must, should, may, etc.

These terms are interpreted as described in IETF RFC 2119.

Data Types

Fields in the Structure section describe data elements, each of which has an associated data type as described herein. There are four primitive types: Boolean, String, List, and Map. Other types are subtypes of primitives and define compound data structures or define constraints on the values of a data element.

Boolean

A Boolean is used to provide a true or false value. It must be represented as a defined (not null) value.

String

A String is data element containing a non-zero length sequence of Unicode characters.

List

A List is an ordered collection of zero or more data elements. Elements of a List may be of mixed types.

Producers must represent List elements using a data structure which unambiguously indicates that multiple values are possible, such as a JavaScript array.

Consumers expecting a List must consider a String as equivalent to a List of length 1.

Map

A Map is an unordered collection of zero or more data elements (“values”), indexed by associated String elements (“keys”). The Map’s value elements may be of mixed types.

License String

A License String is a subtype of String with a restricted set of values. Valid values are described in detail in the description of the license field.

Term

A Term is a subtype of String that must be at least two characters long contain no slash (/), backslash (\), control, or space characters.

Tag

A Tag is a subtype of String that must be fewer than 256 characters long contain no slash (/), backslash (\), control, or space characters.

URI

URI is a subtype of String containing a Uniform Resource Identifier or Locator.

Version

A Version is a subtype of String containing a value that describes the version number of extensions or distributions. Restrictions on format are described in detail in the Version Format section.

Version Range

The Version Range type is a subtype of String. It describes a range of Versions that may be present or installed to fulfill prerequisites. It is specified in detail in the Version Ranges section.

Structure

The metadata structure is a data element of type Map. This section describes valid keys within the Map.

Any keys not described in this specification document (whether top-level or within compound data structures described herein) are considered custom keys and must begin with an “x” or “X” and be followed by an underscore; i.e. they must match the pattern: /\Ax_/i. If a custom key refers to a compound data structure, subkeys within it do not need an “x_” or “X_” prefix.

Consumers of metadata may ignore any or all custom keys. All other keys not described herein are invalid and should be ignored by consumers. Producers must not generate or output invalid keys.

For each key, an example is provided followed by a description. The description begins with the version of spec in which the key was added or in which the definition was modified, whether the key is required or optional, and the data type of the corresponding data element. These items are in parentheses, brackets, and braces, respectively.

If a data type is a Map or Map subtype, valid subkeys will be described as well. All examples are represented as JSON.

Required Fields

abstract

Example:

"abstract": "Unit testing for PostgreSQL"

(Spec 1) [required] {String}

This is a short description of the purpose of the distribution.

maintainer

Examples:

"maintainer": "David E. Wheeler <theory@pgxn.org>"

"maintainer": [
  "David E. Wheeler <theory@pgxn.org>",
  "Josh Berkus <jberkus@pgxn.org>"
]

(Spec 1) [required] {List of one or more Strings}

This List indicates the person(s) to contact concerning the distribution. The preferred form of the contact string is:

contact-name <email-address>

This field provides a general contact list independent of other structured fields provided within the resources field, such as bugtracker. The addressee(s) can be contacted for any purpose including but not limited to: (security) problems with the distribution, questions about the distribution, or bugs in the distribution.

A distribution’s original author is usually the contact listed within this field. Co-maintainers, successor maintainers, or mailing lists devoted to the distribution may also be listed in addition to or instead of the original author.

license

Examples:

"license": {
  "PostgreSQL": "https://www.postgresql.org/about/licence"
}

"license": {
  "Perl 5": "https://dev.perl.org/licenses/",
  "BSD": "https://www.opensource.org/licenses/bsd-license.html"
}

"license": "perl_5"

"license": [ "apache_2_0", "mozilla_1_0" ]

(Spec 1) [required] {Map or List of one or more License Strings}

One or more licenses that apply to some or all of the files in the distribution. If multiple licenses are listed, the distribution documentation should be consulted to clarify the interpretation of multiple licenses.

The Map type describes the license or licenses. Each subkey may be any string naming a license. All values must be URIs that link to the appropriate license.

The List type may be used as a shortcut to identify one or more well-known licenses. The following list of License Strings are valid in the List representation:

The following License Strings are also valid and indicate other licensing not described above:

All other strings are invalid in the license List.

provides

Example:

"provides": {
  "pgtap": {
    "file": "sql/pgtap.sql",
    "docfile": "doc/pgtap.mmd",
    "version": "0.2.4",
    "abstract": "Unit testing assertions for PostgreSQL"
  },
  "schematap": {
    "file": "sql/schematap.sql",
    "docfile": "doc/schematap.mmd",
    "version": "0.2.4",
    "abstract": "Schema testing assertions for PostgreSQL"
  }
}

(Spec 1) [required] {Map of Terms}

This describes all extensions provided by this distribution. This information is used by PGXN to build indexes identifying in which distributions various extensions can be found.

The keys of provides are Terms that name the extensions found within the distribution. The values are Maps with the following subkeys:

file

The value must contain a relative file path from the root of the distribution to the file containing the extension. The path must be specified with unix conventions. Required.

version

This field contains a Version for the extension. All extensions must have versions. Required.

abstract

A short String value describing the extension. Optional.

docfile

The value must contain a relative file path from the root of the distribution to the file containing documentation for the extension. The path must be specified with unix conventions. Optional.

meta-spec

Example:

"meta-spec": {
  "version": "1.0.0",
  "url": "https://pgxn.org/meta/spec.txt"
}

(Spec 1) [required] {Map}

This field indicates the Version of the PGXN Meta Spec that should be used to interpret the metadata. Consumers must check this key as soon as possible and abort further metadata processing if the meta-spec Version is not supported by the consumer.

The following keys are valid, but only version is required.

version

This subkey gives the integer Version of the PGXN Meta Spec against which the document was generated.

url

This is a URI of the metadata specification document corresponding to the given version. This is strictly for human-consumption and should not impact the interpretation of the document.

name

Example:

"name": "pgTAP"

(Spec 1) [required] {Term}

This field is the name of the distribution. This is usually the same as the name of the “main extension” in the distribution, but may be completely unrelated to the extensions within the distribution. This value will be used in the distribution file name on PGXN.

version

Example:

"version": "1.3.6"

(Spec 1) [required] {Version}

This field gives the version of the distribution to which the metadata structure refers. Its value must be a Version.

Optional Fields

description

Example:

"description": "pgTAP is a suite of database functions that make it easy to write TAP-emitting unit tests in psql scripts or xUnit-style test functions."

(Spec 1) [optional] {String}

A longer, more complete description of the purpose or intended use of the distribution than the one provided by the abstract key.

generated_by

Example:

"generated_by": "Module::Build::PGXN version 0.42"

(Spec 1) [optional] {String}

This field indicates the tool that was used to create this metadata. There are no defined semantics for this field, but it is traditional to use a string in the form “Software package version 1.23” or the maintainer’s name, if the file was generated by hand.

tags

Example:

"tags": [ "testing", "unit testing", "tap" ]

(Spec 1) [optional] {List of Tags}

A List of keywords that describe this distribution.

no_index

Example:

"no_index": {
  "file":      [ "src/file.sql" ],
  "directory": [ "src/private" ],
}

(Spec 1) [optional] {Map}

This Map describes any files or directories that are private to the packaging or implementation of the distribution and should be ignored by indexing or search tools.

Valid subkeys are as follows:

file

A List of relative paths to files. Paths must be specified with unix conventions.

directory

A List of relative paths to directories. Paths must be specified with unix conventions.

prereqs

Example:

"prereqs": {
  "runtime": {
    "requires": {
      "PostgreSQL": "8.0.0",
      "PostGIS": "1.5.0"
    },
    "recommends": {
      "PostgreSQL": "8.4.0"
    },
    "suggests": {
      "sha1": 0
    }
  },
  "build": {
    "requires": {
      "prefix": 0
    }
  },
  "test": {
    "recommends": {
      "pgTAP": 0
    }
  }
}

(Spec 1) [optional] {Map}

This is a Map that describes all the prerequisites of the distribution. The keys are phases of activity, such as configure, build, test, or runtime. Values are Maps in which the keys name the type of prerequisite relationship such as requires, recommends, suggests, or "conflicts", and the values provide sets of prerequisite relations. The sets of relations must be specified as a Map of extension names to Version Ranges.

The full definition for this field is given in the Prereq Spec section.

release_status

Example:

"release_status": "stable"

(Spec 1) [optional] {String}

This field specifies the release status of this distribution. It must have one of the following values:

stable

Indicates an ordinary, “final” release that should be indexed by PGXN.

testing

Indicates a “beta” release that is substantially complete, but has an elevated risk of bugs and requires additional testing. The distribution should not be installed over a stable release without an explicit request or other confirmation from a user. This release status may also be used for “release candidate” versions of a distribution.

unstable

Indicates an “alpha” release that is under active development, but has been released for early feedback or testing and may be missing features or may have serious bugs. The distribution should not be installed over a stable release without an explicit request or other confirmation from a user.

Consumers may use this field to determine how to index the distribution for PGXN or other repositories. If this field is not present, consumers may assume that the distribution status is “stable.”

resources

Example:

"resources": {
  "homepage": "https://pgxn.org/",
  "bugtracker": {
    "web": "https://github.com/theory/pgtap/issues",
    "mailto": "pgxn-bugs@example.com"
  },
  "repository": {
    "url": "git://github.com/theory/pgtap.git",
    "web": "https://github.com/theory/pgtap/",
    "type": "git"
  },
  "x_twitter": "https://twitter.com/pgtap/"
}

(Spec 1) [optional] {Map}

This field describes resources related to this distribution.

Valid subkeys include:

homepage

A URI for the official home of this project on the web.

bugtracker

This entry describes the bug tracking system for this distribution. It is a Map with the following valid keys:

web

a URI pointing to a web front-end for the bug tracker

mailto

an email address to which bug reports can be sent

repository

This entry describes the source control repository for this distribution. It is a Map with the following valid keys:

url

a URI pointing to the repository itself

web

a URI pointing to a web front-end for the repository

type

a lowercase string indicating the VCS used

Because a URI like https://myrepo.example.com/ is ambiguous as to type, producers should provide a type whenever a url key is given. The type field should be the name of the most common program used to work with the repository, e.g. git, svn, cvs, darcs, bzr or hg.

Version Numbers

Version Format

This section defines the Version type, used by several fields in the PGXN Meta Spec.

Version numbers must be treated as strings, and adhere to the [Semantic Versioning Specification]. Semantic versions take a dotted-integer format consisting of three positive integers separated by full stop characters (i.e. “dots”, “periods” or “decimal points”). A “special version” may be denoted by appending an arbitrary ASCII string immediately following the patch version. Please see [the specification] for all details on the format.

Version Ranges

Some fields (prereqs) indicate the particular version(s) of some other extension that may be required as a prerequisite. This section details the Version Range type used to provide this information.

The simplest format for a Version Range is just the version number itself, e.g. 2.4.0. This means that at leastversion 2.4.0 must be present. To indicate that any version of a prerequisite is okay, even if the prerequisite doesn’t define a version at all, use the version 0.

Alternatively, a version range may use the operators < (less than), <= (less than or equal), > (greater than), >= (greater than or equal), == (equal), and != (not equal). For example, the specification < 2.0.0 means that any version of the prerequisite less than 2.0.0 is suitable.

For more complicated situations, version specifications may be AND-ed together using commas. The specification >= 1.2.0, != 1.5.0, < 2.0.0 indicates a version that must be at least 1.2.0, less than 2.0.0, and not equal to 1.5.0.

Prerequisites

Prereq Spec

The prereqs key defines the relationship between a distribution and other extensions. The prereq spec structure is a hierarchical data structure which divides prerequisites into Phases of activity in the installation process and Relationships that indicate how prerequisites should be resolved.

For example, to specify that pgtap is required during the test phase, this entry would appear in the distribution metadata:

"prereqs": {
  "test": {
    "requires": {
      "pgtap": 0
    }
  }
}

Note that the prereqs key may not be used to specify prerequisites distributed outside PGXN or the PostgreSQL core and its contrib extensions.

Phases

Requirements for regular use must be listed in the runtime phase. Other requirements should be listed in the earliest stage in which they are required and consumers must accumulate and satisfy requirements across phases before executing the activity. For example, build requirements must also be available during the test phase.

Consumers that install the distribution must ensure that runtime requirements are also installed and may install dependencies from other phases.

0.12.1      < 0.12.2
1.42.0      > 1.41.99
2.0.0       > 1.999.999
2.0.0alpha3 < 2.0.0beta1
2.0.0beta   < 2.0.0