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

Commit90e0b66

Browse files
committed
Update TODO list.
1 parentfc955b1 commit90e0b66

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 Nov22 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)

[8]ページ先頭

©2009-2025 Movatter.jp