- 30 11月, 2003 5 次提交
-
-
由 Bruce Momjian 提交于
> * Have pg_ctl look at PGHOST in case it is a socket directory
-
由 Bruce Momjian 提交于
> * Make LENGTH() of CHAR() not count trailing spaces >
-
由 Bruce Momjian 提交于
< * Allow clients to query WITH HOLD cursors and prepared statements > * Allow clients to query a list of WITH HOLD cursors and prepared statements
-
由 Bruce Momjian 提交于
< manuals (Rory) > manuals 496c496 < * Jan is Jan Wieck <JanWieck@Yahoo.com> of PeerDirect Corp. > * Jan is Jan Wieck <JanWieck@Yahoo.com> of Afilias, Inc.
-
由 PostgreSQL Daemon 提交于
make sure the $Id tags are converted to $PostgreSQL as well ...
-
- 20 11月, 2003 2 次提交
-
-
由 Bruce Momjian 提交于
< A dash (-) marks changes that will appear in the upcoming 7.4 release. > A dash (-) marks changes that will appear in the upcoming 7.5 release. 437c437 < * Use background process to write dirty shared buffers to disk > * -Use background process to write dirty shared buffers to disk
-
由 Bruce Momjian 提交于
< * -Allow elog() to return error codes, module name, file name, line < number, not just messages (Tom) < * -Add error codes (Tom) < * -Make error messages more consistent 40d35 < * -Add GUC log_statement_and_duration to print statement and >= min duration 51d45 < * -Allow easy display of usernames in a group 53d46 < * -Add start time to pg_stat_activity 55d47 < * -Have standalone backend read postgresql.conf (Tom) 59d50 < * -Allow CIDR format to be used in pg_hba.conf 74d64 < * -Add IPv6 capability to INET/CIDR types 77d66 < * -Change NUMERIC data type to use base 10,000 internally 82d70 < * -Add GUC variables to control floating number output digits (Pedro Ferreira) 90,92d77 < * -Allow current datestyle to restrict dates; prevent month/day swapping < from making invalid dates valid < * -Prevent month/day swapping of ISO dates to make invalid dates valid 102d86 < o -Allow arrays to be ORDER'ed 104d87 < o -Support construction of array result values in expressions (Joe) 128d110 < * -Remove Cyrillic recode support 146,147d127 < * -Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops) < fails index can't store constant parameters 155d134 < * -Add btree index support for reltime, tinterval, regproc (Tom) 157d135 < * -Certain indexes will not shrink, e.g. indexes on ever-increasing 161d138 < * -Allow LIKE indexing optimization for non-ASCII locales using special index 173d149 < * -Improve concurrency of hash indexes (Tom) 181d156 < * -Allow LIMIT/OFFSET to use expressions (Tom) 187d161 < * -Return proper effected tuple count from complex commands [return] 191d164 < * -Make a transaction-safe TRUNCATE (Rod) 196,197d168 < * -Allow UPDATE to use SET col = DEFAULT < * -Add config variable to prevent auto-adding missing FROM-clause tables 199d169 < * -Have SELECT '13 minutes'::interval display zero seconds in ISO datestyle 224,225d193 < o -Add ALTER TABLE tab SET WITHOUT OIDS (Rod) < o -Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values 237d204 < o -Allow CLUSTER to cluster all tables (Alvaro Herrera) 248d214 < o -MOVE 0 should not move to end of cursor (Bruce) 252d217 < o -Allow cursors outside transactions 264,265d228 < o -Allow EXPLAIN EXECUTE to see prepared plans < o -Allow SHOW of some non-modifiable variables, like pg_controldata 280d242 < o -Allow array declarations and other data types in PL/PgSQL DECLARE 282,283d243 < o -Make PL/PgSQL %TYPE schema-aware < o -Allow PL/PgSQL to support array element assignment (Joe) 294,298d253 < * -Allow psql to show transaction status if backend protocol changes made < * -Add schema, cast, and conversion backslash commands to psql (Christopher) < * -Allow pg_dump to dump a specific schema (Neil Conway) < * -Allow psql to do table completion for SELECT * FROM schema_part and < table completion for SELECT * FROM schema_name. 300,302d254 < * -Allow SSL-enabled clients to turn off SSL transfers < * -Modify pg_get_triggerdef() to take a boolean to pretty-print, < and use that as part of pg_dump along with psql 327d278 < o -Add SQLSTATE 330d280 < o -Make casts work in variable initializations 334,336d283 < o -Allow multi-threaded use of SQLCA < o -Understand structure definitions outside a declare section < o -Allow :var[:index] or :var[<integer>] as cvariable for an array var 356d302 < * -Support statement-level triggers (Neil) 460,461d405 < * -Add checkpoint_min_warning postgresql.conf option to warn about checkpoints < that are too frequent (Bruce) 472,476d415 < * -Improve Subplan list handling < * -Allow Subplans to use efficient joins(hash, merge) with upper variable < * -Add hash for evaluating GROUP BY aggregates (Tom) < * -Allow merge and hash joins on expressions not just simple variables (Tom) < * -Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom) 480d418 < * -Inline simple SQL functions to avoid overhead (Tom) 495d432 < * -Get faster regex() code from Henry Spencer <henry@zoo.utoronto.ca> 511,512d447 < * -Modify regression tests to prevent failures do to minor numeric rounding < * -Add OpenBSD's getpeereid() call for local socket authentication 537,542d471 < o -Show transaction status in psql < o -Allow binding of query parameters, support for prepared queries < o -Remove hard-coded limits on user/db/password names < o -Remove unused elements of startup packet (unused, tty, passlength) < o -Fix COPY/fastpath protocol < o -Error codes 544d472 < o -Special passing of binary values in platform-neutral format (bytea?) 547d474 < o -Report server version number, database encoding, client encoding
-
- 17 11月, 2003 2 次提交
-
-
由 Bruce Momjian 提交于
> * Add GUC setting to make created tables default to WITHOUT OIDS
-
由 Bruce Momjian 提交于
< o --Add ALTER TABLE tab SET WITHOUT OIDS (Rod) > o -Add ALTER TABLE tab SET WITHOUT OIDS (Rod)
-
- 12 11月, 2003 2 次提交
-
-
由 Bruce Momjian 提交于
> * Ignore temporary tables from other session when processing inheritance
-
由 Bruce Momjian 提交于
> * Add free-behind capability for large sequential scans (fadvise)
-
- 09 11月, 2003 3 次提交
-
-
由 Bruce Momjian 提交于
> * Have psql '\i ~/<tab><tab>' actually load files it displays from home dir
-
由 Bruce Momjian 提交于
> * Have psql \dn show only visible schemas using current_schemas()
-
由 Bruce Momjian 提交于
> * Use more reliable method for CREATE DATABASE to get a consistent copy of db >
-
- 07 11月, 2003 1 次提交
-
-
由 Bruce Momjian 提交于
> * Allow CREATE TABLE foo (f1 INT CHECK (f1 > 0) CHECK (f1 < 10)) to work > by searching for non-conflicting constraint names, and prefix with table name
-
- 26 10月, 2003 3 次提交
-
-
由 Bruce Momjian 提交于
> * Change LIMIT/OFFSET to use int8
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> * Allow more ISOLATION LEVELS to be accepted, but issue a warning for them
-
- 24 10月, 2003 2 次提交
-
-
由 Bruce Momjian 提交于
< o Queries across databases or servers (two-phase commit) [2phase] > o Queries across databases or servers (two-phase commit)
-
由 Bruce Momjian 提交于
> o Queries across databases or servers (two-phase commit) [2phase]
-
- 23 10月, 2003 1 次提交
-
-
由 Bruce Momjian 提交于
> * Allow functions to have a search path specified at creation time
-
- 21 10月, 2003 3 次提交
-
-
由 Bruce Momjian 提交于
< o Allow BINARY option to SELECT, just like DECLARE
-
由 Bruce Momjian 提交于
< * Allow INET subnet tests to use indexes > * Allow INET subnet tests using non-constants to be indexed
-
由 Bruce Momjian 提交于
< * Allow INET subnet tests using non-constants > * Allow INET subnet tests to use indexes 101a102 > o Allow MIN()/MAX() on arrays 144c145 < * Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops) > * -Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops) 166c167 < * Improve handling of index scans for NULL > * Allow use of indexes to search for NULLs 203a205 > * Add optional textual message to NOTIFY 252c254 < o Add SET SCHEMA > o Add SET PATH for schemas 297a300 > * Allow fastpast to pass values in portable format 344a348 > * Allow statement-level triggers to access modified rows 526d529 < o Add optional textual message to NOTIFY 530d532 < o Allow fastpast to pass values in portable format 533c535 < o Special passing of binary values in platform-neutral format (bytea?) > o -Special passing of binary values in platform-neutral format (bytea?)
-
- 16 10月, 2003 1 次提交
-
-
由 Bruce Momjian 提交于
> * Allow pg_dump to dump CREATE CONVERSION (Christopher)
-
- 10 10月, 2003 4 次提交
-
-
由 Bruce Momjian 提交于
> * Prevent libpq's PQfnumber() from lowercasing the column name 572d572 < * Vadim is Vadim B. Mikheev <vadim4o@email.com> of Sector Data
-
由 Bruce Momjian 提交于
> to allow fast COUNT(*) queries with no WHERE clause(?) [count]
-
由 Bruce Momjian 提交于
> o Allow PL/pgSQL to handle %TYPE arrays, e.g. tab.col%TYPE[]
-
由 Bruce Momjian 提交于
> * Have VACUUM FULL use REINDEX rather than index vacuum
-
- 09 10月, 2003 5 次提交
-
-
由 Bruce Momjian 提交于
> * COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT | LANGUAGE ] > (Christopher)
-
由 Bruce Momjian 提交于
> * COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT ] (Christopher)
-
由 Bruce Momjian 提交于
< 346a346 > * Remove CREATE CONSTRAINT TRIGGER
-
由 Bruce Momjian 提交于
< o Sample implementation in contrib/rserv 29c28,29 < * Create native Win32 port [win32] > * Create native Win32 port, http://momjian.postgresql.org/main/writings/pgsql/win32.html > 367c367,368 < * Two-phase commit to implement distributed transactions > * Add two-phase commit to all distributed transactions with > offline/readonly server status or administrator notification for failure
-
由 Bruce Momjian 提交于
> * Use background process to write dirty shared buffers to disk
-
- 05 10月, 2003 1 次提交
-
-
由 Bruce Momjian 提交于
< * Consider using MVCC to cache count(*) queries with no WHERE clause > * Use a fixed row count and a +/- count with MVCC visibility rules > to allow fast COUNT(*) queries with no WHERE clause(?)
-
- 30 9月, 2003 3 次提交
-
-
由 Bruce Momjian 提交于
< o Fixed PL/Tcl's spi_prepare to accept full qualified type names in < the parameter type list
-
由 Bruce Momjian 提交于
> o Fixed PL/Tcl's spi_prepare to accept full qualified type names in > the parameter type list
-
由 Bruce Momjian 提交于
> * Have SHOW ALL and pg_settings show descriptions for server-side variables(Joe)
-
- 24 9月, 2003 2 次提交
-
-
由 Bruce Momjian 提交于
> * Allow LISTEN/NOTIFY to store info in memory rather than tables
-
由 Bruce Momjian 提交于
* Allow major upgrades without dump/reload, perhaps using pg_upgrade
-