Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit8dd0573

Browse files
committed
Update HISTORY for 7.4.
Neil Conway
1 parentfb72fc8 commit8dd0573

File tree

1 file changed

+34
-26
lines changed

1 file changed

+34
-26
lines changed

‎HISTORY

Lines changed: 34 additions & 26 deletions
Original file line numberDiff line numberDiff line change
@@ -15,38 +15,43 @@ Valid as of 2003-09-28. Update release.sgml later.
1515
Major changes in this release:
1616

1717
IPv6
18-
Full support for IPv6 connections and IPv6 data types.
18+
Full support for IPv6 connections and IPv6addressdata types
1919

2020
SSL
21-
MajorSSLimprovements in performance and security.
21+
Major improvements inSSLperformance and security
2222

2323
Index Growth Prevention
2424
Allow free space map to efficiently reused empty index pages,
25-
and other free space improvements.
25+
and other free space management improvements.
26+
27+
Standards Compliance
28+
Implement information schema
29+
Support for read-only transactions
30+
Make cursors comply more closely with the SQL standard
2631

2732
New Client/Server Communication Protocol
28-
New protocol improves connection speed/reliability, and adds
29-
error codes, status information, a binary protocol, error
30-
reporting verbosity, and cleaner startup packets.
33+
New protocol improves connection speed/reliability, and adds
34+
error codes, status information, a binary protocol, error
35+
reporting verbosity, and cleaner startup packets.
3136

3237
Performance
33-
IN/NOT IN subqueries now perform as efficiently as joins
34-
Improved GROUP BYprocesing by usinghack buckets
35-
Hash indexes now have better concurrency/reliability/performance
36-
New multi-key hash join capability
37-
ANSI joins are now fully optimized
38-
Faster regular expression code
38+
IN/NOT IN subqueries now perform as efficiently as joins
39+
Improved GROUP BYprocessing by usinghash buckets
40+
New multi-key hash join capability
41+
ANSI joins are now fully optimized
42+
Faster regular expression code
43+
Function-inlining for simple SQL functions
3944

40-
Cursors
41-
Allow cursors to exist outside transactions
45+
HoldableCursors
46+
Allow cursors to exist outside transactions
4247

4348
Threads
44-
libpq and ecpg are now fully thread-safe with --enable-thread-safety
49+
libpq and ecpg are now fully thread-safe with --enable-thread-safety
4550

4651
Contrib
47-
New version of full text indexing (tsearch2)
48-
New autovacuum tool
49-
Array handling has been improved and moved into the main server
52+
New version of full text indexing (tsearch2)
53+
New autovacuum tool
54+
Array handling has been improved and moved into the main server
5055

5156
_________________________________________________________________
5257

@@ -58,18 +63,21 @@ Valid as of 2003-09-28. Update release.sgml later.
5863
Observe the following incompatibilities:
5964
* The server-side autocommit setting was removed an reimplemented
6065
in client applications and languages.
61-
* Error message wording has changeddramtically in this release,
66+
* Error message wording has changeddramatically in this release,
6267
and error codes have been added.
6368
* ANSI joins may behave differently because they are now fully optimized
6469
* A number of server variables have been renamed for clarity
6570
* MOVE/FETCH 0 now does nothing; return value of MOVE/FETCH 1/0
6671
varies based on the current offset in the cursor
67-
* COPY now can process carriage-return/line-feed andcarraige-return
72+
* COPY now can process carriage-return/line-feed andcarriage-return
6873
terminated files. Literal carriage-returns and line-feeds are no
6974
longer accepted as data values; use \r and \n instead.
70-
* Auto-trim spaces when converting from CHAR() to VARCHAR()/TEXT
75+
* Trailing spaces are now trimmed when converting from CHAR(n) to
76+
VARCHAR(n)/TEXT
7177
* FLOAT(p) now measures 'p' in bits, not digits
7278
* Date values now must match the ordering specified by DateStyle
79+
* The oidrand(), oidsrand(), and userfntest() functions have been
80+
removed.
7381

7482
_________________________________________________________________
7583

@@ -177,14 +185,14 @@ Change EXECUTE INTO to CREATE TABLE AS EXECUTE (Peter)
177185
Object Manipulation
178186

179187
Make CREATE SEQUENCE grammar more SQL1999 standards compliant (Neil)
180-
Add FOR EACH STATEMENT statement-level triggers (Neil Conway)
188+
Add FOR EACH STATEMENT statement-level triggers (Neil)
181189
Add DOMAIN CHECK constraints (Rod)
182190
Add ALTER DOMAIN .. SET / DROP NOT NULL, SET / DROP DEFAULT, ADD / DROP
183191
CONSTRAINT (Rod)
184192
Fix several zero-column table bugs (Tom)
185193
Have ALTER TABLE ... ADD PRIMARY KEY add NOT NULL constraint (Rod)
186194
Add ALTER DOMAIN OWNER (Rod)
187-
Add ALTER TABLE ... WITHOUT OIDS? (Rod)
195+
Add ALTER TABLE ... WITHOUT OIDS (Rod)
188196
Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values (Rod)
189197
Add ALTER TABLE ... CLUSTER ON (Alvaro Herrera)
190198
Improve DOMAIN automatic type casting (Rod, Tom)
@@ -225,7 +233,7 @@ Have pg_dumpall use GRANT/REVOKE to dump database-level permissions (Tom)
225233
Allow pg_dumpall to support the -a, -s, -x options of pg_dump (Tom)
226234
Prevent pg_dump from lowercasing identifiers specified on the command line (Tom)
227235
Allow PREPARE/bind of utility commands like FETCH and EXPLAIN (Tom)
228-
Allow EXPLAIN EXECUTE (Neil)
236+
Add EXPLAIN EXECUTE (Neil)
229237
Allow pg_get_constraintdef() to support UNIQUE, PRIMARY KEY and
230238
CHECK constraints (Christopher)
231239
Improve VACUUM performance on indexes by reducing WAL traffic (Tom)
@@ -235,7 +243,7 @@ Syntax errors now reported as 'syntax error' rather than 'parse error' (Tom)
235243
Have SHOW TRANSACTION_ISOLATION match input to SET TRANSACTION_ISOLATION (Tom)
236244
Have COMMENT ON DATABASE on non-local database generate a warning (Rod)
237245
Improve reliability of LISTEN/NOTIFY (Tom)
238-
Allow REINDEX toreliabily reindexall indexes, except global ones (Tom)
246+
Allow REINDEX toreliably reindexnon-shared system catalog indexes (Tom)
239247
pg_dump --use-set-session-authorization and --no-reconnect now do nothing,
240248
all dumps use SET SESSION AUTHORIZATION
241249

@@ -289,7 +297,7 @@ Add new DateStyle values MDY, DMY, and YMD, honor US and European for
289297
'now' will no longer work as a column default, use now() (change required for
290298
prepared statements) (Tom)
291299
Assume NaN value to be larger than any other value in MIN()/MAX() (Tom)
292-
Prevent interval fromsupressing ':00' seconds display
300+
Prevent interval fromsuppressing ':00' seconds display
293301
New pg_get_triggerdef(prettyprint) and pg_constraint_is_visible() functions
294302
Allow time to be specified as '040506' or '0405' (Tom)
295303

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp