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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
