Horton

Re: [HACKERS] Beta for 4:30AST ... ?

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Tatsuo Ishii <t-ishii@sra.co.jp>, dhogaza@pacifier.com, scrappy@hub.org, tgl@sss.pgh.pa.us, webmaster@postgreSQL.org, pgsql-hackers@postgreSQL.org
Date: 2000-02-22T14:11:52Z
Lists: pgsql-hackers 
> On Tue, 22 Feb 2000, Bruce Momjian wrote:
> 
> > > What about ALTER TABLE table DROP CONSTRAINT? I see this:
> 
> > > Note that we seem to have ALTER TABLE table ADD CONSTRAINT, though.
> 
> > Perhaps Peter decided to wait for 7.1?
> 


I was speaking off DROP COLUMN.  Sorry to have added to the confusion.


> Yes and no. I never had anything like this. I was afraid to get crossed up
> with Jan. Anyway, to add/drop unique constraints create/drop the index. To
> add/drop foreign keys, use create/drop constraint trigger(????). To
> add/drop check contraints you're on your own. Not so bad all in all.
> 
> -- 
> Peter Eisentraut                  Sernanders vaeg 10:115
> peter_e@gmx.net                   75262 Uppsala
> http://yi.org/peter-e/            Sweden
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@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