Re: [HACKERS] Upgrades for 6.4.1

> 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,
Pennsylvania19026