Re: sequence havn't been dropped. - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: sequence havn't been dropped.
Date
Msg-id Pine.LNX.4.30.0203140052460.741-100000@peter.localdomain
Whole thread Raw
In response to sequence havn't been dropped.  (Bhuvan A <bhuvansql@yahoo.com>)
List pgsql-bugs
Bhuvan A writes:

> while creating a table with a column of type 'serial', well a sequence
> has been created and the default value of that field is set to nextval
> of that sequence, fine. But while dropping that table, why aren't that
> sequence dropped?

The sequence isn't owned by the table.  It might be used elsewhere as
well.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-bugs by date:

Previous
From: Bhuvan A
Date:
Subject: sequence havn't been dropped.
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #614: Incorrect parse with time function