Cookies op Tweakers

Tweakers maakt gebruik van cookies, onder andere om de website te analyseren, het gebruiksgemak te vergroten en advertenties te tonen. Door gebruik te maken van deze website, of door op 'Ga verder' te klikken, geef je toestemming voor het gebruik van cookies. Wil je meer informatie over cookies en hoe ze worden gebruikt, bekijk dan ons cookiebeleid.

Meer informatie

Door , , 1 reactie
Bron: PostgreSQL, submitter: cariolive23

PostgreSQL is een open source relational database management system dat op diverse besturingssystemen kan worden gedraaid. De ontwikkelaars hebben enkele dagen geleden de eerste release candidate van PostgreSQL 9.0 uitgebracht en enkele dagen later ook de eerste alphaversie van PostgreSQL 9.1. De 9.0 tak is voorzien van 64bit-ondersteuning voor het Windows-platform, Python 3-support in PL/Python en conditional per-column triggers. De bijbehorende aankondigingen zien er als volgt uit:

PostgreSQL 9.0 Release Candidate 1

The first release candidate for PostgreSQL 9.0 is now available. Please download and test immediately so that we can move rapidly towards final release. All known bugs should be fixed, so users should promptly report any bugs which they find.

Note that, due to a system catalog change, an initdb and database reload will be required for upgrading from 9.0 beta versions. We encourage users to use this opportunity to test pg_upgrade. Please report your results.

If you are able to help with testing, please see the testing page: http://wiki.postgresql.org/wiki/HowToBetaTest

No changes in commands, interfaces or APIs are expected between this release candidate and the final version. Applications which will deploy on 9.0 can and should test against 9.0rc1. Depending on bug reports, there may or may not be more release candidates before the final release.

Source code, as well as binary installers for many platforms, is available from the PostgreSQL Web Site:
PostgreSQL 9.1alpha1 Now Available

The first alpha release for PostgreSQL version 9.1, 9.1alpha1, is now available. This alpha release contains several new major features added since the 9.0 branch. Please download, install, and test it to give us early feedback on the features being developed for the future versions of PostgreSQL.

Note that the final release of PostgreSQL 9.1 is not to be expected before mid-2011. Please also direct your attention to the imminent release of PostgreSQL 9.0, which is currently in the release candidate stage.

Features added in 9.1alpha1 include:
  • Recognize functional dependency on primary keys, to allow omitting non-primary key columns from the GROUP BY clause in certain situations.
  • Reduce lock levels of CREATE TRIGGER and some ALTER TABLE, CREATE RULE actions.
  • Change the default value of standard_conforming_strings to on. This is a significant incompatibility with previous releases, because it may break unwary applications in security-critical ways.
  • Add vacuum and analyze counters to pg_stat_*_tables views.
  • Several new XML-related functions: xmlexists, xpath_exists, xml_is_well_formed
  • More compact representation of the numeric type.
  • Extend psql's \e and \ef commands so that a line number can be specified, and the editor's cursor will be initially placed on that line.
More detail is available in the release notes.

These new features mean that we need you to participate in testing them. If you are able to help with organized alpha testing, please see the Alpha/Beta testing page.

Alpha releases are not stable and should never be used in production; they are for testing new features only. There is no guarantee that any features or APIs present in the alphas will be present, or the same, in the final release.

Alpha release information page. Download the alpha release here.

Alpha releases are primarily made in source code form only. Binary packages for some operating systems will be prepared in the coming days. PostgreSQL Early Experience One-Click Installers are available here.
Moderatie-faq Wijzig weergave

Reacties (1)

Recognize functional dependency on primary keys, to allow omitting non-primary key columns from the GROUP BY clause in certain situations.
Hier gaan MySQL-gebruikers met mogelijk foute GROUP BY-queries veel plezier aan beleven, alleen de echte bugs worden met de aanpassing nog als bug afgeschoten. Queries met aggregate functies en GROUP BY gaan hiermee een nieuwe dimensie krijgen. Het maakt migreren een stuk eenvoudiger Ún je krijgt de zekerheid dat je queries goed zijn.

Nu alleen nog even een jaartje wachten op de productierelease van versie 9.1... :|

Op dit item kan niet meer gereageerd worden.



Apple iOS 10 Google Pixel Apple iPhone 7 Sony PlayStation VR AMD Radeon RX 480 4GB Battlefield 1 Google Android Nougat Watch Dogs 2

© 1998 - 2016 de Persgroep Online Services B.V. Tweakers vormt samen met o.a. Autotrack en Carsom.nl de Persgroep Online Services B.V. Hosting door True