(please keep communication on the list) On Fri, 31 May 2024 at 13:43, Wong, Kam Fook (TR Technology) <kamfook.wong@xxxxxxxxxxxxxxxxxx> wrote: > > Silly question why did I run into this problem below? Will the autovacuum analyze abc reset it back which I don't want it to. > > DELETE FROM pg_statistic WHERE starelid = 'abc'::regclass and staattnum = (SELECT attnum FROM pg_attribute WHERE attrelid = 'abc'::regclass AND attname = 'bg_org_partner'); > > SQL Error [42P01]: ERROR: relation "abc" does not exist > Position: 52 The schema for the abc table will need to be in your search_path. You'll need to be connected to the correct database too. David
