Re: Show sequences owned by

Stephen Frost <sfrost@snowman.net> writes:
> 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.

Yeah, we do, via the deptype.  The check for deptype = 'a' is the
correct thing here.

Still, I'm not terribly comfortable with having multiple matches be
treated as a reason to fail the entire \d command.  It'd likely be
better to just not add a footer if you get an unexpected number of
matches.
        regards, tom lane