Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Upgrades for 6.4.1

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: hannu(at)trust(dot)ee (Hannu Krosing)
Cc: lockhart(at)alumni(dot)caltech(dot)edu, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Upgrades for 6.4.1
Date: 1998-12-18 16:07:17
Message-ID: 199812181607.LAA01924@candle.pha.pa.us (view raw or flat)
Thread:
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(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

In response to

pgsql-hackers by date

Next:From: Hannu KrosingDate: 1998-12-18 16:08:33
Subject: Re: [HACKERS] Upgrades for 6.4.1
Previous:From: Thomas G. LockhartDate: 1998-12-18 15:18:32
Subject: Re: [HACKERS] Re: [GENERAL] date_part bug?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group