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

Re: ALTER TABLE DROP CONSTRAINT

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Jean-Michel POURE'" <jm(dot)poure(at)freesurf(dot)fr>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: ALTER TABLE DROP CONSTRAINT
Date: 2001-09-29 12:44:26
Message-ID: AA30E7BCCA5C1D4E88A231900F8325C00B43@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr] 
> Sent: 29 September 2001 13:32
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] ALTER TABLE DROP CONSTRAINT
> 
> 
> Hello,
> 
> PostgreSQL 7.2 includes a new ALTER TABLE DROP CONSTRAINT.
> This should make table rebuilding a lot easier.
> 

Yes, it's on my 7.2 to-do list. It only drops checks though :-(

I have now also committed:

1) OID-less table support.
2) Partial Index Support (currentlt you can't view the constraint, but
that's due to a bug in the server afaict.
3) Option to change the master database in case you don't have access to
template1 (for ISP hosted dbs generally).
4) Inaccessible DBs (ie teplate0 and others that pg_hba.conf doesn't allow
access to) are now flagged as such and handled accordingly.

Regards, Dave.

pgadmin-hackers by date

Next:From: Jean-Michel POUREDate: 2001-09-29 15:53:30
Subject: Splash screen & table rebuilding
Previous:From: Jean-Michel POUREDate: 2001-09-29 12:31:52
Subject: ALTER TABLE DROP CONSTRAINT

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