{full text of release here}

<!-- BEGIN page_title_block -->
PostgreSQL 8.2 Press Kit
<!-- END page_title_block -->

<h1>PostgreSQL 8.2 Press Kit</h1>

<h2>Contents</h2>

<p>
 &nbsp; <a href="#original_release">Text of Original Release</a><br />
 &nbsp; <a href="#additional_features">Additional Features</a><br />
 &nbsp; <a href="#quoted_companies">Quoted Company Information</a><br />
 &nbsp; <a href="#download">Where to Download</a><br />
 &nbsp;	<a href="#docs">Documentation</a><br />
 &nbsp; <a href="#license">License</a><br />
 &nbsp; <a href="#contact">Contacts</a><br />
 &nbsp; <a href="#companies">Corporate Support</a><br />
 &nbsp; <a href="#additional_software">Additional Software</a><br />
 &nbsp; <a href="#translations">Translations</a><br />
</p>

<a name="original_release"></a><h2>Original Press Release</h2>
<p>

</p>

<a name="additional_features"></a><h2>Additional Features in this Release</h2>
As well as the major features listed in the press release, there
are more than 200 new features and enhancements contributed by
dozens of developers for version 8.2. Among them are:
<ul>
<li>Advisory Locks: allow application-level database object control using
PostgreSQL's fast locking engine.</li>
<li>Selective pg_dump: permits drawing transactionally-consistent dumps of
sets of relations, selecting their inclusion/exclusion using regular
expressions.</li>
<li>Prepared Statements: has new administrative interfaces and performance improvements for prepared statements.</li>
<li>ISN/ISBN: this module, containing data types to support ISN product locators for inventory and retail systems, has been upgraded to support the latest international standards.</li>
<li>Cryptography: the pgcrypto module, supporting cryptography inside the database, has been updated with the latest algorithms.</li>
<li>SQL Enhancments: introducing new syntax, including UPDATE RETURNING, DROP IF EXISTS, ON COMMIT and new ownership and permissions commands, to make managing database objects on the command line easier.</li>
<li>PSQL Batch Selection: supports returning rows to the console in batches instead of all at once.</li>
<li>ECPG Refactor: the embedded PostgreSQL C interface has been extensively re-written and new interfaces added.</li>
<li>Major TSearch2 Improvements: UTF-8 support, thesaurus, query rewriting support and GIN indexing.</li>
<li>PL/Python: now supports named parameters and set returning functions.</li>
</ul>
<p>PostgreSQL's extensible architecture has led to a large community of
extensions ranging from additional procedural languages, interfaces
to external systems, new index types, and replication and high
availability tools that are hosted on <a href="http://www.pgfoundry.org">the official PostgreSQL community project site.</a>
Community projects that have made significant advances in the 8.2
release cycle include:</p>
<ul>
<li>Full Disjunctions: thanks to Google Summer of Code, PostgreSQL is the first database system to have an implementation of this radical new join algorithm.</li>
<li>PGPoolII: PGPool, under sponsorship from the Japanese Government, has added new load-balancing and partitioning capabilities</li>
<li>PL/Java: one of our two Java procedural languages has reached full production status, allowing full utilization of Java inside the database.</li>
</ul>

<p>
You can read about the dozens more improvements to 8.2 in
the <a href="/docs/current/static/release.html">Release
Notes.</a>
</p>

<a name="quoted_companies"></a><h2>Full Text of Quotes & Quoted Companies</h2>





<a name="download"></a><h2>Where to Download</h2>

<ul>
<li><a href="/ftp/latest/">List of FTP Mirrors</a></li>
<li><a href="/download/bittorrent">Bittorrent</a></li>
<li><a href="/ftp/binary/v8.2.0/win32/">Windows
Installer</a> (also available via Bittorrent)</li>
<li><a href="/ftp/binary/v8.2.0/">Other Binaries,
including Linux, Mac OSX and Solaris</a></li>
<li><a href="/projects/pgsql/">SourceForge</a> (including
Windows installer)</li>
</ul>

<a name="docs"></a><h2>Documentation</h2>

<ul>
<li><a href="/docs">Official
Documentation</a></li>
<li><a href="/docs/techdocs">TechDocs</a></li>
<li><a href="/about/press/faq">Frequently Asked Questions</a></li>
</ul>

<a name="license"></a><h2>License</h2>
<p>
PostgreSQL uses the <a href="/about/licence">BSD license</a>,
which only requires that the licensed source code maintain its
copyright and licensing information. This
<a href="http://www.opensource.org/licenses/bsd-license.php">OSI-certified
license</a> is widely appreciated as flexible
and business-friendly, since it does not restrict the use
of PostgreSQL with commercial and proprietary applications. Together with
multi-company support and public ownership of the code,
the BSD license makes PostgreSQL very popular with vendors wanting to embed a database in
their own products without fear of fees, vendor lock-in, or changes in licensing terms.
</p>

<a name="contact"></a><h2>Contacts</h2>

<p><a href="http://www.postgresql.org">PostgreSQL home page</a></p>

<p>General Inquiries:<br />
Josh Berkus<br />
PostgreSQL Project<br />
+1-415-752-2500<br />
<a href="mailto:press@postgresql.org">press@postgresql.org</a></p>

<p>For contacts in specific regions, see <a
href="/about/press/contact">our international contact
list.</a></p>

<a name="companies"></a><h2>Corporate Support</h2>

PostgreSQL enjoys the support of numerous companies, who
sponsor developers, provide hosting resources, and give us
financial support.  The largest long-term sponsors are listed
on our <a href="/about/sponsors">development sponsors
page.</a>

There is also a large community of <a
href="/support/professional_support">companies offering
PostgreSQL Support</a>, from individual consultants to
multinational companies.

<a href="/about/donate">Donations</a> glady accepted.

<a name="additional_software"></a><h2>Links</h2>
<p>
The main PostgreSQL project is enhanced by more than 100 active
sub-projects that provide production-quality solutions for
replication, migration, compatibility, interoperability, design
and graphical administration tools.
</p>

<h3>Related Projects</h3>

<ul>
<li><a href="http://projects.postgresql.org">pgFoundry</a></li>
<li><a href="http://gborg.postgresql.org">GBorg</a></li>
</ul>

<h3>Drivers</h3>

<ul>
<li><a href="http://jdbc.postgresql.org/">JDBC</a></li>
<li><a href="http://pgfoundry.org/projects/psqlodbc/">ODBC</a></li>
<li><a href="http://gborg.postgresql.org/project/npgsql/projdisplay.php">.Net</a></li>
<li><a href="http://search.cpan.org/~rudy/DBD-Pg-1.32/Pg.pm">Perl DBI</a></li>
<li><a href="http://initd.org/projects/psycopg1">Python</a></li>
</ul>

<h3>Advanced Feature Packages</h3>

<ul>
<li><a href="http://postgis.refractions.net/">Geographic Information Server (PostGIS)</a></li>
<li><a href="http://openfts.sourceforge.net/">Full Text Search (OpenFTS)</a></li>
<li><a href="http://www.bizgres.org">Business Intelligence/Data Warehousing (Bizgres)</a></li>
</ul>

<h3>Graphical User Interfaces</h3>

<ul>
<li><a href="http://www.pgadmin.org/">pgAdmin III</a></li>
<li><a href="http://phppgadmin.sourceforge.net/">phpPgAdmin</a></li>
<li><a href="/docs/techdocs.54">List of other
GUIs</a></li>
</ul>

<h3>Replication</h3>

<ul>
<li><a href="http://www.slony.info/">Slony-I</a></li>
<li><a href="http://pgfoundry.org/projects/pgpool/">pgPool</a></li>
<li><a href="http://pgfoundry.org/projects/pgcluster/">pgCluster</a></li>
</ul>

<a name="translations"></a><h2>Official Translations of This
Document</h2>

<ul>

<li><a href="/about/press/presskit82.html.ar">Arabic</a></li>

<li><a href="/about/press/presskit82.html.br">Brazillian Portuguese</a></li>

<li><a href="/about/press/presskit82.html.zh_CN">Chinese</a></li>

<li><a href="/about/press/presskit82.html.nl">Dutch</a></li>

<li><a href="/about/press/presskit82.html.fi">Finnish</a></li>

<li><a href="/about/press/presskit82.html.fr">French</a></li>

<li><a href="/about/press/presskit82.html.de">German</a></li>

<li><a href="/about/press/presskit82.html.el">Greek</a></li>

<li><a href="/about/press/presskit82.html.it">Italian</a></li>

<li><a href="/about/press/presskit82.html.ja">Japanese</a></li>

<li><a href="/about/press/presskit82.html.ro">Romanian</a></li>

<li><a href="/about/press/presskit82.html.ru">Russian</a></li>

<li><a href="/about/press/presskit82.html.es">Spanish</a></li>

<li><a href="/about/press/presskit82.html.tr">Turkish</a></li>

</ul>