How to switch to oracle mode? #659
Replies: 2 comments 2 replies
-
|
In IvorySQL3 version, if you want use oracle compatible mode, you could try as following: step-2: start ivorysql step-3: connect oracle port via 1521 and change compatible mode via "set ivorysql.compatible_mode" postgres=# select version(); postgres=# show ivorysql.compatible_mode; postgres=# set ivorysql.compatible_mode="pg"; Feel free to let me know if anything is confusing. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks. Are these steps documented somewhere? Because when I tried looking into the docs. it only showed me the old method of setting the configurations for oracle mode. |
Beta Was this translation helpful? Give feedback.
-
|
For GUC variables, please refer to GUC framework, there are some usage cases, like ivorysql.compatible and ivorysql.datetime_ignore_nls_mask etc. The old method you were pointed out in docs, will be modified and updated ASAP. |
Beta Was this translation helpful? Give feedback.
-
|
Ok Thanks guys. Closing it now. |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
In previous version we used to switch modes using 'set comaptibility_mode'.
I noticed there is something changed in 3.2 (latest versions), its 'SET ivorysql.compatible=oracle;' Now.
But cannot find this variable in neither
postgresql.confnor inivorysql.confAlso cannot change it by the psql
How to use the server in oracle mode?
Beta Was this translation helpful? Give feedback.
All reactions