summaryrefslogtreecommitdiffstats
path: root/database/postgresql/DETAILS
blob: 9413ac71e4dac00eab9376724bee00bd9cfbd2d5 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
           SPELL=postgresql
         VERSION=9.2.2
     SOURCE_HASH=sha512:147690b168838b7d45cc805882cb6ef628cbf656ff115d32ab76c4ad38b06aa00223f728bf0e5befcdd27cc4e27a917493d857f1f29006952f0ff07da6615808
          SOURCE=$SPELL-$VERSION.tar.bz2
SOURCE_DIRECTORY="$BUILD_DIRECTORY/$SPELL-$VERSION"
   SOURCE_URL[0]=ftp://ftp.postgresql.org/pub/source/v$VERSION/$SOURCE
   SOURCE_URL[1]=ftp://ftp10.us.postgresql.org/pub/$SPELL/source/v$VERSION/$SOURCE
   SOURCE_URL[2]=ftp://ftp9.de.postgresql.org/unix/databases/postgresql/source/v${VERSION}/${SOURCE}

if [[ $PGSQL_CLUSTER == y ]]; then
 CLUSTER_VERSION=1.9.0rc5
         SOURCE2=pgcluster-$CLUSTER_VERSION-patch.tar.gz
  SOURCE2_URL[0]=http://pgfoundry.org/frs/download.php/1706/$SOURCE2
    SOURCE2_HASH=sha512:df328505fee683051642850bade5932595184d3af8db6d47663d8c6e5fec5dc62256390ead83a2fa719efe212f8a44350f57cb4f1361bde63b2227e5cc13e927
fi

        WEB_SITE=http://www.postgresql.org/
     GATHER_DOCS=off
  SECURITY_PATCH=12
         ENTERED=20011113
      LICENSE[0]=BSD
        KEYWORDS="database"
           SHORT="sophisticated Object-Relational DBMS"
cat << EOF
PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL
constructs, including subselects, transactions and user defined types and
functions. A point list for some technical features that PostgreSQL offers:
* Fully ACID compliant
* ANSI SQL compliant
* Referential Integrity
* Replication (non-commercial and commercial solutions)
* Native interfaces for ODBC, JDBC, C, C++, PHP, Perl, TCL, ECPG, Python, Ruby
* Rules, Views, Triggers, Outer Joins, Sub-selects, Sequences, Stored Procedures
* Support for UNION, UNION ALL and EXCEPT queries
* Unicode
* Inheritance
* An open API
* Native SSL support, Native Kerberos authentication
* Better than row-level locking, Functional and Partial indexes
* Loadable extensions offering SHA1, MD5, XML, and other functionality
* Tools for generating portable SQL to share with other SQL-compliant systems
* Extensible data type system
* Cross-database compatibility functions
EOF