Re: Unable to drop sequence due to dependency?

Tom Lane wrote:
> What's the whole contents of the rows with refobjid matching the
> sequence's OID?  In particular, classid::regclass would tell you
> where to look for the dependent object.

oms=# select * from pg_depend where objid = 1011680210;
  classid |   objid    | objsubid | refclassid | refobjid | refobjsubid
| deptype
---------+------------+----------+------------+----------+-------------+---------
     1259 | 1011680210 |        0 |       2615 |     2200 |           0 | n
(1 row)

oms=# select * from pg_depend where refobjid = 1011680210;
  classid |   objid    | objsubid | refclassid |  refobjid  |
refobjsubid | deptype
---------+------------+----------+------------+------------+-------------+---------
     2604 | 1011687585 |        0 |       1259 | 1011680210 |
0 | n
     1247 | 1011680211 |        0 |       1259 | 1011680210 |
0 | i
(2 rows)


  > Typically, the default expression for a serial column based on the
> sequence.  It's a bit odd that the DROP doesn't tell you about it
> though.


For some reason I got into my head the notion that a sequence could be
dropped even if reference by a field default.  This seems pretty silly now.

-Glen