Relation between DROP TABLE and DROP INDEX

From: "Mala Selvaraj" <mala_selvaraj(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Relation between DROP TABLE and DROP INDEX
Date: 2002-09-30 04:36:29
Message-ID: F76QYx3G5aYY61LEdyt0000c9be@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adam Walczykiewicz 2002-09-30 05:33:28 Re: PostgreSQL on SCO
Previous Message Kostis 2002-09-30 02:56:51 idle in transaction with mod_perl