Beta2 - A Late Announcement

Morning all ...

Just a quick announcement that 7.3Beta2 is now up and available
for download.

This beta requires a dump/reload from the pervious one, as several
of the fixes touch on the system catalogs.

Changes include, but are not restricted to:

- Change default privileges for languages and functions to be
PUBLIC USAGE and PUBLIC EXECUTE, respectively.

- Add missing correction of sublevelsup when pulling up a
subquery.

- in HeapTupleSelfUpdated case, executor should not return the
tuple as successfully marked, because in fact it's been deleted.

- Disallow VACUUM, ANALYZE, TRUNCATE on temp tables belonging to
other backends.

- Get rid of bogus use of heap_mark4update in reindex operations

- In UpdateStats(), don't bother to update the pg_class row if it
already contains the correct statistics.

- RelationClearRelation must reset rd_targblock and update
rd_nblocks even when dealing with a nailed-in-cache relation

- Replace pg_attribute.attisinherited with attislocal and
attinhcount columns, to allow more correct behavior in
multiple-inheritance cases.

- Bring SIMILAR TO and SUBSTRING into some semblance of
conformance with the SQL99 standard.

- Move most of the error checking for foreign-key constraints out
of parse analysis and into the execution code

- Provide an upgrade strategy for dump files containing functions
declared with OPAQUE.

- Fix PPC s_lock operations to work correctly on multi-CPU
machines.

- Introduce a well-defined promotion hierarchy for
numeric datatypes

- and many many more changes ...

We ask everyone that can to download and test this new beta, and
report any bugs to pgsql-bugs(at)postgresql(dot)org ...

Downloads are available through any PostgreSQL FTP Mirror site.

Thanks ...