I see why… The select of the view is picking d.ino which is null because there
is no match in the dirents table.
Thanks guys!
> On Aug 11, 2022, at 08:23, Perry Smith wrote:
>
> I’m tempted to ask “Is this a bug” but I predict there is an explanation.
>
> I have a view:
> find_dups=# \sv+ da
I’m tempted to ask “Is this a bug” but I predict there is an explanation.
I have a view:
find_dups=# \sv+ dateien
1 CREATE OR REPLACE VIEW public.dateien AS
2SELECT d.id,
3 d.basename,
4 d.parent_id,
5 d.ino,
6 d.ext,
7 i.ftype,
8