@@ -12,7 +12,9 @@ Overview
1212
1313 Schemas allow users to create objects in their own namespace
1414 so two people can have the same table with the same name.
15- There is also a public schema for shared tables.
15+ There is also a public schema for shared tables. Table/index
16+ creation can be restricted by removing permissions on the
17+ public schema.
1618
1719 DROP COLUMN
1820
@@ -175,6 +177,7 @@ Allow views to have default values using ALTER COLUMN ... SET DEFAULT (Neil)
175177Fail on INSERTs with column lists that don't supply all column values,
176178 e.g. INSERT INTO tab (col1, col2) VALUES ('val1'); (Rod)
177179Fix for join aliases (Tom)
180+ Fix for FULL OUTER JOINs (Tom)
178181Improve reporting of invalid identifier and location (Tom, Gavin)
179182Fix OPEN cursor(args) (Tom)
180183Allow 'ctid' to be used in a view and currtid(viewname) (Hiroshi)
@@ -214,6 +217,8 @@ Add CREATE/DROP OPERATOR CLASS (Bill Studenmund, Tom)
214217Add ALTER TABLE DROP COLUMN (Christopher)
215218Prevent inherited columns from being removed or renamed (Alvaro Herrera)
216219Add CREATE OR REPLACE VIEW, CREATE OR REPLACE RULE (Gavin, Neil, Tom)
220+ Fix foreign key constraints to not error on intermediate db states (Stephan)
221+ Propagate column or table renaming to foreign key constraints
217222
218223Utility Commands
219224================
@@ -289,6 +294,8 @@ Add current_database() (Rod)
289294Fix cash_words() to not overflow buffer (Tom)
290295Add functions replace(), split(), to_hex() (Joe)
291296Fix LIKE for bytea as a right-hand argument (Joe)
297+ Prevent crashes caused by SELECT cash_out(2)
298+ Triggers are now fired in alphabetical order
292299
293300Internationalization
294301====================
@@ -338,12 +345,14 @@ Add libpq connection timeout parameter (Denis A Ustimenko)
338345
339346JDBC
340347====
341- jdbc compiles with jdk 1.4 (Dave)
348+ Allow jdbc to compile with jdk 1.4 (Dave)
349+ Add jdbc3 support (Barry)
342350Allows jdbc to set loglevel by adding ?loglevel=X to the connection URL (Barry)
343351Add jdbc Driver.info() message that prints out the version number (Barry)
344- Added jdbc updateable result sets
352+ Add jdbc updateable result sets
353+ Add jdbc support for callable statements
354+ Add jdbc query cancel capability
345355Add refresh row to jdbc (Dave)
346- Add jdbc3 support (Barry)
347356Fix jdbc MD5 encryption handling for multibyte servers (Jun Kawai)
348357Add JDBC support for prepared statements (Barry)
349358