Release 7.3.3
PostgreSQL 9.2.24 Documentation | ||||
---|---|---|---|---|
Prev | Up | Appendix E. Release Notes | Next |
Release date: 2003-05-22
This release contains a variety of fixes for version 7.3.2.
E.246.1. Migration to Version 7.3.3
A dump/restore is not required for those running version 7.3.*.
E.246.2. Changes
-
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 timestampt_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-privilege-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 NULL s 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 privilege 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 single-byte encodings (Tatsuo)
-
Allow qualified type names in CREATE CAST and DROP CAST
-
Accept
SETOF type[]
, which formerly had to be writtenSETOF _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