Open 6.5 items

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Open 6.5 items
Date: 1999-05-24 14:31:38
Message-ID: 199905241431.KAA21647@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

SELECT * FROM test WHERE test IN (SELECT * FROM test) fails with strange error
Table with an element of type inet, will show "0.0.0.0/0" as "00/0"
When creating a table with either type inet or type cidr as a primary,unique
key, the "198.68.123.0/24" and "198.68.123.0/27" are considered equal
Make sure pg_internal.init concurrent generation can't cause unreliability
ALTER TABLE ADD COLUMN to inherited table put column in wrong place
crypt_loadpwdfile() is mixing and (mis)matching memory allocation
protocols, trying to use pfree() to release pwd_cache vector from realloc()
3 = sum(x) in rewrite system is a problem
Fix function pointer calls to take Datum args for char and int2 args(ecgs)

Do we want pg_dump -z to be the default?
pg_dump of groups fails
pg_dump -o -D does not work, and can not work currently, generate error?
psql \d should show precision
dumping out sequences should not be counted in pg_dump display

Make psql \help, man pages, and sgml reflect changes in grammar
Markup sql.sgml, Stefan's intro to SQL
Markup cvs.sgml, cvs and cvsup howto
Add figures to sql.sgml and arch-dev.sgml, both from Stefan
Include Jose's date/time history in User's Guide (neat!)
Generate Admin, User, Programmer hardcopy postscript

Future TODO items
-----------------
Make Serial its own type
Add support for & operator
store binary-compatible type information in the system somewhere
add ability to add comments to system tables using table/colname combination
process const=const parts of OR clause in separate pass
make oid use oidin/oidout not int4in/int4out in pg_type.h, make oid use
unsigned int more reliably, pg_atoi()
CREATE VIEW ignores DISTINCT
Move LIKE index optimization handling to the optimizer?
Allow ESCAPE '\' at the end of LIKE for ANSI compliance, or rewrite the
LIKE handling by rewriting the user string with the supplied ESCAPE
Fix leak for expressions?, aggregates?
Improve LIMIT processing by using index to limit rows processed
CLUSTER failure if vacuum has not been performed in a while
CREATE OPERATOR *= (leftarg=_varchar, rightarg=varchar,
procedure=array_varchareq); fails, varchar is reserved word, quotes work
Improve Subplan list handling
Allow Subplans to use efficient joins(hash, merge) with upper variable
Update reltuples from COPY command
CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops) fails
index can't store constant parameters, allow SQL function indexes?
Improve NULL parameter passing into functions

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-05-24 14:32:27 Re: [GENERAL] Full Text Searches
Previous Message Bruce Momjian 1999-05-24 14:31:24 Re: [HACKERS] DEFAULT fixed