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

From: Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
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 11:58:52
Message-ID: Pine.GSO.4.02A.10002221256140.14754-100000@Haj.DoCS.UU.SE
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?

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2000-02-22 12:07:29 Re: [HACKERS] Beta for 4:30AST ... ?
Previous Message Jose Soares 2000-02-22 11:47:44 TRANSACTIONS