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@postgresql.org ...

    Downloads are available through any PostgreSQL FTP Mirror site.

Thanks ...