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(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