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 ...