Re: [HACKERS] Beta for 4:30AST ... ?

Working on the Release Announcement now ... Bruce, how accurate is the
current TODO list? If I go through it looking for all items marked as
'-', I come up with the following list. Is it missing anything? I know
not *everything* has to be listed, so I'm more afraid of listing something
that shouldn't then not listing enough ...

The beta1.tar.gz snapshot has been created ... I'll put out an
announcement later tonight once I've heard back on this list, which also
gives some of the mirror sites a chance to sync up, and Vince a chance to
update the web site...

=============================================
RELIABILITY

RESOURCES

* -Disallow inherited columns with the same name as new columns
* -Elog() does not free all its memory
* -spinlock stuck problem when elog(FATAL) and elog(ERROR) inside bufmgr
* -Recover or force failure when disk space is exhausted(Hiroshi)

PARSER

* -INSERT INTO ... SELECT with AS columns matching result columns problem
* -Select a[1] FROM test fails, it needs test.a[1](Tom)
* -Array index references without table name cause problems [array](Tom)
* -INSERT ... SELECT ... GROUP BY groups by target columns not source
columns(Tom)
* -CREATE TABLE test (a char(5) DEFAULT text '', b int4) fails on
INSERT(Tom)
* -UNION with LIMIT fails
* -CREATE TABLE x AS SELECT 1 UNION SELECT 2 fails
* -CREATE TABLE test(col char(2) DEFAULT user) fails in length
restriction
* -mismatched types in CREATE TABLE ... DEFAULT causes problems [default]
* -SELECT ... UNION ... ORDER BY fails when sort expr not in result list,
ORDER BY is applied only to the first SELECT
* -select * from pg_class where oid in (0,-1)
* -prevent primary key that exceeds max index columns [primary]
* -SELECT COUNT('asdf') FROM pg_class WHERE oid=12 crashes
* -require SELECT DISTINCT target list to have all ORDER BY columns
* -When using aggregates + GROUP BY, no rows in should yield no rows
out(Tom)
* -Allow HAVING to use comparisons that have no aggregates(Tom)
* -Allow COUNT(DISTINCT col))(TOm)

VIEWS

* -Views with spaces in view name fail when referenced

MISC

* -User who can create databases can modify pg_database table(Peter E)
* -Fix btree to give a useful elog when key > 1/2 (page - overhead)(Tom)
* -pg_dump should preserve primary key information
* -database names with spaces fail
* -insert of 0.0 into DECIMAL(4,4) field fails(Tom)
* -* Interlock to prevent DROP DATABASE on a database with running
backendsInterlock to prevent DROP DATABASE on a database with running
backends

ENHANCEMENTS

URGENT

* -Add referential integrity(Jan)[primary]
* -Eliminate limits on query length
* -Fix memory leak for aggregates(Tom)

ADMIN

* -Better interface for adding to pg_group(Peter E)
* -Generate postmaster pid file and remove flock/fcntl lock
code[flock](Tatsuo)

TYPES

* -Add BIT, BIT VARYING
* -Allow pg_descriptions when creating tables
* -Allow pg_descriptions when creating types, columns, and functions
* -Allow LOCALE to use indexes in regular expression searches(Tom)
* -Allow array on int8[](Thomas)
* -Add index on NUMERIC/DECIMAL type(Jan)
* -Make Absolutetime/Relativetime int4 because time_t can be int8 on some
ports
* -Make type equivalency apply to aggregates

INDEXES

* -Permissions on indexes, prevent them(Peter E)
* -Allow indexing of LIKE with localle character sets
* -Allow indexing of more than eight columns

COMMANDS

* -Add ALTER TABLE DROP/ALTER COLUMN feature(Peter E)
* -Move LIKE index optimization handling to the optimizer(Tom)

CLIENTS

* -Allow flag to control COPY input/output of NULLs
* -Allow psql \copy to allow delimiters
* -Add a function to return the last inserted oid, for use in psql
scripts (Peter E)
* -Allow psql to print nulls as distinct from "" [null]

MISC

* -Certain indexes will not shrink, i.e. oid indexes with many
inserts(Vadim)
* -Allow WHERE restriction on ctid(Hiroshi)
* -Allow PQrequestCancel() to terminate when in waiting-for-lock state
* -Allow subqueries in target list(Tom)
* -Document/trigger/rule so changes to pgshadow recreate pgpwd
[pg_shadow]
* -Overhaul mdmgr/smgr to fix double unlinking and double opens, cleanup
* -Add PL/Perl(Mark Hollomon)
* -Add option for postgres user have a password by default(Peter E)

PERFORMANCE

FSYNC

* -Prevent fsync in SELECT-only queries(Vadim)

INDEXES

* -Convert function(constant) into a constant for index use(Bernard
Frankpitt)
* -Make index creation use psort code, because it is now faster(Tom)
* -Allow creation of sort temp tables > 1 Gig
* -Create more system table indexes for faster cache lookups
* -fix indexscan() so it does leak memory by not requiring caller to
free(Tom)
* -Improve btbinsrch() to handle equal keys better, remove
btfirsteq()(Tom)
* -Allow optimizer to prefer plans that match ORDER BY(Tom)

CACHE

* -elog() flushes cache, try invalidating just entries from current xact,
perhaps using invalidation cache

MISC

* -Fix memory exhaustion when using many OR's [cnfify](Tom)
* -Process const = const parts of OR clause in separate pass(Bernard
Frankpitt)
* -fix memory leak in cache code when non-existant table is referenced In
WHERE tab1.x=3 AND tab1.x=tab2.y, add tab2.y=3
* -pass atttypmod through parser in more cases [atttypmod]
* -remove duplicate type in/out functions for disk and net

SOURCE CODE

* -Add needed includes and removed unneeded include files(Bruce)
* -Make configure --enable-debug add -g on compile line
* -Pre-generate lex and yacc output so not required for install

==================================================
On Mon, 21 Feb 2000, Tom Lane wrote:

> Don Baccus <dhogaza(at)pacifier(dot)com> writes:
> >> Think we'll have to
> >> leave it unfixed till Thomas gets back.
>
> > That would be plenty of time to get it in for the real 7.0 release.
>
> I don't like shipping betas with broken pg_dump; that makes life
> unreasonably difficult for beta testers, if we have to force another
> initdb before release. So I put in a quick hack solution: don't print
> the column alias list at all unless there is a table alias. This makes
> the rule's FROM clause conform to ANSI syntax. If you actually did
> write
> create view foo as SELECT alias FROM table table (alias);
> then it will dump as
> create view foo as SELECT table.realcolname AS alias FROM table;
> but there's no harm done. Better solution needed but I'll let Thomas
> provide it.
>
> And now, it's 4:30 PM AST and we are outta here ... right Marc?
>
> regards, tom lane
>

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org