(please keep communication on the list)
On Fri, 31 May 2024 at 13:43, Wong, Kam Fook (TR Technology)
<kamfook.wong@thomsonreuters.com> wrote:
>
> Silly question why did I run into this problem below? Will the autovacuum analyze abc reset it back which I don't
wantit 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