=?UTF-8?B?TWFjaWVqIMWBb3B1c3phxYRza2k=?= <lopuszan...@oleofarm.com> writes:
> is there a way to find exactly what object/table/column creates this
> circular dependency?
Look into pg_depend for entries referencing the view or the view's
rowtype. (Offhand I'd bet it's the latter.) So the refobjid would
be 'viewname'::regclass or 'viewname'::regtype.
> pg_dumb even in verbose mode does not warn/error of this situation.
Why should it? This isn't a bug, this is merely an implementation
detail.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
