|
532 | 532 |
|
533 | 533 | <para>
|
534 | 534 | <filename>postgres_fdw</> likewise establishes remote session settings
|
535 |
| - for the parameters <xref linkend="guc-timezone">, |
536 |
| - <xref linkend="guc-datestyle">, <xref linkend="guc-intervalstyle">, |
537 |
| - and <xref linkend="guc-extra-float-digits">. These are less likely |
538 |
| - to be problematic than <varname>search_path</>, but can be handled |
539 |
| - with function <literal>SET</> options if the need arises. |
| 535 | + for various parameters: |
| 536 | + <itemizedlist spacing="compact"> |
| 537 | + <listitem> |
| 538 | + <para> |
| 539 | + <xref linkend="guc-timezone"> is set to <literal>UTC</> |
| 540 | + </para> |
| 541 | + </listitem> |
| 542 | + <listitem> |
| 543 | + <para> |
| 544 | + <xref linkend="guc-datestyle"> is set to <literal>ISO</> |
| 545 | + </para> |
| 546 | + </listitem> |
| 547 | + <listitem> |
| 548 | + <para> |
| 549 | + <xref linkend="guc-intervalstyle"> is set to <literal>postgres</> |
| 550 | + </para> |
| 551 | + </listitem> |
| 552 | + <listitem> |
| 553 | + <para> |
| 554 | + <xref linkend="guc-extra-float-digits"> is set to <literal>3</> for remote |
| 555 | + servers 9.0 and newer and is set to <literal>2</> for older versions |
| 556 | + </para> |
| 557 | + </listitem> |
| 558 | + </itemizedlist> |
| 559 | + These are less likely to be problematic than <varname>search_path</>, but |
| 560 | + can be handled with function <literal>SET</> options if the need arises. |
540 | 561 | </para>
|
541 | 562 |
|
542 | 563 | <para>
|
|