Re: [HACKERS] Upgrades for 6.4.1 - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: [HACKERS] Upgrades for 6.4.1
Date
Msg-id 367A7E01.3EFD864D@trust.ee
Whole thread Raw
In response to Re: [HACKERS] Upgrades for 6.4.1  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] Upgrades for 6.4.1  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] Upgrades for 6.4.1  (jwieck@debis.com (Jan Wieck))
List 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 

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


------------------
Hannu


pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Re: [GENERAL] date_part bug?
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Upgrades for 6.4.1