E.246. Release 7.3.3 #
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
UPDATEdoesn't change foreign key's value (Jan)Use
-fPICnot-fpicon 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
CHECKPOINTdoes not cause database panic on failure in noncritical stepsAccept 60 in seconds fields of timestamp, time, interval input values
Issue notice, not error, if
TIMESTAMP,TIME, orINTERVALprecision too largeFix
abstime-to-timecast 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'::timestamptzgave wrong answer if timezone changed earlier in transactionHAVE_INT64_TIMESTAMPcode for time with timezone overwrote its inputAccept
GLOBAL TEMP/TEMPORARYas a synonym forTEMPORARYAvoid improper schema-privilege-check failure in foreign-key triggers
Fix bugs in foreign-key triggers for
SET DEFAULTactionFix incorrect time-qual check in row fetch for
UPDATEandDELETEtriggersForeign-key clauses were parsed but ignored in
ALTER TABLE ADD COLUMNFix 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 estimationAvoid conflict with system definition of
isblank()function or macroFix failure to convert large code point values in EUC_TW conversions (Tatsuo)
Fix error recovery for
SSL_read/SSL_writecallsDon'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 errorGROUP BYgot confused if there were multiple equal GROUP BY itemsFix bad plan when inherited
UPDATE/DELETEreferences another inherited tablePrevent 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 fastafter Async_NotifyHandler runsFix 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
EXCEPTinCREATE RULEPrevent 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 CASTandDROP CASTAccept
SETOF type[], which formerly had to be writtenSETOF _typeFix 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
elogcommand 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 JDBCFixed 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