Re: Release changes
От | Larry Rosenman |
---|---|
Тема | Re: Release changes |
Дата | |
Msg-id | 71670000.1060094509@lerlaptop-red.iadfw.net обсуждение исходный текст |
Ответ на | Re: Release changes (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-hackers |
--On Tuesday, August 05, 2003 10:36:32 -0400 Bruce Momjian <pgman@candle.pha.pa.us> wrote: > > Oh, yes. Let me add that. I didn't realize that was a change of enough > significance. > > How is this? > > Prevent timestamp from supressing ':00' seconds display Yes, considering that it's a format change and Tom didn't want to back port because it is a format change/behavior change. Thanks! LER > > > ------------------------------------------------------------------------- > -- > > Larry Rosenman wrote: >> No, the one where we always print hh:mm:ss for an interval, even if >> seconds is zero. >> >> >> >> --On Tuesday, August 05, 2003 01:03:57 -0400 Bruce Momjian >> <pgman@candle.pha.pa.us> wrote: >> >> > >> > I don't know about that item. There is a menion of allowing 60 seconds >> > --- is that it? >> > >> > ---------------------------------------------------------------------- >> > --- -- >> > >> > Larry Rosenman wrote: >> >> What about the interval change in ISO datestyle for zero seconds? >> >> >> >> LER >> >> >> >> >> >> --On Sunday, August 03, 2003 19:30:26 -0400 Bruce Momjian >> >> <pgman@candle.pha.pa.us> wrote: >> >> >> >> > >> >> > Here are the changes for 7.4. I am looking for any improvements. >> >> > This will be adjusted as we move through beta. >> >> > >> >> > I need to work on the other sections of a major release, like a >> >> > compatibility section. >> >> > >> >> > ------------------------------------------------------------------- >> >> > --- --- -- >> >> > >> >> > Release Notes >> >> > >> >> > 7.4 Development Branch >> >> > >> >> > >> >> > Valid as of 2003-08-01. Update release.sgml later. >> >> > >> >> > >> >> > Server Operation >> >> > >> >> > Allow IPv6 server connections (Nigel Kukard, Johan Jordaan, Bruce, >> >> > Tom, Kurt Roeckx, Andrew Dunstan) >> >> > Fix SSL to handle errors cleanly (Nathan Mueller) >> >> > SSL protocol security and performance improvements (Sean Chittenden) >> >> > Print lock information when a deadlock is detected (Tom) >> >> > Update /tmp socket files regularly to avoid their removal (Tom) >> >> > Enable PAM for MAC OS X (Aaron Hillegass) >> >> > Make btree indexes fully WAL-safe (Tom) >> >> > Allow btree index compaction and empty page reuse (Tom) >> >> > Fix inconsistent index lookups during split of first root page (Tom) >> >> > Improve free space map allocation logic (Tom) >> >> > Preserve free space information between postmaster restarts (Tom) >> >> > Set proper schema permissions in initdb (Peter) >> >> > Add start time to pg_stat_activity (Neil) >> >> > New code to detect corrupt disk pages; erase with >> >> > zero_damaged_pages (Tom) New client/server protocol: faster, no >> >> > username length limit, allow clean exit >> >> > Add transaction status, tableid, columnid to backend protocol (Tom) >> >> > Add new binary I/O protocol (Tom) >> >> > Remove autocommit server setting; move to client applications (Tom) >> >> > New error message wording, error codes, and three levels of error >> >> > detail (Tom) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Performance >> >> > >> >> > Add hashing for GROUP BY aggregates (Tom) >> >> > Allow nested loops to be smarter about multicolumn indexes (Tom) >> >> > Allow multi-key hash joins (Tom) >> >> > Improve constant folding (Tom) >> >> > Add ability to inline simple SQL functions (Tom) >> >> > Reduce memory usage for queries using complex functions (Tom) >> >> > Improve GEQO optimizer performance (Tom) >> >> > Allow IN/NOT IN to be handled via hash tables (Tom) >> >> > Improve NOT IN (subquery) performance (Tom) >> >> > Allow most IN subqueries to be processed as joins (Tom) >> >> > Improve reverse index scan performance (Tom) >> >> > Improve optimizer cost computations, particularly for subqueries >> >> > (Tom) Assume WHERE a.x = b.y and b.y = 42 also means a.x = 42 (Tom) >> >> > Allow hash/merge joins on complex joins (Tom) >> >> > Allow hash joins for more data types (Tom) >> >> > Allow join optimization of ANSI joins, disable with >> >> > join_collapse_limit (Tom) Add from_collapse_limit to control >> >> > conversion of subqueries to joins (Tom) Use faster regex code from >> >> > TCL (Henry Spencer, Tom) Use bit-mapped relation sets in the >> >> > optimizer (Tom) >> >> > Improve backend startup time (Tom) >> >> > Improve trigger/constraint performance (Stephan) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Server Configuration >> >> > >> >> > Rename server parameter server_min_messages to log_min_messages >> >> > (Bruce) Rename show_*_stats to log_*_stats (Bruce) >> >> > Rename show_source_port to log_source_port (Bruce) >> >> > Rename hostname_lookup to log_hostname (Bruce) >> >> > Add checkpoint_warning to warn of excessive checkpointing (Bruce) >> >> > Allow the postmaster to preload libraries using preload_libraries >> >> > (Joe) New read-only server parameters for localization (Tom) >> >> > Change debug server log messages to output as DEBUG rather than LOG >> >> > (Bruce) Prevent server log variables from being turned off by >> >> > non-super users (Bruce) log_min_messages/client_min_messages now >> >> > controls debug_* output (Bruce) Add Rendezvous server support >> >> > (Chris Campbell) Add ability to print only slow statements using >> >> > log_min_duration_statement (Christopher) >> >> > Allow pg_hba.conf to accept netmasks in CIDR format (Andrew Dunstan) >> >> > New is_superuser read-only variable (Tom) >> >> > New server-side parameter log_error_verbosity to control error >> >> > detail (Tom) postgres --help-config now dumps server config >> >> > variables (Tom) Make default shared_buffers 1000 and >> >> > max_connections 100, if possible (Tom) Add pg_settings table to see >> >> > server settings (Joe) >> >> > Prevent assign_session_authorization() from being confused by >> >> > all-numeric user names (Tom) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Queries >> >> > >> >> > New SQL-standard information schema (Peter) >> >> > Add read-only transactions (Peter) >> >> > Add server variable regex_flavor to control regular expression >> >> > processing (Tom) >> >> > Allow ORDER BY in FROM subqueries to be honored by outer queries >> >> > (Tom) Print key name in foreign-key violation messages (Dmitry >> >> > Tkach) Allow users to see their own queries in pg_stat_activity >> >> > (Kevin Brown) Allow subquery aggregates to reference upper query >> >> > columns (?) (Tom) Add option to prevent auto-addition of tables >> >> > referenced in query (Nigel J. Andrews) >> >> > Allow dollar signs in identifiers, except as first character (Tom) >> >> > Allow UPDATE ... SET col = DEFAULT (Rod) >> >> > Allow expressions to be used in LIMIT/OFFSET (Tom) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Object Manipulation >> >> > >> >> > Make CREATE SEQUENCE grammar more SQL1999 standards compliant (Neil) >> >> > Add FOR EACH STATEMENT statement-level triggers (Neil Conway) >> >> > Add DOMAIN CHECK constraints (Rod) >> >> > Add ALTER DOMAIN .. SET / DROP NOT NULL, SET / DROP DEFAULT, ADD / >> >> > DROP CONSTRAINT (Rod) >> >> > Allow zero-column tables (Tom) >> >> > Have ALTER TABLE ... ADD PRIMARY KEY add NOT NULL constraint (Rod) >> >> > Add ALTER DOMAIN OWNER (Rod) >> >> > Add pg_trigger.tgenabled to disable triggers? (Neil) >> >> > Add ALTER TABLE ... WITHOUT OIDS? (Rod) >> >> > Have parser honor foreign-key constraints if created via ALTER TABLE >> >> > ADD COLUMN? (Tom) >> >> > Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values >> >> > (Rod) Add ALTER TABLE ... CLUSTER ON (Alvaro Herrera) >> >> > Improve DOMAIN automatic type casting (Tom) >> >> > Disallow dollar signs in operator names (Tom) >> >> > Allow SQL200X inheritance syntax LIKE <subtable>, INCLUDING >> >> > DEFAULTS? (Rod) Object owners can allow grantees to grant privilege >> >> > to others? >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Utility Commands >> >> > >> >> > Add ON COMMIT PRESERVE ROWS for temp tables (Gavin) >> >> > Allow cursors outside transactions using WITH HOLD (Neil) >> >> > Make MOVE/FETCH 0 actually move/fetch 0 (Bruce) >> >> > Add MOVE ALL to move to end of cursor (Bruce) >> >> > Cause FETCH 1 to return the current cursor row, or zero if at >> >> > beginning/end of cursor, per SQL spec (Bruce) >> >> > Have MOVE return 0 or 1 depending on cursor position (Bruce) >> >> > Properly handle SCROLL with cursors, or report an error (Tom) >> >> > Implement SQL92-compatible FIRST, LAST, ABSOLUTE n, RELATIVE n >> >> > options for FETCH and MOVE (Tom) >> >> > Allow EXPLAIN on DECLARE CURSOR (Tom) >> >> > Allow CLUSTER to use index marked as pre-clustered by default >> >> > (Alvaro Herrera) Allow CLUSTER without tablename clusters all >> >> > tables (Alvaro Herrera) Prevent CLUSTER on partial indexes (Tom) >> >> > Allow \r and \r\n termination for COPY files (Bruce) >> >> > Disallow literal carriage return as a data value, >> >> > backslash-carriage-return and \r still allowed (Bruce) >> >> > COPY changes (binary, \.)? (Tom) >> >> > Recover from COPY IN/OUT failure cleanly (Tom) >> >> > Reduce memory used by COPY (Tom) >> >> > Make TRUNCATE transaction-safe (Rod) >> >> > Multiple pg_dump fixes, including tar format and large objects >> >> > Allow pg_dump to dump specific schemas (Neil) >> >> > Allow pg_dump to preserve column storage characteristics >> >> > (Christopher) Allow pg_dump to preserve CLUSTER characteristics >> >> > (Christopher) Have pg_dumpall use GRANT/REVOKE to dump >> >> > database-level permissions (Tom) Allow pg_dumpall to support the >> >> > -a, -s, -x options of pg_dump (Tom) Prevent pg_dump from >> >> > lowercasing identifiers specified on the command line (Tom) Allow >> >> > EXPLAIN EXECUTE (Neil) >> >> > Allow pg_get_constraintdef() to support UNIQUE, PRIMARY KEY and >> >> > CHECK constraints (Christopher) >> >> > Improve VACUUM performance on indexes by reducing WAL traffic (Tom) >> >> > Allow pg_ctl to better handle non-standard ports (Greg) >> >> > Functional indexes now support indexes on column expressions (Tom) >> >> > Syntax errors now reported as 'syntax error' rather than 'parse >> >> > error' (Tom) Have SHOW TRANSACTION_ISOLATION match input to SET >> >> > TRANSACTION_ISOLATION (Tom) Have COMMENT ON DATABASE on non-local >> >> > database generate a warning (Tom) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Data Types and Functions >> >> > >> >> > New extra_float_digits server parameter to control float precision >> >> > display (Pedro Ferreira, Tom) >> >> > Allow +1300 as a numeric timezone specifier, for FJST (Tom) >> >> > Remove rarely used oidrand(), oidsrand(), and userfntest() functions >> >> > (Neil) Add md5() function to main server, already in >> >> > /contrib/pgcrypto (Joe) Increase date range of timestamp (John >> >> > Cochran) >> >> > Change EXTRACT(EPOCH FROM timestamp) so timestamp without time zone >> >> > is assumed to be in local time, not GMT (Tom) >> >> > Trap division by zero in case the operating system doesn't prevent >> >> > it (Tom) Change the NUMERIC data type internally to base 10000 (Tom) >> >> > New hostmast() function (Greg Wickham) >> >> > Fixes for to_char() (Karel) >> >> > Allow functions that can take any argument data type and return >> >> > any data type, using ANYELEMENT and ANYARRAY (Joe) >> >> > Arrays may now be specified as ARRAY[1,2,3], >> >> > ARRAY[['a','b'],['c','d']], or ARRAY[ARRAY[ARRAY[2]]] (Joe) >> >> > Allow proper comparisons for arrays (Joe) >> >> > Allow indexes on array columns, and used in ORDER BY and DISTINCT >> >> > (Joe) Allow WHERE qualifications of the form 'col IN/ANY/SOME/ALL >> >> > (array) (?) (Joe) Allow SQL functions to return arrays and take >> >> > them as params (Joe) Allow array concatenation with '||' and normal >> >> > array comparisons (Joe) New array functions array_append(), >> >> > array_cat(), array_lower(), array_prepend(), array_to_string(), >> >> > array_upper(), string_to_array() (Joe) Allow assignments to empty >> >> > arrays (Joe) >> >> > Allow 60 in seconds fields of timestamp, time, interval input values >> >> > (Tom) Allow PREPARE/bind of utility commands like FETCH and EXPLAIN >> >> > (Tom) Allow CIDR data type to be cast to text (Tom) >> >> > Allow the creation of special LIKE indexes for non-C locales (Peter) >> >> > Disallow invalid timezone names (Tom) >> >> > Trim trailing spaces when CHAR() data is cast to VARCHAR or TEXT >> >> > (Tom) Make FLOAT(p) measure the precision p in bits, not decimal >> >> > digits (Tom) Add IPv6 support to the inet and cidr data types >> >> > (Michael Graff) Add family() function to report whether address is >> >> > IPv4 or IPv6 (Michael Graff) Have SHOW DATESTYLE generate output >> >> > similar to that used by SET DATESTYLE (Tom) Change DATESTYLE to >> >> > output its value in a more common format (Tom) Make >> >> > EXTRACT(TIMEZONE) and SET/SHOW TIMEZONE follow the SQL convention >> >> > for the sign of timezone offsets, ie, positive is east from UTC >> >> > (Tom) Fix date_trunc('quarter',...) (B?jthe Zolt?n) >> >> > Make initcap() more compatible with Oracle (Mike Nolan) >> >> > Honor only DateStyle setting for date entry without a four-digit >> >> > year (Greg) Add new DateStyle values MDY, DMY, and YMD, honor US and >> >> > European for backward compatibility (Tom) >> >> > 'now' will no longer work as a default, use now() (change required >> >> > for prepared statements) (Tom) >> >> > Assume NaN value to be larger than any other value in comparisons >> >> > (Tom) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Server-side Languages >> >> > >> >> > Prevent PL/pgSQL crash when RETURN NEXT is used on a zero-row record >> >> > (Tom) Make PL/python's spi_execute interface handle NULLs properly >> >> > (Andrew Bosma) Allow PL/pgSQL to declare variables of composite >> >> > types without %ROWTYPE (Tom) Fix PL/python _quote() function to >> >> > handle big integers (?) Make PL/python an untrusted language, now >> >> > called plpythonu (Kevin Jacobs, Tom) Change PL/pgSQL EXECUTE INTO >> >> > to CREATE TABLE AS EXECUTE? (Peter) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Psql >> >> > >> >> > Add "\pset pager always" to always use pager (Greg) >> >> > Improve tab completion (Rod, Ross Reedstrom, Ian Barwick) >> >> > Reorder \? help into groupings (Harald Armin Massa, Bruce) >> >> > Add schema, cast, and conversion backslash commands (Christopher) >> >> > \encoding now tracks client_encoding server variable (Tom) >> >> > Save edit history into readline history (Ross) >> >> > Improve \d display (Christopher) >> >> > Enhance HTML mode to be more standards-compliant (Greg) >> >> > New '\set autocommit off' capability (Tom) >> >> > New '\set verbosity' to control error detail (Tom) >> >> > New %T prompt string to show transaction status (Tom) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Libpq >> >> > >> >> > Allow PQcmdTuples() to return row counts for MOVE and FETCH (Neil) >> >> > Add PQfreemem() for freeing memory on Win32, suggest for NOTIFY >> >> > (Bruce) Document service capability, and add sample file (Bruce) >> >> > Make PQsetdbLogin() have the same defaults as PQconnectdb() (Tom) >> >> > Allow libpq to cleanly fail when result sets are too large (Tom) >> >> > Improve performance of PGunescapeBytea() (Ben Lamb) >> >> > Allow threaded with --enable-thread-safety (Lee Kindness, Bruce) >> >> > Allow pqInternalNotice() to accept a format string and args instead >> >> > of just a preformatted message (Tom, Sean Chittenden) >> >> > Allow control SSL negotiation with sslmode values "disable", >> >> > "allow", "Prefer", and "require" (Jon Jensen) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > JDBC >> >> > >> >> > Allow setNull on updateable resultsets >> >> > Allow executeBatch on a prepared statement (Barry) >> >> > Support SSL connections (Barry) >> >> > Handle schema names in result sets (Paul Sorenson) >> >> > Add refcursor support (Nic Ferrier) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Miscellaneous Interfaces >> >> > >> >> > Prevent possible memory leak or core dump during libpgtcl shutdown >> >> > (Tom) Add ecpg Informix compatibility (Michael) >> >> > Add ecpg DECIMAL type that is fixed length, for Informix (Michael) >> >> > Allow threaded ecpg with --enable-thread-safety (Lee Kindness, >> >> > Bruce) Allow client interfaces to compile under MinGW/win32 (Bruce) >> >> > Move python client interface to http://www.pygresql.org (Marc) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Source Code >> >> > >> >> > Prevent need for separate platform geometry regression result files >> >> > (Tom) Improved PPC locking primitive (Reinhard Max) >> >> > Embed LD_LIBRARY_PATH used for build process into binaries (Billy) >> >> > New palloc0 to allocate and clear memory (Bruce) >> >> > Fix locking code for s390x CPU (64-bit) (Tom) >> >> > Allow OpenBSD to use local indent credentials (William Ahern) >> >> > Allow read-only query plans (Tom) >> >> > Add Darwin startup scripts (David Wheeler) >> >> > Allow libpq to compile with Borland C++ compiler (Lester Godwin, >> >> > Karl Waclawek) Use our own version of getopt_long() if needed >> >> > (Peter) Convert administration scripts to C (Peter) >> >> > Bison >=1.85 is now required for grammar changes >> >> > Merge documentation into one book (Peter) >> >> > Add Win32 compatibility functions (Bruce) >> >> > New ereport() function for error reporting (Tom) >> >> > Support Intel Linux compiler (Peter) >> >> > Improve Linux startup scripts (Slawomir Sudnik, Darko Prenosil) >> >> > Add support for AMD Opteron and Itanium (Jeffrey W. Baker, Bruce) >> >> > >> >> > ______________________________________________________________ >> >> > ___ >> >> > >> >> > Contrib >> >> > >> >> > Change dbmirror license to BSD >> >> > Improve earthdistance (Bruno Wolff III) >> >> > Portability improvements to pgcrypto (Marko Kreen) >> >> > Prevent xml crash (John Gray, Michael Richards) >> >> > Upgrade oracle >> >> > Upgrade mysql >> >> > Update cube (Bruno Wolff III) >> >> > Update earthdistance to use cube (Bruno Wolff III) >> >> > Update btree_gist (Oleg) >> >> > Add hashes to tablefuncs (Joe) >> >> > New pg_autovacuum allows automatic VACUUM (Matthew T. O'Connor) >> >> > Allow pgbench to honor PGHOST, PGPORT, PGUSER env. variables >> >> > (Tatsuo) Improve intarray (Teodor Sigaev) >> >> > Improve pgstattuple (Rod) >> >> > Fix second argument to metaphone() in fullystrmatch >> >> > Add named persistent connections to dblink (Shridhar Daithanka) >> >> > Improve adddepend (Rod) >> >> > Update spi/timetravel (B?jthe Zolt?n) >> >> > Fix dbase -s option (Thomas Behr) >> >> >> >> >> >> >> >> -- >> >> Larry Rosenman http://www.lerctr.org/~ler >> >> Phone: +1 972-414-9812 E-Mail: ler@lerctr.org >> >> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 >> >> >> >> >> >> -- >> Larry Rosenman http://www.lerctr.org/~ler >> Phone: +1 972-414-9812 E-Mail: ler@lerctr.org >> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 3: if posting/reading through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org so that your >> message can get through to the mailing list cleanly -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
В списке pgsql-hackers по дате отправления: