Relation between DROP TABLE and DROP INDEX
Relation between DROP TABLE and DROP INDEX
От:
"Mala Selvaraj" <mala_selvaraj@hotmail.com>
Дата:
Hi, I've a question. When I DROP a TABLE in postgresql and CREATE TABLE again, do I have to DROP the INDEX related to its key and re CREATE INDEX as well?? Pls enlighten. rgds Mala _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com
Re: Relation between DROP TABLE and DROP INDEX
От:
<mallah@trade-india.com>
Дата:
NO it is not so. it happens automatically. regds rajesh. > > > Hi, I've a question. When I DROP a TABLE in postgresql and CREATE TABLE again, do I have to > DROP the INDEX related to its key and re CREATE INDEX as well?? Pls enlighten. > > rgds > Mala > > > > > _________________________________________________________________ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' > the postmaster ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/