Re: [HACKERS] Upgrades for 6.4.1
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: hannu@trust.ee (Hannu Krosing)
Cc: lockhart@alumni.caltech.edu, hackers@postgreSQL.org
Date: 1998-12-18T16:07:17Z
Lists: pgsql-hackers
> Bruce Momjian wrote: > > > > > > > ENHANCEMENTS > > > > ------------ > > > > * Add full ANSI SQL capabilities > > > > * add OUTER joins, left and right (Thomas) > > > > * add INTERSECTS, SUBTRACTS(Stephan) > > > > * add temporary tables > > > > * add sql3 recursive unions > > > > * add the concept of dataspaces > > > > * add DECIMAL, NUMERIC, DOUBLE PRECISION, BIT, BIT VARYING > > > > > > We've got DOUBLE PRECISION, DECIMAL, and NUMERIC (the latter two are > > > brain-damaged though) > > > > Removed. > > If it's brain-damaged should'nt it be justr Replaced instead of Removed We just need to add better precision to the type. > > > > > > > > > > * add CONSTRAINT > > > > > > Already here, from Vadim. > > Removed. > > > > AFAIK, CONSTRAINTS ar currently available only at table create time ? > > So once you have (or have.nt) them, you must stay with it ;( > > creating/dropping constraints should be made to work in ALTER TABLE as > well Already on list: * ALTER TABLE ADD COLUMN does not honor DEFAULT, add CONSTRAINT -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026