pg_hint_tables
От | Wong, Kam Fook (TR Technology) |
---|---|
Тема | pg_hint_tables |
Дата | |
Msg-id | DM4PR03MB603219DBB6FF9973DFCE02DEFE1AA@DM4PR03MB6032.namprd03.prod.outlook.com обсуждение исходный текст |
Ответ на | Re: Can't create a table with vector type as a non-super user (Adrian Klaver <adrian.klaver@aklaver.com>) |
Ответы |
Re: pg_hint_tables
|
Список | 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@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 anyattachments. Certain required legal entity disclosures can be accessed on our website: https://www.thomsonreuters.com/en/resources/disclosures.html
В списке pgsql-general по дате отправления: