Re: drop table and cleanups

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: drop table and cleanups
Date: 2012-11-19 19:13:29
Message-ID: CAK3UJRHtCi+3F_46nTwEz+vV_riktcygfi_RnjsLJSN2jM_6Kw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, Nov 19, 2012 at 8:28 AM, Birchall, Austen
<austen(dot)birchall(at)metoffice(dot)gov(dot)uk> wrote:
> If I drop a table am I right to assume that all its indexes, sequences etc.
> will also be dropped and that all entries in pg_class, pg_constraint, etc.
> will be cleaned up?

Yes. Check out pg_depend if you're interested in the bookkeeping
behind this dependency tracking:
http://www.postgresql.org/docs/current/static/catalog-pg-depend.html

Josh

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ennio-Sr 2012-11-20 17:12:27 Postgresql-8.4: File System Level Backup (& recovery failure)
Previous Message Birchall, Austen 2012-11-19 15:28:42 drop table and cleanups