Skip to content

Commit 90e0b66

Browse files
bmomjianbmomjian
committed
Update TODO list.
1 parent fc955b1 commit 90e0b66

File tree

2 files changed

+106
-12
lines changed

2 files changed

+106
-12
lines changed

‎doc/TODO

Lines changed: 12 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
TODO list for PostgreSQL
22
========================
3-
Last updated: Sat Nov 6 11:54:11 EST 1999
3+
Last updated: Mon Nov 22 13:02:03 EST 1999
44

55
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
66

@@ -25,7 +25,7 @@ RESOURCES
2525
PARSER
2626

2727
* Disallow inherited columns with the same name as new columns
28-
* INSERT INTO ... SELECT with AS columns matching result columns problem
28+
* -INSERT INTO ... SELECT with AS columns matching result columns problem
2929
* SELECT pg_class FROM pg_class generates strange error
3030
* Alter TABLE ADD COLUMN does not honor DEFAULT, add CONSTRAINT
3131
* Do not allow bpchar column creation without length
@@ -36,21 +36,21 @@ PARSER
3636
* SELECT foo UNION SELECT foo is incorrectly simplified to SELECT foo
3737
* -INSERT ... SELECT ... GROUP BY groups by target columns not source columns(Tom)
3838
* -CREATE TABLE test (a char(5) DEFAULT text '', b int4) fails on INSERT(Tom)
39-
* UNION with LIMIT fails
39+
* -UNION with LIMIT fails
4040
* Unique index on base column not honored on inserts from inherited table
4141
INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail
4242
[inherit]
43-
* CREATE TABLE x AS SELECT 1 UNION SELECT 2 fails
44-
* CREATE TABLE test(col char(2) DEFAULT user) fails in length restriction
45-
* mismatched types in CREATE TABLE ... DEFAULT causes problems [default]
43+
* -CREATE TABLE x AS SELECT 1 UNION SELECT 2 fails
44+
* -CREATE TABLE test(col char(2) DEFAULT user) fails in length restriction
45+
* -mismatched types in CREATE TABLE ... DEFAULT causes problems [default]
4646
* SELECT ... UNION ... ORDER BY fails when sort expr not in result list
4747
* Be smarter about promoting types when UNION merges different data types
4848
* SELECT ... UNION ... GROUP BY fails if column types disagree
4949
* redesign INSERT ... SELECT to have two levels of target list
5050
* -select * from pg_class where oid in (0,-1)
5151
* have INTERSECT/EXCEPT prevent duplicates unless ALL is specified
5252
* prevent primary key of nine columns [primary]
53-
* SELECT COUNT('asdf') FROM pg_class WHERE oid=12 crashes
53+
* -SELECT COUNT('asdf') FROM pg_class WHERE oid=12 crashes
5454
* SELECT DISTINCT ON col1 col1 col2 FROM tab1 is broken [distinct]
5555
* -require SELECT DISTINCT target list to have all ORDER BY columns
5656
* -When using aggregates + GROUP BY, no rows in should yield no rows out(Tom)
@@ -82,7 +82,7 @@ URGENT
8282
* Add referential integrity(Jan?)[primary]
8383
* Add OUTER joins, left and right[outer](Thomas, Bruce)
8484
* Allow long tuples by chaining or auto-storing outside db (chaining,large objs)
85-
* Eliminate limits on query length
85+
* -Eliminate limits on query length
8686
* Fix memory leak for expressions[memory](Tom?)
8787
* -Fix memory leak for aggregates(Tom)
8888

@@ -102,7 +102,7 @@ TYPES
102102
* Nchar (as distinguished from ordinary varchar),
103103
* Domain capability
104104
* Add STDDEV/VARIANCE() function for standard deviation computation/variance
105-
* Allow compression of large fields or a compressed field type
105+
* -Allow compression of large fields or a compressed field type
106106
* Large objects
107107
o Fix large object mapping scheme, own typeid or reltype(Peter)
108108
o Allow large text type to use large objects(Peter)
@@ -199,14 +199,14 @@ MISC
199199
with after-row images(Vadim) [logging](Vadim)
200200
* Populate backend status area and write program to dump status data
201201
* Make oid use unsigned int more reliably, pg_atoi()
202-
* Allow subqueries in target list
202+
* -Allow subqueries in target list
203203
* Put sort files, large objects in their own directory
204204
* Do autocommit so always in a transaction block(?)
205205
* Show location of syntax error in query [yacc]
206206
* Redesign the function call interface to handle NULLs better [function]
207207
* Document/trigger/rule so changes to pg_shadow recreate pg_pwd [pg_shadow]
208208
* Missing optimizer selectivities for date, r-tree, etc. [optimizer]
209-
* Overhaul mdmgr/smgr to fix double unlinking and double opens, cleanup
209+
* -Overhaul mdmgr/smgr to fix double unlinking and double opens, cleanup
210210
* Overhaul bufmgr/lockmgr/transaction manager
211211
* Add PL/Perl(Mark Hollomon)
212212
* Make postgres user have a password by default
@@ -281,7 +281,7 @@ SOURCE CODE
281281
* Add use of 'const' for variables in source tree
282282
* Fix C optimizer problem where fmgr_ptr calls return different types [alpha]
283283
* -Add needed includes and removed unneeded include files(Bruce)
284-
* Make configure --enable-debug add -g on compile line
284+
* -Make configure --enable-debug add -g on compile line
285285
* Does Mariposa source contain any other bug fixes?
286286
* Remove SET KSQO option if OR processing is improved(Tom)
287287
* rename 'createuser' to 'pg_createuser', and add 'pg_' to other commands

‎doc/TODO.detail/array

Lines changed: 94 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,94 @@
1+
From owner-pgsql-hackers@hub.org Wed Nov 25 19:01:02 1998
2+
Received: from renoir.op.net (root@renoir.op.net [209.152.193.4])
3+
by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id TAA16399
4+
for <maillist@candle.pha.pa.us>; Wed, 25 Nov 1998 19:01:01 -0500 (EST)
5+
Received: from hub.org (majordom@hub.org [209.47.148.200]) by renoir.op.net (o1/$ Revision: 1.18 $) with ESMTP id SAA05250 for <maillist@candle.pha.pa.us>; Wed, 25 Nov 1998 18:53:12 -0500 (EST)
6+
Received: from localhost (majordom@localhost)
7+
by hub.org (8.9.1/8.9.1) with SMTP id SAA17798;
8+
Wed, 25 Nov 1998 18:49:38 -0500 (EST)
9+
(envelope-from owner-pgsql-hackers@hub.org)
10+
Received: by hub.org (TLB v0.10a (1.23 tibbs 1997/01/09 00:29:32)); Wed, 25 Nov 1998 18:49:07 +0000 (EST)
11+
Received: (from majordom@localhost)
12+
by hub.org (8.9.1/8.9.1) id SAA17697
13+
for pgsql-hackers-outgoing; Wed, 25 Nov 1998 18:49:06 -0500 (EST)
14+
(envelope-from owner-pgsql-hackers@postgreSQL.org)
15+
Received: from mail.enterprise.net (root@mail.enterprise.net [194.72.192.18])
16+
by hub.org (8.9.1/8.9.1) with ESMTP id SAA17650;
17+
Wed, 25 Nov 1998 18:48:55 -0500 (EST)
18+
(envelope-from olly@lfix.co.uk)
19+
Received: from linda.lfix.co.uk (root@max01-040.enterprise.net [194.72.197.40])
20+
by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id XAA20539;
21+
Wed, 25 Nov 1998 23:48:52 GMT
22+
Received: from linda.lfix.co.uk (olly@localhost [127.0.0.1])
23+
by linda.lfix.co.uk (8.9.1a/8.9.1/Debian/GNU) with ESMTP id XAA12089;
24+
Wed, 25 Nov 1998 23:48:52 GMT
25+
Message-Id: <199811252348.XAA12089@linda.lfix.co.uk>
26+
X-Mailer: exmh version 2.0.2 2/24/98 (debian)
27+
X-URL: http://www.lfix.co.uk/oliver
28+
X-face: "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F-
29+
KMLl*!h}B)u@TW|B}6<X<J|}QsVlTi:RA:O7Abc(@D2Y/"J\S,b1!<&<B/J}b.Ii9@B]H6V!+#sE0Q
30+
_+=`K$5TI|4I0-=Cp%pt~L#QYydO'iBXR~\tT?uftep9n9AF`@SzTwsw6uqJ}pL,h(cZi}T#PB"#!k
31+
p^e=Z.K~fuw$l?]lUV)?R]U}l;f*~Ol)#fpKR)Yt}XOr6BI\_Jjr0!@GMnpCTnTym4f;c{;Ms=0{`D
32+
Lq9MO6{wj%s-*N"G,g
33+
To: bugs@postgreSQL.org, hackers@postgreSQL.org
34+
Subject: [HACKERS] Failures with arrays
35+
Mime-Version: 1.0
36+
Content-Type: text/plain; charset=us-ascii
37+
Date: Wed, 25 Nov 1998 23:48:51 +0000
38+
From: "Oliver Elphick" <olly@lfix.co.uk>
39+
Sender: owner-pgsql-hackers@postgreSQL.org
40+
Precedence: bulk
41+
Status: ROr
42+
43+
This was reported as a bug with the Debian package of 6.3.2; the same
44+
behaviour is still present in 6.4.
45+
46+
bray=> create table foo ( t text[]);
47+
CREATE
48+
bray=> insert into foo values ( '{"a"}');
49+
INSERT 201354 1
50+
bray=> insert into foo values ( '{"a","b"}');
51+
INSERT 201355 1
52+
bray=> insert into foo values ( '{"a","b","c"}');
53+
INSERT 201356 1
54+
bray=> select * from foo;
55+
t
56+
-------------
57+
{"a"}
58+
{"a","b"}
59+
{"a","b","c"}
60+
(3 rows)
61+
62+
bray=> select t[1] from foo;
63+
ERROR: type name lookup of t failed
64+
bray=> select * from foo;
65+
t
66+
-------------
67+
{"a"}
68+
{"a","b"}
69+
{"a","b","c"}
70+
(3 rows)
71+
72+
bray=> select foo.t[1] from foo;
73+
t
74+
-
75+
a
76+
a
77+
a
78+
(3 rows)
79+
80+
bray=> select count(foo.t[1]) from foo;
81+
pqReadData() -- backend closed the channel unexpectedly.
82+
83+
--
84+
Oliver Elphick Oliver.Elphick@lfix.co.uk
85+
Isle of Wight http://www.lfix.co.uk/oliver
86+
PGP key from public servers; key ID 32B8FAA1
87+
========================================
88+
"Let us therefore come boldly unto the throne of grace,
89+
that we may obtain mercy, and find grace to help in
90+
time of need." Hebrews 4:16
91+
92+
93+
94+

0 commit comments

Comments
 (0)