Re: Show sequences owned by

* Magnus Hagander (magnus(at)hagander(dot)net) wrote:
> If there is noone owning it at all, it just falls through the if/else
> block and ignores it if that happens (PQntuples() returns 0).

Ah, right, but 'result' is still non-zero, ok.

> Is there really a case for multiple sequences to own it? How would you
> go about making that happen? ALTER SEQUENCE.. OWNED BY.. only takes
> one table, afaics?

I just noticed it was pulling from pg_depend and we could be creating
multiple dependencies on a single sequence by having two tables use it
as a default value. If that situation doesn't cause a problem for this,
then that's fine. :) Couldn't remember if we distinguished 'owned by'
from 'dependend upon' for seqeunces.

Thanks,

Stephen