Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m3kFz-0001fZ-Qh for psycopg@arkaria.postgresql.org; Wed, 14 Jul 2021 19:09:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m3kFy-0008Hx-5V for psycopg@arkaria.postgresql.org; Wed, 14 Jul 2021 19:09:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m3kFx-0008Hp-Nh for psycopg@lists.postgresql.org; Wed, 14 Jul 2021 19:09:17 +0000 Received: from mail-eopbgr60064.outbound.protection.outlook.com ([40.107.6.64] helo=EUR04-DB3-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m3kFt-0004p5-Uj for psycopg@postgresql.org; Wed, 14 Jul 2021 19:09:17 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=BQcNqHJ7TKjq0V8L7UiW7H5vQcxSOx888BjMMhY5YbFhPdN410H5CtQJgfpM6e2xbwg+1SDgSq1uUHxRZU/COGWqcqse4m+z28burMMK8bLuhRcOXR3XKjTQKiFPH3+j9aEzk6JTTxxNqIdVqjSK2Hq945yfA6WCZpiMsePNCw8jseHlIcPRKdVx/Z7J4hKlhbgfJqunnM+I1E4c0Zb+IqyrpqoxAizjZLa9eBAMbW1zRDBcdS6VpxOjS60sNSQPqxL9CNRnKvip06AZglzwqauG8jyN/0UlfQFI7gX4bO2NbGcfw2EF9qHZMWIATUTPijIIAeJ9A+IwyO8SmTtnyg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=KYGMCK/nXj5lIR74XwP+f+MQ7wsflImGnMe59ybMwu4=; b=ELt/B3V9T0KwuNLoTNQnW5g4NNt+J6L1h6oehuggkB98biB1YjHXD0ZDJeSjNYLnI4o4TE+583+QGniJsvyzy1Gi+GeYIalKhL9xqID7Cbzdw1HefLvYe+drFG6JiP05H/IOvyrK1cbQ0e50VKgq+icfmDymfzkKFPhnUpnqGsn1O1SEzMlhCcbEvlP3oITAKuU3YIKRFMPSkSNO2WMQFBJPdrq6HRceNH2IJkhqc910PszTbTosm6fnztms1JRkOowB446nHodwXUAAd9bbhbwKk0Jf8wFUQcRSvNd0eJq4nPu++p/WdmCZm6nOTy4eTzyU3stZ//zBiOWBqIyvtQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=tomtom.com; dmarc=pass action=none header.from=tomtom.com; dkim=pass header.d=tomtom.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tomtom.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=KYGMCK/nXj5lIR74XwP+f+MQ7wsflImGnMe59ybMwu4=; b=o/tanz7qCLWxFSEVev2WWt/Dpe+B3PC43ddNwoCv5T7SnHlNd8IBLgJ4SMWFUdfJhIg1F8xDgKHVRcZgkdxD7OxaxIAC+8yBjvsgPXZFaw71+XjzwbdFG7nTPTkWy5IU26kIlUgQyddT5Zl9N8KYuoFYBrKgFKbt+MT0pQ3pZTw= Received: from AM0PR07MB5700.eurprd07.prod.outlook.com (2603:10a6:208:118::22) by AM0PR07MB6257.eurprd07.prod.outlook.com (2603:10a6:20b:152::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4352.8; Wed, 14 Jul 2021 19:09:04 +0000 Received: from AM0PR07MB5700.eurprd07.prod.outlook.com ([fe80::1107:535d:4d56:119f]) by AM0PR07MB5700.eurprd07.prod.outlook.com ([fe80::1107:535d:4d56:119f%6]) with mapi id 15.20.4331.021; Wed, 14 Jul 2021 19:09:04 +0000 From: David Raymond To: "psycopg@postgresql.org" Subject: RE: New user questions Thread-Topic: New user questions Thread-Index: AQHXeCMEsbh0G7vvQEagkPREhOuDgKtBckYAgAADD4CAAAW4gIABQhEAgAAU3lA= Date: Wed, 14 Jul 2021 19:09:04 +0000 Message-ID: References: <36d964b4-e04b-5fdf-9b21-d3bf80a3505d@aklaver.com> <9b477722-71af-abbb-8db7-1390a9906b07@aklaver.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=tomtom.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 694e6ba0-1231-4523-dd08-08d946fad8ac x-ms-traffictypediagnostic: AM0PR07MB6257: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:758; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: UWqild66I/PlSEjDwkMqz4kW0zGi/xhyo6mnr1yi8mmP97B/G+bQOeY2t0wYveMqVxjg8cDuzUEr3fDFTclHpEDf7SmbayRyHmpFGNRT0KBDXuVwpSs1izprJu9D4oVyK2YoFNzQgxY2ZpVg5iIAcTTnYlNwFQEMYcdf3X+FE+EedpDbOrdYEy0sJ7OC0eCrvvy39W9x4UAAhpHSgoPxHttZ3yNCYGBWj3tugmPYWQr+7UsEJFCDSL3qtnTev1hg5ytmZ22W7YIFFH7jWX4C8EBQ4vQ7J+keaAuZFsWlOGvTIoEJKRxzB7oz+ZyncSatBdxOzZXEXwkXoeTrPJLi7X4XogCDvpNnXWbaKWdwDKUMSvJtcatpaPCZdJdKoWGyn5h3/K4MW4xbFMsYcGH5Pl3py0N5cJclL41cNA8UqGe1sTpt2QmaZs0VnwFZBhRDbT1W0FUOR4lgmWDB6GTQ3LW3SA9UCE13QbflKglzitWsugQNvu+KTIAYIsnjmqbu/ndEMZhhOq7OTe7/q99C1rr8+mkv6JXLJ7rPdzYwFzPHRV42LNJ7rn/7erBsLgXwfAbZ9FlquANVhyvG0x7UhlQPih7gL+y/AqvbkdoXDLWHvYmtJCYTZY8IPacxjVdUog8gU2mAPJhzWERmCWPctuvcp1vzH0KuzJUxS3jnON8oiQY+PjdMnIJZI4iaJmNQVGH0MrFR44036hFPK5Ggd+UyKdM5lSnEQddoJGaSSV2Xvp/cNyair6Z8xZClEb11qCGqCb1vagtYfPu1zf8qaiu6yqfG50SGqFKJGeTgZMg= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM0PR07MB5700.eurprd07.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(478600001)(2906002)(71200400001)(316002)(186003)(8676002)(83380400001)(3480700007)(66946007)(26005)(7116003)(38100700002)(966005)(66476007)(122000001)(33656002)(9686003)(52536014)(86362001)(76116006)(66556008)(6916009)(66446008)(6506007)(5660300002)(64756008)(7696005)(55016002)(8936002)(38070700004);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?OHRWNnloRmJtS291R0loNGpWcFFBd3oyaTl4QnI0VXVlUy96TGpGbjJEYjQ2?= =?utf-8?B?MEJMbkpuUE5TUms2ZlhTTy85TjFrNVQyaHlObUxlYVBWek9OTGNEdHkxTzN5?= =?utf-8?B?RU1ha3VUMWkzcUJxZWVtN0FqSzJ0UFlDRjRCN3hxZ0VtZGkzQmx1b1gxY0Yy?= =?utf-8?B?QkM2NFBLd3dIT0dFdk5ibmJsajJlVmV1S2E5WEVHSXZKQTNvQ2pmaFNITzR3?= =?utf-8?B?MklXYlVUYU0zWllVcVUySTRWOWlFOWNqSURuVzdJem1IRmJDaDhMb2FURllB?= =?utf-8?B?NUFjc05QY3BDMmVQSzkwamVvU3BsQkdMejNWU041YUhXSERhRlZCWUkvZTNy?= =?utf-8?B?NzY4QlJuRlA2MVgvNU9TL3lNUHhJcTgySlhiRmJxZWZSUHpOaFBJSzByWTJW?= =?utf-8?B?dWtOaGFYaHhGdnBNRmdmdnp2R2FZMXJNbjBSZmNKTEFNci9tRHZzL29ObTdh?= =?utf-8?B?M1ZWTmQ5NEh2NGQwVXBCdTAvVXZUanlLM01pZXh0RXVpZDdSUGhiT2ZNM0JC?= =?utf-8?B?TUgzSnIrMzdaRkM1NEtjekxCbTR5QXZ0TlhyRE9YajVoQmtrVlpmT0dIZ1d6?= =?utf-8?B?R0FKWjhpMkpUNHhOTDd5VXdSWlAxbGxmaDdUV3NSb0xEanBSQzQxMzlwbDR6?= =?utf-8?B?SjRVOG14cFpvbGJ4NU83MVNWenF3cmF4VThvdi9CK0pQVnpqWHlOUjVHclhh?= =?utf-8?B?aXRRdytoQ2NxbU5XZHNqS2pkN29aMGxBZi9jWDljWTF5cmkvdVBTNkZSejFB?= =?utf-8?B?bWFpNEJzMTQvM3R5cUViSldzUTRBN05HTHJaNWdSWDlsbTY0eGNQVklYNC9v?= =?utf-8?B?cHlycjBLVmdqTjkvbzdNQk1tSTBSOFh1a2dDRlFINEFBOHhQUm42aSs2WFc1?= =?utf-8?B?NDU0VGtJMjlxazN1by9ON2xoWTg0NDBkeUJqRlFyUHk4QW04VlhudTY0aE9Z?= =?utf-8?B?NHBBSEp1cHpjTktYTmJ4N25TeldWWnVwQTI0a2o4bVROV2YzZm9ZMDVFc1g0?= =?utf-8?B?SHlJRitNTGF2ZDMwTUx1NEpGdGk1N2FVKzFXRXFkOFJGNm1sYXZ1U1RCUDRT?= =?utf-8?B?RkkzV1NKS3hCMjlHK2ZQb24xeWNJN0ZXSHcyd0c1ZHdiTVhNQ0dWbTN1eGJ3?= =?utf-8?B?L0xvbU9IcjF1MVd1MkVrU2EvZjBKdm5zUUJFY0l6WVJSSzlsYnliVTc3SGc2?= =?utf-8?B?VjhXajZnU3hheEpTSlVzempvWVY3cFMrK3NQMFI3MzF5dXhTdk56bUV0MjFL?= =?utf-8?B?OGd3bkNJZ2kzSFBTVjFPbWZyTUhBeCt0bHI0MHRPVVZnUStXdWw0LzZRL2JR?= =?utf-8?B?ZjlvMFRGTXdLVEtzUnF5amtHbTBVVXhnNWgzM1haRFgxUDkraG1NblpUQUJG?= =?utf-8?B?cVJjL3RDM0VCVE5oYU9kMnRaQXZ3OW5uajRkZXVRRkhMSzg3RzNWN0xlVlVN?= =?utf-8?B?OGJXMUUyb2VLNlJDd0h6dm4xdkwwMEsrQTB3aUE5MSt3N1prd3RiRml2ZU5G?= =?utf-8?B?azVZTEhWa3UxNEdnM3pVaFpoTXpVc2xXNCtRRWJrekFGdFVSclNYTHVRMUZL?= =?utf-8?B?TUJUUEN6dS95c1hEa20rbEE4djZRWHVXQmkvbWxzMVNCWnZBUGRldzJJQnhD?= =?utf-8?B?aWEvbld4NTZiN3cwMkdJRGRuVWd5ejFiaGpQNGQ4TndaSXptZ3FqdmNKZ3Bq?= =?utf-8?B?dTdRcDdQWG1ZVlFiRkFUWWpGRjR3ZWdNMyt1Qi9tdDVpMFplOUp0UmUrVzFy?= =?utf-8?Q?B8iB44xS5W7/q+tLHM6e5bmNiS28H6ua9yUEZOi?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: tomtom.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AM0PR07MB5700.eurprd07.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 694e6ba0-1231-4523-dd08-08d946fad8ac X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Jul 2021 19:09:04.0301 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 374f8026-7b54-4a3a-b87d-328fa26ec10d X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: xgWGp0U7f7WMLhklwItt7vc3EAto0F6rAZRvziasFrDK0/S0rR+1uwfOVhQDc6xrxqNOspf3tEEeh5rhOlpTHZBHn2NuJPQTe//GStDDurc= X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM0PR07MB6257 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RnJvbSBodHRwczovL3d3dy5wc3ljb3BnLm9yZy9kb2NzL3NxbC5odG1sDQoNCiJUaGUgbW9kdWxl IGNvbnRhaW5zIG9iamVjdHMgYW5kIGZ1bmN0aW9ucyB1c2VmdWwgdG8gZ2VuZXJhdGUgU1FMIGR5 bmFtaWNhbGx5LCBpbiBhIGNvbnZlbmllbnQgYW5kIHNhZmUgd2F5LiINCg0KSWYgdGhlcmUncyBu b3RoaW5nIGR5bmFtaWMgYWJvdXQgdGhlIHRleHQgb2YgdGhlIHF1ZXJ5LCB0aGVuIHlvdSBkb24n dCByZWFsbHkgbmVlZCB0byBnbyB0aHJvdWdoIGFsbCB0aGUgdHJvdWJsZSBvZiB1c2luZyBhbGwg dGhvc2UgY2xhc3Nlcy4gVGhleSdyZSB0aGVyZSBpbiBjYXNlIHlvdSdyZSBnZXR0aW5nIHVua25v d24gdGFibGUgbmFtZXMgZnJvbSBhIHVzZXIsIG9yIGJ1aWxkaW5nIGEgcXVlcnkgb24gdGhlIGZs eSwgZXRjLiBJZiB5b3Uga25vdyB0aGUgcXVlcnkgcmlnaHQgbm93LCB5b3UgY2FuIGp1c3QgcHV0 IGl0IGludG8gYSB0ZXh0IHN0cmluZywgYW5kIGNhbGwgaXQgZ29vZC4NCg0KU28geW91ciBxdWVy eTIgbWlnaHQgbG9vayBzb21ldGhpbmcgbGlrZSB0aGlzOg0KDQpxdWVyeSA9ICIiInNlbGVjdA0K cC5sbmFtZSwNCnAuZm5hbWUsDQpwLmxvY19uYnIsDQpwLmpvYl90aXRsZSwNCnAuZGlyZWN0X3Bo b25lLA0KcC5hY3RpdmUsDQpjLm9yZ19uYW1lLA0KbC5sb2NfbmJyLA0KbC5sb2NfbmFtZSwNCmEu YWN0X2RhdGUsDQphLmFjdF90eXBlLA0KYS5ub3RlcywNCmEubmV4dF9jb250YWN0DQpmcm9tDQpw ZW9wbGUgYXMgcA0KaW5uZXIgam9pbiBjb21wYW5pZXMgYXMgYyBvbiBjLm9yZ19uYnIgPSBwLm9y Z19uYnINCmlubmVyIGpvaW4gbG9jYXRpb25zIGFzIGwgb24gbC5vcmdfbmJyID0gby5vcmdfbmJy IGFuZCBsLmxvY19uYnIgPSBwLmxvY19uYnINCmlubmVyIGpvaW4gY29udGFjdHMgYXMgYSBvbiBh LnBlcnNvbl9uYnIgPSBwLnBlcnNvbl9uYnINCndoZXJlIHAubG5hbWUgPSAlcyBhbmQgcC5mbmFt ZSA9ICVzDQpncm91cCBieSBhLmFjdF9kYXRlIG9yZGVyIGJ5IGEuYWN0X2RhdGU7IiIiDQoNCmN1 ci5leGVjdXRlKHF1ZXJ5LCAobG5hbWVfdmFsdWUsIGZuYW1lX3ZhbHVlKSkNCg0KTm90ZSB0aGF0 IEkgZG9uJ3QgdGhpbmsgdGhpcyBxdWVyeSBvZiB5b3VycyBpcyBnb25uYSB3b3JrIGFzIHlvdSd2 ZSBnb3QgYSBHUk9VUCBCWSBjbGF1c2UsIGFuZCB0aGUgU0VMRUNUIGxpc3QgeW91IGhhdmUgc3R1 ZmYgdGhhdCdzIG5vdCBpbiB0aGUgR1JPVVAgQlksIGFuZCBpcyBub3QgYW4gYWdncmVnYXRlLg0K