|
1 | 1 | ==================================================== |
2 | 2 | TODO list (FAQ) for PostgreSQL |
3 | 3 | ==================================================== |
4 | | -last updated:Thu Dec 2609:03:38 EST 1996 |
| 4 | +last updated:Thu Dec 2623:45:50 EST 1996 |
5 | 5 |
|
6 | 6 | current maintainer:Bruce Momjian (maillist@candle.pha.pa.us) |
7 | 7 |
|
@@ -160,97 +160,101 @@ Change c.h "Index" and "bool" so they do not conflict with c++ |
160 | 160 | --------------------------------------------------------------------------- |
161 | 161 |
|
162 | 162 | CHANGES IN 6.0 RELEASE |
163 | | - |
164 | | - |
165 | | -Restructured object file generation/location(Bryan, Marc) |
166 | | -Restructured port-specific file locations(Bryan, Marc) |
167 | | -Makefile restructuring(Bryan, Marc) |
168 | | -all functions now have prototypes that are compared against the calls |
169 | | -unused/uninialized variables corrected |
170 | | -gcc -Wall compiles cleanly with warnings only from unfixable constructs |
171 | | -major include file reorganization/reduction(Marc) |
172 | | -reduced the number of #define's, centeralized #define's |
173 | | -removed many os-specific #define's |
174 | | -fixed a few small memory leaks |
175 | | -removed duplicate system oid's |
176 | | -overhauled parser/analyze code to properly report errors and increase speed |
177 | | -properly report errors when INSERT ... SELECT columns did not match |
178 | | -properly report errors when insert column names were not correct |
179 | | -minor improvements to rules system |
180 | | -execute lowercase function names if not found with exact case |
181 | | -change oid constants used in code to #define names |
182 | | -Memory leaks (hunt and destroy with tools like Purify(Kurt) |
183 | | -fix unitialized reads of memory(Kurt) |
184 | | -fix array over-runs of memory writes(Kurt) |
185 | | -Change default decimal constant representation from float4 to float8(Bruce) |
186 | | -Allow libpq to distinguish between text value '' and null(Bruce) |
187 | | -Starting quote in insert string errors(Bruce) |
| 163 | +Bug Fixes |
| 164 | +--------- |
188 | 165 | ALTER TABLE bug - running postgress process needs to re-read table definition |
189 | | -Allow non-postgres users with createdb privs to destroydb's |
190 | | -Prevent SELECT NULL from crashing server (Bruce) |
| 166 | +Allow vacuum to be run on one table or entire database(Bruce) |
| 167 | +Array fixes |
| 168 | +Fix array over-runs of memory writes(Kurt) |
191 | 169 | Fix elusive btree range/non-range bug(Dan) |
192 | | -Remove duplicate system catalog info or report mismatches(Dan) |
193 | | -Remove duplicate OIDS in system tables(Dan) |
194 | | -Prevent postmaster from being run as root |
195 | | -Implement IN qualifier(Bruce) |
196 | | -Implement BETWEEN qualifier(Bruce) |
197 | | -add synonym of != for <>(Bruce) |
198 | | -add UNIQUE index capability(Dan) |
199 | | -Re-visit and fix vacuum(Vadim) |
200 | | -speed up vacuum(Vadim) |
201 | | -can't shrink tables, pg_time and pg_log(Vadim & Erich) |
202 | | -allow actual compression, not just reuse on the same page(Vadim) |
203 | | -allow vacuum to be run on one table or entire database(Bruce) |
204 | | -Reverse meaning of HBA masks(Bryan) |
| 170 | +Fix for hash indexes on some types like time and date |
| 171 | +Fix for pg_log size explosion |
| 172 | +Fix permissions on lo_export()(Bruce) |
| 173 | +Fix unitialized reads of memory(Kurt) |
| 174 | +Fixed ALTER TABLE ... char(3) bug(Bruce) |
| 175 | +Fixed a few small memory leaks |
| 176 | +Fixed output of group acl permissions |
| 177 | +Memory leaks (hunt and destroy with tools like Purify(Kurt) |
| 178 | +Minor improvements to rules system |
| 179 | +NOTIFY fixes |
| 180 | +New asserts for run-checking |
| 181 | +Overhauled parser/analyze code to properly report errors and increase speed |
| 182 | +Pg_dump -d now handles NULL's properly(Bruce) |
| 183 | +Prevent SELECT NULL from crashing server (Bruce) |
| 184 | +Properly report errors when INSERT ... SELECT columns did not match |
| 185 | +Properly report errors when insert column names were not correct |
| 186 | +Psql \g filename now works(Bruce) |
| 187 | +Psql fixed problem with multiple statements on one line with multiple outputs |
| 188 | +Removed duplicate system oid's |
| 189 | +Several fixes for queries that crashed the backend |
| 190 | +Starting quote in insert string errors(Bruce) |
| 191 | +Submiting an empty query now returns empty status, not just " " query(Bruce) |
| 192 | + |
| 193 | +Enhancements |
| 194 | +------------ |
| 195 | +Add UNIQUE index capability(Dan) |
205 | 196 | Add hostname/user level access control rather than just hostname and user |
206 | | -Allow restriction on who can create C functions(Bryan) |
| 197 | +Add synonym of != for <>(Bruce) |
| 198 | +Allow "select oid,* from table" |
| 199 | +Allow BY,ORDER BY to specify columns by number, or by non-alias table.column(Bruce) |
| 200 | +Allow COPY from the frontend(Bryan) |
| 201 | +Allow GROUP BY to use alias column name(Bruce) |
| 202 | +Allow actual compression, not just reuse on the same page(Vadim) |
207 | 203 | Allow installation-configuration option to auto-add all local users(Bryan) |
| 204 | +Allow libpq to distinguish between text value '' and null(Bruce) |
| 205 | +Allow non-postgres users with createdb privs to destroydb's |
| 206 | +Allow restriction on who can create C functions(Bryan) |
208 | 207 | Allow restriction on who can do backend COPY(Bryan) |
209 | | -allow COPY from the frontend(Bryan) |
210 | | -Secure Authentication of local users(Bryan) |
211 | | -Idend authentication of local users(Bryan) |
| 208 | +Can shrink tables, pg_time and pg_log(Vadim & Erich) |
212 | 209 | Change debug level 2 to print queries only, changed debug heading layout(Bruce) |
| 210 | +Change default decimal constant representation from float4 to float8(Bruce) |
| 211 | +Execute lowercase function names if not found with exact case |
| 212 | +Fixes for aggregate/GROUP processing, allow 'select sum(func(x),sum(x+y) from z' |
| 213 | +Gist now included in the distrubution(Marc) |
| 214 | +Idend authentication of local users(Bryan) |
| 215 | +Implement BETWEEN qualifier(Bruce) |
| 216 | +Implement IN qualifier(Bruce) |
| 217 | +Libpq has PQgetisnull()(Bruce) |
| 218 | +Libpq++ improvements |
| 219 | +New options to initdb(Bryan) |
| 220 | +Pg_dump allow dump of oid's(Bruce) |
| 221 | +Pg_dump create indexes after tables are loaded for speed(Bruce) |
| 222 | +Pg_dump(Bruce) |
| 223 | +Pginterface additions for NULL values(Bruce) |
| 224 | +Prevent postmaster from being run as root |
| 225 | +Psql \h and \? is now readable(Bruce) |
| 226 | +Psql allow backslashed, semicolons anywhere on the line(Bruce) |
| 227 | +Psql changed command prompt for lines in query or in quotes(Bruce) |
| 228 | +Psql char(3) now displays as (bp)char in \d output(Bruce) |
| 229 | +Psql return code now more accurate(Bryan?) |
| 230 | +Psql updated help syntax(Bruce) |
| 231 | +Re-visit and fix vacuum(Vadim) |
213 | 232 | Reduce size of regression diffs, remove timezone name difference(Bruce) |
214 | 233 | Remove compile-time parameters to enable binary distributions(Bryan) |
215 | | -Merge bsdi_2_1 to bsdi(Bruce) |
216 | | -pg_dump(Bruce) |
217 | | -allow dump of oid's |
218 | | -create indexes after tables are loaded for speed |
219 | | -pg_dump -d now handles NULL's properly |
220 | | -psql(Bruce) |
221 | | -fixed problem with multiple statements on one line with multiple outputs |
222 | | -changed command prompt for lines in query or in quotes |
223 | | -allow backslashed, semicolons anywhere on the line |
224 | | -\h and \? is now readable |
225 | | -\g filename now works |
226 | | -updated help syntax |
227 | | -char(3) now displays as (bp)char in \d output |
228 | | -return code now more accurate(Bryan?) |
229 | | -new config.h file(Marc, Bryan) |
230 | | -fix permissions on lo_export()(Bruce) |
| 234 | +Reverse meaning of HBA masks(Bryan) |
| 235 | +Secure Authentication of local users(Bryan) |
| 236 | +Speed up vacuum(Vadim) |
| 237 | + |
| 238 | +Source tree changes |
| 239 | +------------------- |
| 240 | +All functions now have prototypes that are compared against the calls |
| 241 | +Allow asserts to be disabled easly 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) |
231 | 246 | Make now stops on compile failure(Bryan) |
232 | | -submiting an empty query now returns empty status, not just " " query(Bruce) |
233 | | -several fixes for queries that crashed the backend |
234 | | -portability additions, including Ultrix, DG/UX, AIX, and Solaris |
235 | | -fix for pg_log size explosion |
236 | | -decoupled sparc and solaris defines(Kurt) |
237 | | -new options to initdb(Bryan) |
238 | | -allow asserts to be disabled easly from Makefile.global(Bruce) |
239 | | -allow "select oid,* from table" |
240 | | -NOTIFY fixes |
| 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) |
241 | 252 | PG_VERSION now set to 6.0 and used by postmaster |
242 | | -libpq has PQgetisnull()(Bruce) |
243 | | -pginterface additions for NULL values(Bruce) |
244 | | -fixed ALTER TABLE ... char(3) bug(Bruce) |
245 | | -fixed output of group acl permissions |
246 | | -new asserts for run-checking |
247 | | -name change from Postgres95 to PostgreSQL |
248 | | -monitor program removed |
249 | | -fix for hash indexes on some types like time and date |
250 | | -gist now included in the distrubution(Marc) |
251 | | -array fixes |
252 | | -fixes for aggregate/GROUP processing, allow 'select sum(func(x),sum(x+y) from z' |
253 | | -libpq++ improvements |
254 | | -Allow BY,ORDER BY to specify columns by number, or by non-alias table.column(Bruce) |
255 | | -Allow GROUP BY to use alias column name(Bruce) |
256 | | - |
| 253 | +Portability additions, including Ultrix, DG/UX, AIX, and Solaris |
| 254 | +Reduced the number of #define's, centeralized #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/uninialized variables corrected |