试试这个:
ALTER SEQUENCE foo_id_seq OWNED BY NONE
那么您应该可以放下桌子。
要检索序列的“所有者”,请使用以下查询
SELECt s.relname as sequence_name, n.nspname as sequence_schema, t.relname as related_table, a.attname as related_column FROM pg_class s, pg_depend d, pg_class t, pg_attribute a, pg_namespace n WHERe s.relkind = 'S' AND n.oid = s.relnamespace AND d.objid = s.oid AND d.refobjid = t.oid AND (d.refobjid, d.refobjsubid) = (a.attrelid, a.attnum)



