1. Forum
  3. Main PGNP Forum
  5. Miscellaneous
  7. Disabling PGNP optimizer

Disabling PGNP optimizer

  • barakp
  • Topic Author
  • Visitor
  • Visitor
9 years 2 weeks ago #10328 by barakp
Disabling PGNP optimizer was created by barakp
Hi,
I'm using PGNP to connect to a postgresql DB. In the DB's log I see the following error:
ERROR: relation "pgnp_optimizer" does not exist at character 49
STATEMENT: SELECT OPTIMIZER_ID, HASHTYPE, HASH, FINAL FROM PGNP_OPTIMIZER WHERE ENABLED = 'Y'

I would like to disable the PGNP optimizer as I'm connecting with a read only user to the database.
Please advise how to do so.

Thanks,
Barak

Please Log in or Create an account to join the conversation.

More
9 years 1 week ago #10333 by Moderator
Replied by Moderator on topic Re: Disabling PGNP optimizer
We added new connection string parameter OPTIMIZER=ON/OFF in build 1.4.0.3200. This is an optional parameter, and the default value is OFF (optimizer is not enabled).

Users who previously used the Optimizer must add the parameter OPTIMIZER=ON to the Extended Properties of the connection string.

Please Log in or Create an account to join the conversation.

  1. Forum
  3. Main PGNP Forum
  5. Miscellaneous
  7. Disabling PGNP optimizer
Time to create page: 0.057 seconds
Powered by Kunena Forum