Software-update: PostgreSQL 7.3.3

Op de site van PostgreSQL vinden we sinds vandaag een nieuwe versie van dit databaseprogramma. Deze software is onder andere bekend vanwege de uitstekende ondersteuning van de SQL standaard. De belangrijkste wijzigingen voor versie 7.3.3 zijn:

Schemas
Schemas allow users to create objects in separate namespaces,
so two people or applications can have tables with the same
name. There is also a public schema for shared tables.
Table/index creation can be restricted by removing permissions
on the public schema.

Drop Column
PostgreSQL now supports the ALTER TABLE ... DROP COLUMN
functionality.

Table Functions
Functions returning multiple rows and/or multiple columns are
now much easier to use than before. You can call such a "table
function" in the SELECT FROM clause, treating its output like a
table. Also, PL/pgSQL functions can now return sets.

Prepared Queries
PostgreSQL now supports prepared queries, for improved
performance.

Dependency Tracking
PostgreSQL now records object dependencies, which allows
improvements in many areas. "DROP" statements now take either
CASCADE or RESTRICT to control whether dependent objects are
also dropped.

Privileges
Functions and procedural languages now have privileges, and
functions can be defined to run with the privileges of their
creator.

Internationalization
Both multibyte and locale support are now always enabled.

Logging
A variety of logging options have been enhanced.

Interfaces
A large number of interfaces have been moved to
http://gborg.postgresql.org where they can be developed and
released independently.

Functions/Identifiers
By default, functions can now take up to 32 parameters, and
identifiers can be up to 63 bytes long. Also, OPAQUE is now
deprecated: there are specific "pseudo-datatypes" to represent
each of the former meanings of OPAQUE in function argument and
result types.

Versienummer	7.3.3
Besturingssystemen	Linux, BSD, Linux x86
Website	PostgreSQL
Download	ftp://ftp.postgresql.org/pub/sources/v7.3.3/postgresql-7.3.3.tar.gz
Bestandsgrootte	10,95MB
Licentietype	Voorwaarden (GNU/BSD/etc.)

Reacties (9)

[djazete]

Ik ben sinds kort aan het kijken naar de mogelijkheden van PostgresSQL sinds mysql mij toch te beknopt begon te worden.
Ik heb de 7.2.x branche maar geinstalleerd.. Is het raadzaam om toch deze 7.3.x branche te installen (en compilen) op een niet productie omgeving..?

[mOrPhie]

Echt noemenswaardige bugs zijn er niet opgelost. De keuze om van 7.3.3 gebruik te gaan maken ligt em puur bij of je de features dermate interessant vind, dat je die wilt hebben.

Qua performance en security issues zal het bij plain SQL weinig schelen waarschijnlijk.

De enige reden, maar wel een belangrijke, om 7.3.3 te gaan gebruiken, zou voor mij Prepared Queries zijn. Dat scheelt performance maar biedt ook gewoon meer mogelijkheden op functioneel gebied

[jochemd]

Het grote voordeel van 7.3.x over 7.2.x is volgens mij schema's. In combinatie met permissies en een slim search_path kunnen multi-user databases een stuk makkelijker te overzien worden.

[shlammod]

link is dood

edit:
link doet t nu wel... vreemd

[jp]

Dat een link dood is vlak na een nieuwe release is niet zo gek. Je hebt een boel mensen die het direct op de testmachines willen installeren.

(Of direct op productieservers als ze stalen zenuwen hebben )

[Renegade]

Klopt, de FTP server is momenteel behoorlijk druk. Toen ik zelf de link testte voordat ik dit bericht postte haalde ik niet meer dan 5 Kb/sec, maar de meeste mirrors waren nog niet up to date.

De link is dus niet dood, je zult het alleen een aantal keren moeten proberen voordat je erdoor komt

[jp]

Alleen jammer dat er nog geen free replication tools zijn waarbij je je database kan laten draaien, of dmv een trigger ook de data naar een secundaire database kan sturen.

[ACM]

Geloof dat ze er wel zijn.

Kijk oa es op http://gborg.postgresql.org, maar hoe stable dit is?

Het staat iig geplanned en heeft een hoge prio of het met 7.4 al meegeleverd kan gaan worden is nog niet echt bekend verder.

[roderickvd]

Bovenstaande changes zijn niet die van deze minor revisie, maar van de 7.3 major revisie. Veranderingen sinds 7.3.3:

Repair sometimes-incorrect computation of StartUpID after a crash
Avoid slowness with lots of deferred triggers in one transaction (Stephan)
Don't lock referenced row when UPDATE doesn't change foreign key's value
(Jan)
Use -fPIC not -fpic on Sparc (Tom Callaway)
Repair lack of schema-awareness in contrib/reindexdb
Fix contrib/intarray error for zero-element result array (Teodor)
Ensure createuser script will exit on control-C (Oliver)
Fix errors when the type of a dropped column has itself been dropped
CHECKPOINT does not cause database panic on failure in noncritical steps
Accept 60 in seconds fields of timestamp, time, interval input values
Issue notice, not error, if TIMESTAMP, TIME, or INTERVAL precision too
large
Fix abstime-to-time cast function (fix is not applied unless you initdb)
Fix pg_proc entry for timestamptz_izone (fix is not applied unless you
initdb)
Make EXTRACT(EPOCH FROM timestamp without time zone) treat input as
local time
'now'::timestamptz gave wrong answer if timezone changed earlier in
transaction
HAVE_INT64_TIMESTAMP code for time with timezone overwrote its input
Accept GLOBAL TEMP/TEMPORARY as a synonym for TEMPORARY
Avoid improper schema-permissions-check failure in foreign-key triggers
Fix bugs in foreign-key triggers for SET DEFAULT action
Fix incorrect time-qual check in row fetch for UPDATE and DELETE triggers
Foreign-key clauses were parsed but ignored in ALTER TABLE ADD COLUMN
Fix createlang script breakage for case where handler function already
exists
Fix misbehavior on zero-column tables in pg_dump, COPY, ANALYZE, other
places
Fix misbehavior of func_error() on type names containing '%'
Fix misbehavior of replace() on strings containing '%'
Regular-expression patterns containing certain multibyte characters failed
Account correctly for NULLs in more cases in join size estimation
Avoid conflict with system definition of isblank() function or macro
Fix failure to convert large code point values in EUC_TW conversions
(Tatsuo)
Fix error recovery for SSL_read/SSL_write calls
Don't do early constant-folding of type coercion expressions
Validate page header fields immediately after reading in any page
Repair incorrect check for ungrouped variables in unnamed joins
Fix buffer overrun in to_ascii (Guido Notari)
contrib/ltree fixes (Teodor)
Fix core dump in deadlock detection on machines where char is unsigned
Avoid running out of buffers in many-way indexscan (bug introduced in 7.3)
Fix planner's selectivity estimation functions to handle domains properly
Fix dbmirror memory-allocation bug (Steven Singer)
Prevent infinite loop in ln(numeric) due to roundoff error.
GROUP BY got confused if there were multiple equal GROUP BY items
Fix bad plan when inherited UPDATE/DELETE references another inherited
table
Prevent clustering on incomplete (partial or non-NULL-storing) indexes
Service shutdown request at proper time if it arrives while still
starting up
Fix left-links in temporary indexes (could make backwards scans miss
entries)
Fix incorrect handling of client_encoding setting in postgresql.conf
(Tatsuo)
Fix failure to respond to 'pg_ctl stop -m fast' after Async_NotifyHandler
runs
Fix SPI for case where rule contains multiple statements of the same type
Fix problem with checking for wrong type of access permission in rule query
Fix problem with EXCEPT in CREATE RULE
Prevent problem with dropping temp tables having serial columns
Fix replace_vars_with_subplan_refs failure in complex views
Fix regexp slowness in multibyte encodings (Tatsuo)
Allow qualified type names in CREATE CAST and DROP CAST
Accept 'SETOF type[]', which formerly had to be written 'SETOF _type'
Fix pg_dump core dump in some cases with procedural languages
Force ISO datestyle in pg_dump output, for portability (Oliver)
pg_dump failed to handle error return from lo_read (Oleg Drokin)
pg_dumpall failed with groups having no members (Nick Eskelinen)
pg_dumpall failed to recognize --globals-only switch
pg_restore failed to restore blobs if -X disable-triggers is specified
Repair intrafunction memory leak in plpgsql
pltcl's elog command dumped core if given wrong parameters (Ian Harding)
plpython used wrong value of atttypmod (Brad McLean)
Fix improper quoting of boolean values in Python interface (D'Arcy)
Added addDataType() method to PGConnection interface for JDBC
Fixed various problems with updateable ResultSets for JDBC (Shawn Green)
Fixed various problems with DatabaseMetaData for JDBC (Kris Jurka,
Peter Royal)
Fixed problem with parsing table ACLs in JDBC
Better error message for character set conversion problems in JDBC