PostgreSQL -- Cannot drop a sequence after dropping the table.

6 views
Skip to first unread message

Faron Dutton

unread,
Apr 1, 2012, 11:06:37 AM4/1/12
to DB Solo
Dropping a table automatically drops any sequence owned by the table.
Any attempt to subsequently drop the sequence fails since it no longer
exists.

Marko Hantula

unread,
Apr 5, 2012, 10:04:02 PM4/5/12
to db-...@googlegroups.com
The DROP SEQUENCE statement now contains the IF EXISTS qualifier, so
it should work even if the table was dropped.

Marko

> --
> You received this message because you are subscribed to the Google Groups "DB Solo" group.
> To post to this group, send email to db-...@googlegroups.com.
> To unsubscribe from this group, send email to db-solo+u...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/db-solo?hl=en.
>

Reply all
Reply to author
Forward
0 new messages