From: "ideriha.takeshi@fujitsu.com" <ideriha.takeshi@fujitsu.com>
To: "'pgsql-docs@lists.postgresql.org'" <pgsql-docs@lists.postgresql.org>
CC: "'meskes@postgresql.org'" <meskes@postgresql.org>
Subject: No documentation exists about ecpg ORACLE comptaible mode
Thread-Topic: No documentation exists about ecpg ORACLE comptaible mode
Thread-Index: Adh6SC675XVIzO3eRSmkY7MiQIyviA==
Date: Tue, 7 Jun 2022 08:28:55 +0000
Message-ID: 
 <TYCPR01MB7041A157067208327D8DAAF9EAA59@TYCPR01MB7041.jpnprd01.prod.outlook.com>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
msip_labels: MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Enabled=true;
 MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SetDate=2022-06-07T08:24:44Z;
 MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Method=Standard;
 MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Name=FUJITSU-RESTRICTED?;
 MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SiteId=a19f121d-81e1-4858-a9d8-736e267fd4c7;
 MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ActionId=41421d2a-31d2-4635-9848-5941751b80d8;
 MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ContentBits=0
x-securitypolicycheck: OK by SHieldMailChecker v2.6.5
x-shieldmailcheckermailid: c87432c77d204f11976caeac41fd86fe
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=fujitsu.com;
x-ms-publictraffictype: Email
x-ms-office365-filtering-correlation-id: f53bd2fb-a5fa-4eae-37fa-08da485fc2f4
x-ms-traffictypediagnostic: TYAPR01MB5610:EE_
x-microsoft-antispam-prvs: 
 <TYAPR01MB5610922B69E739309DC080E9EAA59@TYAPR01MB5610.jpnprd01.prod.outlook.com>
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: 
 mEzl95P3FRUu/S3HEf91jmJxcO/GKzzElOjzq0FvVYXiy9Jc4JGqsbnbf9Qok6NjELtBQ0vKXYAIIMrqJBI51kr5oPczQj1sKFn5CUxqfp56wF6V65JsLCgYciEKI5ePiJ/SMflb0H+kgcc7F4Pu71FvjkhCADhaTBxOhlsLTzzs2PLpfT3mls/Czh0m6CnQ07xEt8DEH7DO2PPL9z7N06nrB/jVDDshXrorGcVFdiBQMDaQLUx4zfy6txeyXL2FpocVYXQPIoFf2ss4at9wk3lAMQa2skLeYDSGTlsPXoFjjAHECq9vZEFQ9siYG+WtZXzCjjltlxYtmgWs/DDZHvIRVrbuRmlneRUN/1NzB1ndR2RVq6WedL5GU0MoXgONo1ilxdNogxVJhflB97BCEhpCjDY1oBjhHAfasQ8g5IkbaFb43niwFuStZUUgIr5V/ueJqL0WSyiTYLDgOlE02mW0DExGmVFCG/1TG5JY2n/E6YcKKYA246Ml8hPH/Lz+Di8JA1EA8Qed3UL1VWRGwOsuvsR+JOrSJZS25ItJDAEQMp0en3NJkC1v0QR3Ksf6eRRe4uArsowTmI3NI/GLmp8BIGBbFYKClxUPIUjv23U0vz7o8MfmMlZ3NenrfwC4SDTdboBWT3+sIS00/4qbTYxsO3GB2S/ExAu6dWxojiNmuCepuKarLbW62FUE8YurFxrgUBYs4NWsDIy/NHPejwOlZ5mIgjmlsS3/slEZRzEZzNjbKgQ1BhEwOseSgzdwoT+6TdxVHUeqyGhEO7vVpc/nVVtZu5ynLgWMPq8us5XhlLMySaXa2DaGTQLCw+vgJLbs+27qErZkAV1NPCd5oD6xWHWFYIkN6sdZAH1yi5o=
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYCPR01MB7041.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230001)(4636009)(366004)(6506007)(2906002)(122000001)(82960400001)(38070700005)(85182001)(33656002)(83380400001)(9686003)(38100700002)(5660300002)(26005)(71200400001)(966005)(316002)(8936002)(7696005)(55016003)(186003)(86362001)(52536014)(66556008)(66446008)(64756008)(8676002)(66476007)(4326008)(6916009)(66946007)(76116006)(508600001)(491001);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-2022-jp?B?a01Zcm9aYjFYUzRJY3hSVE05U1FrRElJSWhibXVNNkFoNmxXcThhbFBj?=
 =?iso-2022-jp?B?citkNVF4eURPQ2MwdStXakliZnRnVE11dmpibTNHWHdBYmJseU5qd0pI?=
 =?iso-2022-jp?B?ZHJTL0RHWDFrY1FCMjgxS3pXN3FybVNGb1A1K0tiVUl3eldlWWxCUDZk?=
 =?iso-2022-jp?B?VHgzU0hlMnRaZTVmR2g5akpzYy9qVTlaQkpPWkJTbm5zbEdQODFOeDRt?=
 =?iso-2022-jp?B?RnY0Z2F5T1kvWExXb1htKzYrVFhxSXU2ZHNyS2h4MEpqZytmd1YzYVdp?=
 =?iso-2022-jp?B?WnVoZSs0UXJtMGxadkZTdHNjVXIzTEtXRWxJZCswSVZUcEJ2M0owelB3?=
 =?iso-2022-jp?B?REpTWFpEZGZPeHc3NFo0UjZhMk1uSjFiK0lIQlN6UGNseFdsNzF4Vmto?=
 =?iso-2022-jp?B?ckRieUVmY2xubWVINUE0ZGdZek03cEZGODNvYU1hVnJycFdjd3lPaE5v?=
 =?iso-2022-jp?B?SHFTZDVIeWpzRGU3ZXFlSW9ZbHVTOWNML2dnSTdKTk4rMXlrUGhGd0dr?=
 =?iso-2022-jp?B?cnVoZ0NMZ1dMelhsZVdTeW5xdmRqbXhRS2liaGZpUlAxOVNqZlNlWFdB?=
 =?iso-2022-jp?B?R1luRVpsdzNvc1NHQkkyVEVEU2U2STBGZHZIY0Myb3BnN1RNa3JUWUtN?=
 =?iso-2022-jp?B?MGpaaEpDckpUbmhxSXNlTXFRM09Xd1NWLzh6WGZZRUpiSFVhK20xT3dl?=
 =?iso-2022-jp?B?ZFQvTnZOTlloN1dkVFprLzZ3cnd3bktTcXhUZXpxZFhWR0s3M0ExY2J5?=
 =?iso-2022-jp?B?d3NlQ0lOZVNwbTBoVnV6aXRFdjlmQzJ3cjlmZUh0MDNjeDYyR0NYZ29k?=
 =?iso-2022-jp?B?WnA3RWdKV2RoZHU1dDJhbVZlQWNaZVZVckhpYlRaeEw4TFNOQzBCOTBB?=
 =?iso-2022-jp?B?RWxkL1VYSmJobUgrVGNGMDVqWWNDMnFiSm53QXdLSXNvTWJMZ3NWUG1k?=
 =?iso-2022-jp?B?Ykh1YzB2S0MyOEJvS0YzZ2RtWjlsaGMrMndRLy9MUlJDUXBCM1pwVHJ0?=
 =?iso-2022-jp?B?K0JzRDdTcjBVSmIrb1BtM0ZkRWh0OXgvSHFxRlZYa0RIRUJSRDFOekc1?=
 =?iso-2022-jp?B?T1ZweENjTHM2M0U5VDVRRC81UG5Ndjd4U29aeHZoNUhpU3I0QkY3eVht?=
 =?iso-2022-jp?B?eVdYY09Rd010YjM5cUh6MnZBUmR1K3RNT0FDbm9MaktFQlNDNlhjY3l1?=
 =?iso-2022-jp?B?UisvSkJqMGdmaUZKbHppUWxJd2FwenZFZ1ZlYW9YbXVVZFFWck5od3BZ?=
 =?iso-2022-jp?B?N2JPdUI3VUZrTUdnZ3JDSkEybSttQzBINElRTUM2d1h3V3lzeFNPVC9x?=
 =?iso-2022-jp?B?dFFtTHNmdzl5NUMwSUV3MEVWdGUzcHN0Umg0eklzeVF3VlB0VHk0THhW?=
 =?iso-2022-jp?B?RXBETmE2NU82TG42OEdONFhoOGVmSWc4YUNxRlNza0wvVFVoTUIxaUdr?=
 =?iso-2022-jp?B?anI3S0t5Z2ozYUZ4aGk5Tmw2dDg3bFJuZ1JRakV2ZU9KMVpTSEJjSHM5?=
 =?iso-2022-jp?B?OHNISmRHSjk3RFhpNXZEWkJoSWg5UWEwYjM1V09JbGlLR2E5dW5TTkti?=
 =?iso-2022-jp?B?NUFJZDJwcUZteGU0RHJFRlRNTkVOVHN3WFFZc3pSMXlLM0VnN3g2blJv?=
 =?iso-2022-jp?B?MStvRjBPU1ppdVJJbTRDdE11em9DeFJ0YVQrSW9ORXJHWXh4RmtRUEZX?=
 =?iso-2022-jp?B?Wkg3UkxXbUtTUzVZUk1vb294UEFSc1dzSmtjU2FHU3h4Zk1YTmV1QjVG?=
 =?iso-2022-jp?B?b09RMlhxa0dZbXRtSlBDTVhybWhjR0FmL0FObm1GSVc1OGM3L3FBcUlU?=
 =?iso-2022-jp?B?YjNrdkNJYjVxT3FkbDF4ekwyRXpYK21RcUp4SEZ1SVdhVFRTUjZyOXZm?=
 =?iso-2022-jp?B?VnZ5WWdHcHBGOHFaWmYzbGFOaHVBaHJWWVpHVXFTTEJuQlFvdjNHRzJj?=
 =?iso-2022-jp?B?V0xkREw1Sk1CcUpDK2FZdkZ3VHJOSFZRb3U3Zy9jNElCYTRXdFVMRGRI?=
 =?iso-2022-jp?B?MVVqVVNKaklQNmMxcFBBb0NjN0JWMGlnTFQzSG1rUEJEZjdpU3VtdGZ2?=
 =?iso-2022-jp?B?M1JKNndyMUhraklpOHJGUEE1U0drZjE3RUJSVERqM1hrWXpxQ2JqZ0pG?=
 =?iso-2022-jp?B?OVNPTDhMRDNYb1ZoVGpWLzBuczhnWGVJUXp6ZUhwVStOKzdJYjVGVU4r?=
 =?iso-2022-jp?B?enpjSFVFSVpObnlRN0h2Zjlqd2twUGJTeE1XdnFkTFoyM2N5Qnc3VVd1?=
 =?iso-2022-jp?B?ZWZWdGVKbVBoRXlhRFV1OHBxQWVZMFRrZGtkakJSYytRQjIxbkNSSU5O?=
 =?iso-2022-jp?B?NHJwWTQydmJTNFNwTU5KWWNCNjlvaTVrYzFjaFkwQkRKS2p1NjNmaXU2?=
 =?iso-2022-jp?B?MjVFZUpVRzNXN2VEeGhnOC80V0JoRnpGMHhIRk4zeUpZaFcxUzJJQ1FX?=
 =?iso-2022-jp?B?Z0N6SzFGTUUxOFlsNnJaV1JwSy9mWDNPSjFOWTI5T0hoc2JYWC9yR1Vt?=
 =?iso-2022-jp?B?bDBGSUQ4TkZRNTlmV0ZLR3VyZXJES3dmMFJSb2RwaDhUVXJkc0c4QlJQ?=
 =?iso-2022-jp?B?Y1VCcC9RRT0=?=
Content-Type: text/plain; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: fujitsu.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: TYCPR01MB7041.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 f53bd2fb-a5fa-4eae-37fa-08da485fc2f4
X-MS-Exchange-CrossTenant-originalarrivaltime: 07 Jun 2022 08:28:55.5912
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 DuI62fDYP0BBMlGp8ujNc6sskbScMSqDQ6wCUfzM9rC/c8sZT3/mZOpSOiXKmrGMcHW8H8pdMylrAA3Quyi1M7L1+cj6ska+B/x6vy8rlvk=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYAPR01MB5610
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/TYCPR01MB7041A157067208327D8DAAF9EAA59%40TYCPR01MB7041.jpnprd01.prod.outlook.com>
Precedence: bulk

Hi.=20
(CCing Michael Meskes)

One of my customers asked me about what oracle compatibility mode in ecpg m=
eans,=20
and I noticed current documentation does not explain ecpg ORACLE compatible=
 mode  (ecpg -C ORACLE) in detail.
I myself learned the feature of "-C ORACLE"  from regression test (src/inte=
rfaces/ecpg/test/compat_oracle) and source code.=20

Is lacking documentation intentional or do commit 3b7ab4380 and 3b9b7516f j=
ust forget adding the explanation?

As for as I know, "ecpg -C ORACLE" is written briefly in ecpg command refer=
ence and PostgreSQL 11 release note,
but they are not enougn information for users to understand feature of "ecp=
g -C ORACLE".

https://www.postgresql.org/docs/current/app-ecpg.html

-------------------------------
-C mode
Set a compatibility mode. mode can be INFORMIX, INFORMIX_SE, or ORACLE.
-------------------------------

https://www.postgresql.org/docs/11/release-11.html#id-1.11.6.21.5.9
-------------------------------
Add an ecpg mode to enable Oracle Pro*C-style handling of char arrays.

This mode is enabled with -C.
-------------------------------

On the other hand, informix compatible mode is written in detail.
https://www.postgresql.org/docs/current/ecpg-informix-compat.html

Best regards,
Takeshi Ideriha