pg_hint_tables

From: "Wong, Kam Fook (TR Technology)" <kamfook(dot)wong(at)thomsonreuters(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pg_hint_tables
Date: 2025-09-30 19:51:49
Message-ID: DM4PR03MB603219DBB6FF9973DFCE02DEFE1AA@DM4PR03MB6032.namprd03.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to use pg_hint_tables in AWS Aurora Postgres. I changed the Postgres parameter "pg_hint_plan.enable_hint_table = 1". Then I logout but can't login anymore with the following error message.

“postgres(at)postgres:[2719]:ERROR: relation "hint_plan.hints" does not exist at character 21”.

I undo the changes, log back in. Can't find a good resources that lead me to the root cause. So I try a few other things, see below. But no luck. Any guidance or help is greatly appreciated.

ALTER EXTENSION pg_hint_plan UPDATE TO '1.4';
GRANT SELECT, INSERT, UPDATE, DELETE ON hint_plan.hints TO PUBLIC;
GRANT USAGE ON SCHEMA hint_plan TO PUBLIC;

Thank you
Kam Fook Wong
This e-mail is for the sole use of the intended recipient and contains information that may be privileged and/or confidential. If you are not an intended recipient, please notify the sender by return e-mail and delete this e-mail and any attachments. Certain required legal entity disclosures can be accessed on our website: https://www.thomsonreuters.com/en/resources/disclosures.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-09-30 20:13:21 Re: pg_hint_tables
Previous Message Adrian Klaver 2025-09-30 18:11:51 Re: Can't create a table with vector type as a non-super user