Обсуждение: Relation between DROP TABLE and DROP INDEX

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

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/