TODO 14 KB
Newer Older
Bruce Momjian's avatar
Bruce Momjian committed
1
TODO list for PostgreSQL
2
========================
Bruce Momjian's avatar
Bruce Momjian committed
3
Last updated:		Fri Jan 19 11:34:02 EST 2001
Marc G. Fournier's avatar
Marc G. Fournier committed
4

Bruce Momjian's avatar
Bruce Momjian committed
5
Current maintainer:	Bruce Momjian (pgman@candle.pha.pa.us)
Marc G. Fournier's avatar
Marc G. Fournier committed
6

Bruce Momjian's avatar
Bruce Momjian committed
7
The most recent version of this document can be viewed at
Bruce Momjian's avatar
Bruce Momjian committed
8
the PostgreSQL web site, http://www.PostgreSQL.org.
Bruce Momjian's avatar
Bruce Momjian committed
9

Bruce Momjian's avatar
Bruce Momjian committed
10
A dash (-) marks changes that will appear in the upcoming 7.1 release.
Bruce Momjian's avatar
Bruce Momjian committed
11

Bruce Momjian's avatar
Bruce Momjian committed
12 13 14
Names in brackets "[]" indicate more detailed information is available in
the directory pgsql/doc/TODO.detail/ under that name.

Bruce Momjian's avatar
Bruce Momjian committed
15

Marc G. Fournier's avatar
Marc G. Fournier committed
16 17
RELIABILITY
-----------
18 19 20 21

PARSER

* SELECT pg_class FROM pg_class generates strange error
Bruce Momjian's avatar
Bruce Momjian committed
22
* Alter TABLE ADD COLUMN does not honor DEFAULT, add CONSTRAINT
Bruce Momjian's avatar
Bruce Momjian committed
23
* -Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME (Thomas)
Bruce Momjian's avatar
Bruce Momjian committed
24
* -SELECT foo UNION SELECT foo is incorrectly simplified to SELECT foo
25 26
* Unique index on base column not honored on inserts from inherited table
  INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail
Bruce Momjian's avatar
Bruce Momjian committed
27
  [inherit] 
Bruce Momjian's avatar
Bruce Momjian committed
28 29
* -Be smarter about promoting types when UNION merges different data types
* -redesign INSERT ... SELECT to have two levels of target list
Bruce Momjian's avatar
Bruce Momjian committed
30 31
* -have INTERSECT/EXCEPT prevent duplicates unless ALL is specified (Tom)
* -SELECT col::DECIMAL(12,10); fails
32 33 34

VIEWS

Bruce Momjian's avatar
Bruce Momjian committed
35
* -Views containing aggregates sometimes fail (Jan)
Bruce Momjian's avatar
Bruce Momjian committed
36
* -Creating view and inheriting the view causes view* to show
Bruce Momjian's avatar
Bruce Momjian committed
37 38
  duplicates (inherit) 
* -Disallow LOCK on view (Mark Hollomon)
Bruce Momjian's avatar
Bruce Momjian committed
39

40 41 42
MISC

* Plpgsql does not handle quoted mixed-case identifiers
Bruce Momjian's avatar
Bruce Momjian committed
43 44
* -Buffer reference counting bugfixes (Tom)
* -Fix libpq bug that causes it to drop backend error message sent
Bruce Momjian's avatar
Bruce Momjian committed
45
  just before connection closure (ie, any FATAL error message)
Bruce Momjian's avatar
Bruce Momjian committed
46 47
* -SELECT ... UNION ... ORDER BY fails when sort expr not in result list
* -SELECT ... UNION ... GROUP BY fails if column types disagree, no type
Bruce Momjian's avatar
Bruce Momjian committed
48
  promotion occurs
Bruce Momjian's avatar
Bruce Momjian committed
49
* -Modification  of  pg_class  can  happen while table in use by
Bruce Momjian's avatar
Bruce Momjian committed
50
  another backend.  Might  lead  to  MVCC  inside  of  syscache
Bruce Momjian's avatar
Bruce Momjian committed
51
* Permission to DELETE table allows UPDATE also
Bruce Momjian's avatar
Bruce Momjian committed
52

Marc G. Fournier's avatar
Marc G. Fournier committed
53 54
ENHANCEMENTS
------------
55 56 57

URGENT

Bruce Momjian's avatar
Bruce Momjian committed
58 59
* -Add OUTER joins, left and right[outer] (Tom, Thomas)
* -Allow long tuples by chaining or auto-storing outside db (TOAST) (Jan)
Bruce Momjian's avatar
Bruce Momjian committed
60
* -Fix memory leak for expressions[memory] (Tom) 
Bruce Momjian's avatar
Bruce Momjian committed
61 62 63 64 65 66 67 68 69
* Add replication of distributed databases [replication]
	o automatic fallover
	o load balancing
	o master/slave replication
	o multi-master replication
	o partition data across servers
	o sample implementation in contrib/rserv
	o queries across databases or servers (two-phase commit)
* Point-in-time data recovery using backup and write-ahead log
Bruce Momjian's avatar
Bruce Momjian committed
70
* Allow row re-use without vacuum (Vadim)
Bruce Momjian's avatar
Bruce Momjian committed
71

72 73
ADMIN

Bruce Momjian's avatar
Bruce Momjian committed
74
* More access control over who can create tables and use locks (Karel)
Bruce Momjian's avatar
Bruce Momjian committed
75
* -Test syslog functionality
Bruce Momjian's avatar
Bruce Momjian committed
76
* Convert remaining fprintf(stderr,...)/perror() to elog()
Bruce Momjian's avatar
Bruce Momjian committed
77 78
* Allow elog() to return error codes, module name, file name, line
  number, not just messages
Bruce Momjian's avatar
Bruce Momjian committed
79
* Allow international error message support and add error codes
Bruce Momjian's avatar
Bruce Momjian committed
80 81
* -Unify configuration into one configuration file (Peter E)
* -use setproctitle() if it exists for 'ps' display of status
Bruce Momjian's avatar
Bruce Momjian committed
82
* -Prevent initdb from running wrong version of postmaster/postgres (Peter E)
Bruce Momjian's avatar
Bruce Momjian committed
83
* Remove unused files during database vacuum or postmaster startup
Bruce Momjian's avatar
Bruce Momjian committed
84

85 86
TYPES

Bruce Momjian's avatar
Bruce Momjian committed
87 88
* Nchar (as distinguished from ordinary varchar),
* Domain capability
Bruce Momjian's avatar
Bruce Momjian committed
89
* -Add STDDEV/VARIANCE() function for standard deviation computation/variance
Bruce Momjian's avatar
Bruce Momjian committed
90 91
* -Allow compression of large fields or a compressed field type
* -Large objects
Bruce Momjian's avatar
Bruce Momjian committed
92
	o -Fix large object mapping scheme, own typeid or reltype (Peter)
Bruce Momjian's avatar
Bruce Momjian committed
93 94 95
	o -Not to stuff everything as files in a single directory, hash dirs
	o -Allow large object vacuuming
	o -Tables that start with xinv confused to be large objects
Bruce Momjian's avatar
Bruce Momjian committed
96
* Add IPv6 capability to INET/CIDR types
Bruce Momjian's avatar
Bruce Momjian committed
97
* -Fix improper masking of some inet/cidr types [cidr]
Bruce Momjian's avatar
Bruce Momjian committed
98
* Add conversion function from text to inet
Bruce Momjian's avatar
Bruce Momjian committed
99 100
* Make a separate SERIAL type?
* Store binary-compatible type information in the system
Bruce Momjian's avatar
Bruce Momjian committed
101
* -Add support for & operator (Peter E)
102
* Allow LOCALE on a per-column basis, default to ASCII
Bruce Momjian's avatar
Bruce Momjian committed
103
* Add SHOW command to see locale
Bruce Momjian's avatar
Bruce Momjian committed
104
* Allow nulls in arrays
Bruce Momjian's avatar
Bruce Momjian committed
105
* Allow arrays to be ORDER'ed
Bruce Momjian's avatar
Bruce Momjian committed
106
* Support construction of array result values in expressions
Bruce Momjian's avatar
Bruce Momjian committed
107 108
* Change foreign key constraint for array -> element to mean element
   in array
109
* Remove Money type, add money formatting for decimal type
110
* Declare typein/out functions in pg_proc with a special "C string" data type
111
* Add non-large-object binary field
Bruce Momjian's avatar
Bruce Momjian committed
112
* Functions returning sets don't really work right[function]
Bruce Momjian's avatar
Bruce Momjian committed
113
* -Add hash for int8 (Tom)
Bruce Momjian's avatar
Bruce Momjian committed
114
* SELECT col FROM tab WHERE numeric_col = 10.1 fails
Bruce Momjian's avatar
Bruce Momjian committed
115
* -Get BIT type working
116
* Allow better handling of numeric constants, type conversion [typeconv]
Bruce Momjian's avatar
Bruce Momjian committed
117
* Support multiple simultaneous character sets, per SQL92
Bruce Momjian's avatar
Bruce Momjian committed
118 119 120
* Reject character sequences those are not valid in their charset
* Make functions more multi-byte aware, i.e. trim()
* Make n of CHAR(n)/VARCHAR(n) the number of letters, not bytes
Bruce Momjian's avatar
Bruce Momjian committed
121
* -Update macaddr manufacturer numbers, or remove the function macaddr_manuf()
Bruce Momjian's avatar
Bruce Momjian committed
122
* Add btree index support for reltime, tinterval, regproc
Bruce Momjian's avatar
Bruce Momjian committed
123
* Add rtree index support for line, lseg, path, point
Bruce Momjian's avatar
Bruce Momjian committed
124
* Make binary/file in/out interface for TOAST columns
Bruce Momjian's avatar
Bruce Momjian committed
125
* SELECT cash_out(2) crashes because of opaque
Bruce Momjian's avatar
Bruce Momjian committed
126
* Add SQL standard function bit_length()
127 128

VIEWS
Bruce Momjian's avatar
Bruce Momjian committed
129

Bruce Momjian's avatar
Bruce Momjian committed
130 131 132
* -Allow DISTINCT on views
* -Allow views of aggregate columns
* -Allow views with subselects
Bruce Momjian's avatar
Bruce Momjian committed
133
* Automatically create rules on views so they are updateable, per SQL92
Bruce Momjian's avatar
Bruce Momjian committed
134
* -Change elog for complex view ins|upd|del to "cannot {ins|upd|del}
Bruce Momjian's avatar
Bruce Momjian committed
135
* Add the functionality for "with check option" clause of create view
Bruce Momjian's avatar
Bruce Momjian committed
136

137
INDEXES
Bruce Momjian's avatar
Bruce Momjian committed
138 139

* Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops)
140
  fails index can't store constant parameters
Bruce Momjian's avatar
Bruce Momjian committed
141
* -Allow SQL function indexes
Bruce Momjian's avatar
Bruce Momjian committed
142
* Add FILLFACTOR to index creation
Bruce Momjian's avatar
Bruce Momjian committed
143
* Re-enable partial indexes
Bruce Momjian's avatar
Bruce Momjian committed
144
* Allow inherited tables to inherit index
145 146

COMMANDS
Bruce Momjian's avatar
Bruce Momjian committed
147

Bruce Momjian's avatar
Bruce Momjian committed
148
* ALTER TABLE ADD COLUMN to inherited table put column in wrong place [inherit]
Bruce Momjian's avatar
Bruce Momjian committed
149
* -Add ALTER TABLE ALTER COLUMN feature (Peter E)
Bruce Momjian's avatar
Bruce Momjian committed
150
* Add ALTER TABLE DROP COLUMN feature [drop]
Bruce Momjian's avatar
Bruce Momjian committed
151
* -Add ALTER TABLE command to change table ownership (Mark H)
Bruce Momjian's avatar
Bruce Momjian committed
152 153
* Add ALTER FUNCTION 
* Add ALTER TABLE ... DROP CONSTRAINT
Bruce Momjian's avatar
Bruce Momjian committed
154
* -Add ALTER USER command to change user db attributes (Peter E)
Bruce Momjian's avatar
Bruce Momjian committed
155
* Automatically drop constraints/functions when object is dropped
Bruce Momjian's avatar
Bruce Momjian committed
156 157
* CLUSTER
	* cluster all tables at once
Bruce Momjian's avatar
Bruce Momjian committed
158
	* prent lose of indexes, permissions, inheritance
Bruce Momjian's avatar
Bruce Momjian committed
159 160 161
	* Automatically keep clustering on a table
	* Keep statistics about clustering, perhaps during VACUUM ANALYZE
	  [optimizer]
Bruce Momjian's avatar
Bruce Momjian committed
162
* Add SIMILAR TO to allow character classes, 'pg_[a-c]%'
Bruce Momjian's avatar
Bruce Momjian committed
163
* Auto-destroy sequence on DROP of table with SERIAL (Ryan)
Bruce Momjian's avatar
Bruce Momjian committed
164
* Allow LOCK TABLE tab1, tab2, tab3 so all tables locked in unison [lock]
Bruce Momjian's avatar
Bruce Momjian committed
165
* Allow INSERT/UPDATE of system-generated oid value for a row
Bruce Momjian's avatar
Bruce Momjian committed
166 167 168 169
* Allow INSERT INTO my_table VALUES (a, b, c, DEFAULT, x, y, z, ...)
* Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)
* -Allow multi-level query trees for INSERT INTO ... SELECT
* -Allow ORDER BY...LIMIT in INSERT INTO ... SELECT (Tom)
Bruce Momjian's avatar
Bruce Momjian committed
170
* -Allow ESCAPE '\' at the end of LIKE for ANSI compliance (Thomas)
Bruce Momjian's avatar
Bruce Momjian committed
171
* -Rewrite the LIKE handling by rewriting the user string with the 
Bruce Momjian's avatar
Bruce Momjian committed
172
  supplied ESCAPE [like]
Bruce Momjian's avatar
Bruce Momjian committed
173
* Allow RULE recompilation
Bruce Momjian's avatar
Bruce Momjian committed
174
* -Support UNION/INTERSECT/EXCEPT in sub-selects
Bruce Momjian's avatar
Bruce Momjian committed
175
* -Allow DELETE and UPDATE to use inheritance
Bruce Momjian's avatar
Bruce Momjian committed
176
* Allow BINARY option to SELECT, like we do with DECLARE
Bruce Momjian's avatar
Bruce Momjian committed
177
* MOVE 0 should not move to end of cursor
Bruce Momjian's avatar
Bruce Momjian committed
178
* Overhaul ACL (access control) code
Bruce Momjian's avatar
Bruce Momjian committed
179
* Add SHOW command to display locks
Bruce Momjian's avatar
Bruce Momjian committed
180

181 182
CLIENTS

Bruce Momjian's avatar
Bruce Momjian committed
183
* Make NULL's come out at the beginning or end depending on the
184
  ORDER BY direction
Bruce Momjian's avatar
Bruce Momjian committed
185 186 187 188
* COPY
	* Update reltuples in COPY
	* Allow specification of column names
	* Allow dump/load of CSV format
Bruce Momjian's avatar
Bruce Momjian committed
189
* fix array handling for ECPG
Bruce Momjian's avatar
Bruce Momjian committed
190
* -add pg_dump option to dump type names as standard ANSI types
Bruce Momjian's avatar
Bruce Momjian committed
191
* -make pg_dump dump in oid order, so dependencies are resolved (Philip)
Bruce Momjian's avatar
Bruce Momjian committed
192
* allow psql \d to show primary and foreign keys
Bruce Momjian's avatar
Bruce Momjian committed
193
* allow psql \d to show temporary table structure
Bruce Momjian's avatar
Bruce Momjian committed
194
* add XML interface capability
Bruce Momjian's avatar
Bruce Momjian committed
195
* -Allow dumping of users/groups separately
Bruce Momjian's avatar
Bruce Momjian committed
196

Bruce Momjian's avatar
Bruce Momjian committed
197 198 199 200 201 202
REFERENTIAL INTEGRITY

* Add MATCH PARTIAL referential integrity
* Check that primary key exists at foreign key definition time
* Prevent column dropping if column is used by foreign key
* Propagate column or table renaming to foreign key constraints
Bruce Momjian's avatar
Bruce Momjian committed
203
* -Emit a warning at foreign key creation time if no UNIQUE index
Bruce Momjian's avatar
Bruce Momjian committed
204
  exists on referenced primary key attributes
Bruce Momjian's avatar
Bruce Momjian committed
205
* Add deferred trigger queue file (Jan)
Bruce Momjian's avatar
Bruce Momjian committed
206
* Allow oid to act as a foreign key
Bruce Momjian's avatar
Bruce Momjian committed
207
* Implement dirty reads and use them in RI triggers
Bruce Momjian's avatar
Bruce Momjian committed
208
* Enforce referential integrity for system tables
Bruce Momjian's avatar
Bruce Momjian committed
209

210 211 212
EXOTIC FEATURES

* Add sql3 recursive unions
Bruce Momjian's avatar
Bruce Momjian committed
213
* Add the concept of dataspaces/tablespaces [tablespaces]
214
* Allow queries across multiple databases
Bruce Momjian's avatar
Bruce Momjian committed
215
* Allow nested transactions (Vadim)
Bruce Momjian's avatar
Bruce Momjian committed
216
* Allow [INSERT/UPDATE] ... RETURNING new.col or old.col (Philip)
Bruce Momjian's avatar
Bruce Momjian committed
217 218
* SQL*Net listener that makes PostgreSQL appear as an Oracle database 
  to clients
Bruce Momjian's avatar
Bruce Momjian committed
219 220
* Incremental backups
* Allow SQL92 schemas
221

Bruce Momjian's avatar
Bruce Momjian committed
222
MISCELLANEOUS
223

Bruce Momjian's avatar
Bruce Momjian committed
224
* Increase identifier length(NAMEDATALEN) if small performance hit
Bruce Momjian's avatar
Bruce Momjian committed
225 226
* Create a background process for each database that runs while
  database is idle, finding superceeded rows, gathering stats and vacuuming
Bruce Momjian's avatar
Bruce Momjian committed
227
* Add UNIQUE capability to non-btree indexes
Bruce Momjian's avatar
Bruce Momjian committed
228
* Certain indexes will not shrink, i.e. oid indexes with many inserts (Vadim)
Bruce Momjian's avatar
Bruce Momjian committed
229 230 231
* Restore unused oid's on backend exit if no one else has gotten oids
* Have UPDATE/DELETE clean out indexes
* Allow cursors to be DECLAREd/OPENed/CLOSEed outside transactions
Bruce Momjian's avatar
Bruce Momjian committed
232
* Allow DELETE WHERE CURRENT OF cursor
Bruce Momjian's avatar
Bruce Momjian committed
233
* -Transaction log, so re-do log can be on a separate disk by
Bruce Momjian's avatar
Bruce Momjian committed
234
  with after-row images (Vadim) [logging]
Bruce Momjian's avatar
Bruce Momjian committed
235 236
* Populate backend status area and write program to dump status data
* Make oid use unsigned int more reliably, pg_atoi()
Bruce Momjian's avatar
Bruce Momjian committed
237
* Put sort files in their own directory
Bruce Momjian's avatar
Bruce Momjian committed
238
* Allow autocommit so always in a transaction block
Bruce Momjian's avatar
Bruce Momjian committed
239
* Show location of syntax error in query [yacc]
Bruce Momjian's avatar
Bruce Momjian committed
240
* -Redesign the function call interface to handle NULLs better[function] (Tom)
Bruce Momjian's avatar
Bruce Momjian committed
241
* Missing optimizer selectivities for date, r-tree, etc. [optimizer]
242
* Overhaul bufmgr/lockmgr/transaction manager
Bruce Momjian's avatar
Bruce Momjian committed
243
* -redesign UNION structures to have separarate target lists
Bruce Momjian's avatar
Bruce Momjian committed
244
* -Use IPC_EXCL when creating shared memory and semaphores (Tom)
Bruce Momjian's avatar
Bruce Momjian committed
245
* Encrpyt passwords in pg_shadow table using MD5 (Vince)
Bruce Momjian's avatar
Bruce Momjian committed
246
* -Use flock() to prevent multiple postmasters on the same port (Tom)
Bruce Momjian's avatar
Bruce Momjian committed
247
* Allow Java server-side programming
Bruce Momjian's avatar
Bruce Momjian committed
248 249 250

PERFORMANCE
-----------
251

Bruce Momjian's avatar
Bruce Momjian committed
252
-FSYNC
253

Bruce Momjian's avatar
Bruce Momjian committed
254 255
* -Allow transaction commits with rollback with no-fsync performance
  (Vadim)
Bruce Momjian's avatar
Bruce Momjian committed
256

257 258
INDEXES

Bruce Momjian's avatar
Bruce Momjian committed
259
* Use indexes to find min() and max()
Bruce Momjian's avatar
Bruce Momjian committed
260
* Use index to restrict rows returned by multi-key index when used with
261
  non-consecutive keys or OR clauses, so fewer heap accesses
Bruce Momjian's avatar
Bruce Momjian committed
262 263
* Allow SELECT * FROM tab WHERE int2col = 4 use int2col index, int8,
  float4, numeric/decimal too [optimizer]
Bruce Momjian's avatar
Bruce Momjian committed
264 265
* -Include heap CTID in btree index keys, remove equal-key cruft from
  btree (Tom)
Bruce Momjian's avatar
Bruce Momjian committed
266
* Use indexes with CIDR '<<' (contains) operator
Bruce Momjian's avatar
Bruce Momjian committed
267
* Allow LIKE indexing optimization for non-ASCII locales
Bruce Momjian's avatar
Bruce Momjian committed
268

269 270
CACHE

Bruce Momjian's avatar
Bruce Momjian committed
271
* Cache most recent query plan(s) (Karel) [prepare]
272
* Shared catalog cache, reduce lseek()'s by caching table size in shared area
Bruce Momjian's avatar
Bruce Momjian committed
273

274 275
MISC

276
* Allow compression of log and meta data
Bruce Momjian's avatar
Bruce Momjian committed
277 278
* Do async I/O to do better read-ahead of data
* Get faster regex() code from Henry Spencer <henry@zoo.utoronto.ca>
279
  when it is available
Bruce Momjian's avatar
Bruce Momjian committed
280
* Use mmap() rather than SYSV shared memory(?)
Bruce Momjian's avatar
Bruce Momjian committed
281
* -Make oid use oidin/oidout not int4in/int4out in pg_type.h (Tom)
Bruce Momjian's avatar
Bruce Momjian committed
282
* Improve Subplan list handling
Bruce Momjian's avatar
Bruce Momjian committed
283
* Allow Subplans to use efficient joins(hash, merge) with upper variable
Bruce Momjian's avatar
Bruce Momjian committed
284
  [subquery]
Bruce Momjian's avatar
Bruce Momjian committed
285
* -use fmgr_info()/fmgr_faddr() instead of fmgr() calls in high-traffic
Bruce Momjian's avatar
Bruce Momjian committed
286 287
  places, like GROUP BY, UNIQUE, index processing, etc.
* improve dynamic memory allocation by introducing tuple-context memory
Bruce Momjian's avatar
Bruce Momjian committed
288
  allocation (Tom)
Bruce Momjian's avatar
Bruce Momjian committed
289
* -In WHERE tab1.x=3 AND tab1.x=tab2.y, add tab2.y=3
Bruce Momjian's avatar
Bruce Momjian committed
290
* allow configuration of maximum number of open files
Bruce Momjian's avatar
Bruce Momjian committed
291
* Remove pg_listener index
292
* Gather more accurate dispersion statistics using indexes
Bruce Momjian's avatar
Bruce Momjian committed
293
* Improve statistics storage in pg_class [performance]
Bruce Momjian's avatar
Bruce Momjian committed
294
* VACUUM
Bruce Momjian's avatar
Bruce Momjian committed
295
	* Improve speed with indexes (perhaps recreate index instead) [vacuum]
Bruce Momjian's avatar
Bruce Momjian committed
296 297 298 299
	* Reduce lock time by moving tuples with read lock, then write
	  lock and truncate table [vacuum]
	* -Redesign ANALYZE in VACUUM so it can be run separately without locks
	* Make ANALYZE a separate command
Bruce Momjian's avatar
Bruce Momjian committed
300
* Add connection pooling [pool]
Bruce Momjian's avatar
Bruce Momjian committed
301
* Allow persistent backends [persistent]
Bruce Momjian's avatar
Bruce Momjian committed
302 303
* Create a transaction processor to aid in persistent connections and
  connection pooling
Bruce Momjian's avatar
Bruce Momjian committed
304 305
* Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM
  ANALYZE, and CLUSTER
Bruce Momjian's avatar
Bruce Momjian committed
306

307 308
SOURCE CODE
-----------
Bruce Momjian's avatar
Bruce Momjian committed
309
* Add use of 'const' for variables in source tree
Bruce Momjian's avatar
Bruce Momjian committed
310
* -Fix C optimizer problem where fmgr_ptr calls return different types (Tom)
Bruce Momjian's avatar
Bruce Momjian committed
311
* Does Mariposa source contain any other bug fixes?
Bruce Momjian's avatar
Bruce Momjian committed
312
* Remove SET KSQO option now that OR processing is improved (Tom)
313
* -Use macros to define NT open() file parameters, remove NT-specific defines
Bruce Momjian's avatar
Bruce Momjian committed
314
* -Change CURRENT to OLD internally for rules (Bruce)
Bruce Momjian's avatar
Bruce Momjian committed
315
* Replace the use of fprint(stderr, ...) with elog() in backend code
Bruce Momjian's avatar
Bruce Momjian committed
316
* -Allow libedit to be used in place of libreadline
Bruce Momjian's avatar
Bruce Momjian committed
317
* -BSD/OS does not support locale because there is no LC_MESSAGES (Bruce)
318

319 320 321 322 323 324 325
---------------------------------------------------------------------------


Developers who have claimed items are:
--------------------------------------
	* Billy is Billy G. Allie <Bill.Allie@mug.org>
	* Brook is Brook Milligan <brook@trillium.NMSU.Edu>
Bruce Momjian's avatar
Bruce Momjian committed
326
	* Bruce is Bruce Momjian<pgman@candle.pha.pa.us>
327 328 329
	* D'Arcy is D'Arcy J.M. Cain <darcy@druid.net>
	* Edmund is Edmund Mergl <E.Mergl@bawue.de>
	* Goran is Goran Thyni <goran@kyla.kiruna.se>
Bruce Momjian's avatar
Bruce Momjian committed
330 331
	* Hiroshi is Hiroshi Inoue <Inoue@tpf.co.jp>
	* Karel is Karel Zak <zakkr@zf.jcu.cz>
332 333
	* Jan is Jan Wieck <wieck@sapserv.debis.de>
 	* Marc is Marc Fournier <scrappy@hub.org>
Bruce Momjian's avatar
Bruce Momjian committed
334
	* Mark is Mark Hollomon <mhh@mindspring.com>
Bruce Momjian's avatar
Bruce Momjian committed
335
	* Massimo is Massimo Dal Zotto <dz@cs.unitn.it>
336 337 338
	* Michael is Michael Meskes <meskes@postgresql.org>
	* Oleg is Oleg Bartunov <oleg@sai.msu.su>
	* Peter is Peter T Mount <peter@retep.org.uk>
Bruce Momjian's avatar
Bruce Momjian committed
339
	* Peter E is Peter Eisentraut<peter_e@gmx.net>
Bruce Momjian's avatar
Bruce Momjian committed
340
	* Philip is Philip Warner <pjw@rhyme.com.au>
Bruce Momjian's avatar
Bruce Momjian committed
341
	* Ross is Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
Bruce Momjian's avatar
Bruce Momjian committed
342
	* Ryan is Ryan Bradetich <rbrad@hpb50023.boi.hp.com>
Bruce Momjian's avatar
Bruce Momjian committed
343
 	* Stephan is Stephan Szabo <sszabo@megazone23.bigpanda.com>
344 345
	* Tatsuo is Tatsuo Ishii <t-ishii@sra.co.jp>
	* Thomas is Thomas Lockhart <lockhart@alumni.caltech.edu>
Bruce Momjian's avatar
Bruce Momjian committed
346
	* Tom is Tom Lane <tgl@sss.pgh.pa.us>
347
	* TomH is Tom I Helbekkmo <tih@Hamartun.Priv.NO>
Bruce Momjian's avatar
Bruce Momjian committed
348
	* Vadim is Vadim B. Mikheev <vadim4o@email.com>