public inbox for [email protected]  

help / color / mirror / Atom feed

From: Wong, Kam Fook (TR Technology) <[email protected]>
To: [email protected] <[email protected]>
Subject: pg_hint_tables
Date: Tue, 30 Sep 2025 19:51:49 +0000
Message-ID: <DM4PR03MB603219DBB6FF9973DFCE02DEFE1AA@DM4PR03MB6032.namprd03.prod.outlook.com> (raw)
In-Reply-To: <[email protected]>
References: <CACmLaviY60Vx64hcacS687kBA3tXRfcYzrSJb6XaHU4X5qOrmQ@mail.gmail.com>
	<[email protected]>

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@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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: pg_hint_tables
  In-Reply-To: <DM4PR03MB603219DBB6FF9973DFCE02DEFE1AA@DM4PR03MB6032.namprd03.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox