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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, dhogaza(at)pacifier(dot)com, scrappy(at)hub(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us, webmaster(at)postgreSQL(dot)org, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Beta for 4:30AST ... ?
Date: 2000-02-22 14:11:52
Message-ID: 200002221411.JAA15418@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)gmx(dot)net 75262 Uppsala
> http://yi.org/peter-e/ Sweden
>
>

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-02-22 14:15:54 Re: [HACKERS] Beta for 4:30AST ... ?
Previous Message Bruce Momjian 2000-02-22 14:07:11 Re: [HACKERS] Beta for 4:30AST ... ?