1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
16
HREF="release.html"><LINK
19
HREF="release-6-1.html"><LINK
22
HREF="release-1-09.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
57
HREF="release-6-1.html"
74
>Appendix E. Release Notes</TD
90
HREF="release-1-09.html"
105
>E.189. Release 6.0</A
118
>A dump/restore is required for those wishing to migrate data from
119
previous releases of <SPAN
129
>E.189.1. Migration from version 1.09 to version 6.0</A
132
>This migration requires a complete dump of the 1.09 database and a
133
restore of the database in 6.0.</P
141
>E.189.2. Migration from pre-1.09 to version 6.0</A
144
>Those migrating from earlier 1.* releases should first upgrade to 1.09
145
because the COPY output format was improved from the 1.02 release.</P
157
CLASS="PROGRAMLISTING"
160
ALTER TABLE bug - running postgres process needs to re-read table definition
161
Allow vacuum to be run on one table or entire database(Bruce)
163
Fix array over-runs of memory writes(Kurt)
164
Fix elusive btree range/non-range bug(Dan)
165
Fix for hash indexes on some types like time and date
166
Fix for pg_log size explosion
167
Fix permissions on lo_export()(Bruce)
168
Fix uninitialized reads of memory(Kurt)
169
Fixed ALTER TABLE ... char(3) bug(Bruce)
170
Fixed a few small memory leaks
171
Fixed EXPLAIN handling of options and changed full_path option name
172
Fixed output of group acl privileges
173
Memory leaks (hunt and destroy with tools like Purify(Kurt)
174
Minor improvements to rules system
176
New asserts for run-checking
177
Overhauled parser/analyze code to properly report errors and increase speed
178
Pg_dump -d now handles NULL's properly(Bruce)
179
Prevent SELECT NULL from crashing server (Bruce)
180
Properly report errors when INSERT ... SELECT columns did not match
181
Properly report errors when insert column names were not correct
182
psql \g filename now works(Bruce)
183
psql fixed problem with multiple statements on one line with multiple outputs
184
Removed duplicate system OIDs
185
SELECT * INTO TABLE . GROUP/ORDER BY gives unlink error if table exists(Bruce)
186
Several fixes for queries that crashed the backend
187
Starting quote in insert string errors(Bruce)
188
Submitting an empty query now returns empty status, not just " " query(Bruce)
192
Add EXPLAIN manual page(Bruce)
193
Add UNIQUE index capability(Dan)
194
Add hostname/user level access control rather than just hostname and user
195
Add synonym of != for <>(Bruce)
196
Allow "select oid,* from table"
197
Allow BY,ORDER BY to specify columns by number, or by non-alias table.column(Bruce)
198
Allow COPY from the frontend(Bryan)
199
Allow GROUP BY to use alias column name(Bruce)
200
Allow actual compression, not just reuse on the same page(Vadim)
201
Allow installation-configuration option to auto-add all local users(Bryan)
202
Allow libpq to distinguish between text value '' and null(Bruce)
203
Allow non-postgres users with createdb privs to destroydb's
204
Allow restriction on who can create C functions(Bryan)
205
Allow restriction on who can do backend COPY(Bryan)
206
Can shrink tables, pg_time and pg_log(Vadim & Erich)
207
Change debug level 2 to print queries only, changed debug heading layout(Bruce)
208
Change default decimal constant representation from float4 to float8(Bruce)
209
European date format now set when postmaster is started
210
Execute lowercase function names if not found with exact case
211
Fixes for aggregate/GROUP processing, allow 'select sum(func(x),sum(x+y) from z'
212
Gist now included in the distribution(Marc)
213
Idend authentication of local users(Bryan)
214
Implement BETWEEN qualifier(Bruce)
215
Implement IN qualifier(Bruce)
216
libpq has PQgetisnull()(Bruce)
218
New options to initdb(Bryan)
219
Pg_dump allow dump of OIDs(Bruce)
220
Pg_dump create indexes after tables are loaded for speed(Bruce)
221
Pg_dumpall dumps all databases, and the user table
222
Pginterface additions for NULL values(Bruce)
223
Prevent postmaster from being run as root
224
psql \h and \? is now readable(Bruce)
225
psql allow backslashed, semicolons anywhere on the line(Bruce)
226
psql changed command prompt for lines in query or in quotes(Bruce)
227
psql char(3) now displays as (bp)char in \d output(Bruce)
228
psql return code now more accurate(Bryan?)
229
psql updated help syntax(Bruce)
230
Re-visit and fix vacuum(Vadim)
231
Reduce size of regression diffs, remove timezone name difference(Bruce)
232
Remove compile-time parameters to enable binary distributions(Bryan)
233
Reverse meaning of HBA masks(Bryan)
234
Secure Authentication of local users(Bryan)
235
Speed up vacuum(Vadim)
236
Vacuum now had VERBOSE option(Bruce)
240
All functions now have prototypes that are compared against the calls
241
Allow asserts to be disabled easily from Makefile.global(Bruce)
242
Change oid constants used in code to #define names
243
Decoupled sparc and solaris defines(Kurt)
244
Gcc -Wall compiles cleanly with warnings only from unfixable constructs
245
Major include file reorganization/reduction(Marc)
246
Make now stops on compile failure(Bryan)
247
Makefile restructuring(Bryan, Marc)
248
Merge bsdi_2_1 to bsdi(Bruce)
249
Monitor program removed
250
Name change from Postgres95 to PostgreSQL
251
New config.h file(Marc, Bryan)
252
PG_VERSION now set to 6.0 and used by postmaster
253
Portability additions, including Ultrix, DG/UX, AIX, and Solaris
254
Reduced the number of #define's, centralized #define's
255
Remove duplicate OIDS in system tables(Dan)
256
Remove duplicate system catalog info or report mismatches(Dan)
257
Removed many os-specific #define's
258
Restructured object file generation/location(Bryan, Marc)
259
Restructured port-specific file locations(Bryan, Marc)
260
Unused/uninitialized variables corrected</PRE
269
SUMMARY="Footer navigation table"
280
HREF="release-6-1.html"
298
HREF="release-1-09.html"
b'\\ No newline at end of file'