Re: [EXT] Re: How to delete column level Stats/Histogram

(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