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(dot)wong(at)thomsonreuters(dot)com> 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