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 1mdwKx-0001K8-KD for pgsql-www@arkaria.postgresql.org; Fri, 22 Oct 2021 15:20:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mdwKv-0006az-EM for pgsql-www@arkaria.postgresql.org; Fri, 22 Oct 2021 15:20:01 +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 1mdwKv-0006ac-7Q for pgsql-www@lists.postgresql.org; Fri, 22 Oct 2021 15:20:01 +0000 Received: from ploudseeker.com ([78.199.165.48]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mdwKt-0000uM-0E for pgsql-www@lists.postgresql.org; Fri, 22 Oct 2021 15:20:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=cmatte.me; s=myselector; t=1634915997; bh=QQZKVCoNQx+qcqrZ92Su6ZIyj2dQC7TNkey2xOhwwqg=; h=Date:To:References:From:Subject:In-Reply-To; b=g5m5Gh3ODrFl6qYttI63zCuqpN4jxrD59qS+BOX8APtLiONEDx8aivlz3t2YlhjKD tRk356BVznHSK1VX9fdKONhR7AsERinRZSGgqQNJRAMVRolewUdd6K0Y5pvQFXBers bIU1BYjYRILW2RbHOtW1472bA5EO2KBh4tduQkjSDM26XaM1emzluKRLJCOdJidHm3 HtPz5gwmgSgqkYlHe7utABggPLsqIwynYBrqY7gZF9tPIUFASs2iuXF4z36MiuTv0g G4AEzGHIZioSXmnQPD1YanILQiR01Gb8/ITLsO5jsrN6k91kN1DacRdqAF+mz6p6ag rmleVPyUS9ahw== Content-Type: multipart/mixed; boundary="------------L00OnT3P52v1eCyFHn90kDJZ" Message-ID: <71f7adb0-8588-a695-acad-f7034d3315d4@cmatte.me> Date: Fri, 22 Oct 2021 17:19:57 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.2.0 Content-Language: en-US To: pgsql-www@lists.postgresql.org References: From: =?UTF-8?Q?C=c3=a9lestin_Matte?= Subject: Re: [PATCH] pgarchives: Fix database install procedure: remove redundant tables in schema.sql In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------L00OnT3P52v1eCyFHn90kDJZ Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Hello, Apologies, patch sent in previous email of this thread is incorrect. Please find correct patch attached. In fact, the pgarchives repository is in a weird state, in which the migration adding two tables is missing (0005_apiclient_threadsubscription.py when running makemigrations). My guess is that this is because these tables use SERIALs, which django does not handle properly, and must by created using raw SQL. Am I right? Is it something that should be fixed? I would still need answers for the two questions asked in previous email: > Additionally, I have two questions: > - Where is the "tsparser" parser defined? (See commit e05f813b of pgarchives). > It is used in schema.sql, but I haven't found its definition in the > pgarchives, pglister or pgweb repositories. Is it an alias to > pg_catalog.pg_ts_parser? > (I have been able to complete the install procedure by reverting e05f813b, > but I have no idea what the consequences are for the application) > - Same question for /usr/share/postgresql/12/tsearch_data/pg_dict.stop > I've found pg_dict.syn in pgweb, but not this file. > > Cheers, > Cheers, -- Célestin Matte --------------L00OnT3P52v1eCyFHn90kDJZ Content-Type: text/x-patch; charset=UTF-8; name="0001-Fix-database-install-procedure-remove-redundant-tabl.patch" Content-Disposition: attachment; filename*0="0001-Fix-database-install-procedure-remove-redundant-tabl.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSA4Yjc2OTYwYzFiMjY1YjI2ODAxYjVjNzc5MWRiNmMzZTRmNDBiZmMzIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiA9P1VURi04P3E/Qz1DMz1BOWxlc3Rpbj0yME1hdHRl Pz0gPGdpdGxhYkBjbWF0dGUubWU+CkRhdGU6IE1vbiwgMTggT2N0IDIwMjEgMTg6MDQ6Mzcg KzAyMDAKU3ViamVjdDogW1BBVENIXSBGaXggZGF0YWJhc2UgaW5zdGFsbCBwcm9jZWR1cmU6 IHJlbW92ZSByZWR1bmRhbnQgdGFibGVzIGluCiBzY2hlbWEuc3FsCgpEamFuZ28ncyBtb2Rl bCBhbmQgc2NoZW1hLnNxbCBib3RoIGNvbnRhaW4gdGFibGVzIHRoYXQgYXJlIG5lY2Vzc2Fy eSBmb3IKdGhlIGV4ZWN1dGlvbiBvZiB0aGUgYXBwbGljYXRpb24sIGJ1dCBhcmUgbXV0dWFs bHkgZXhjbHVzaXZlLgpUaGlzIGlzIGR1ZSB0byBzb21lIGZpZWxkcyBpbiB0aGUgIm1lc3Nh Z2VzIiB0YWJsZSB0aGF0IGNhbm5vdCBiZSBkZWZpbmVkIGluCmRqYW5nbywgYW5kIGRlZmlu aXRpb24gb2YgdGFibGVzIGluIHNjaGVtYS5zcWwgdGhhdCBhcmUgYWxyZWFkeSBjcmVhdGVk CmJ5IGRqYW5nby4KLS0tCiBsb2FkZXIvc3FsL3NjaGVtYS5zcWwgfCA0MyArKysrLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiAxIGZpbGUgY2hhbmdlZCwgNCBp bnNlcnRpb25zKCspLCAzOSBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9sb2FkZXIvc3Fs L3NjaGVtYS5zcWwgYi9sb2FkZXIvc3FsL3NjaGVtYS5zcWwKaW5kZXggZDliNWQ1Zi4uYTg2 YzZhOSAxMDA2NDQKLS0tIGEvbG9hZGVyL3NxbC9zY2hlbWEuc3FsCisrKyBiL2xvYWRlci9z cWwvc2NoZW1hLnNxbApAQCAtMiwyMyArMiwxMCBAQAogCiBCRUdJTjsKIAotQ1JFQVRFIFRB QkxFIG1lc3NhZ2VzICgKLSAgIGlkIFNFUklBTCBOT1QgTlVMTCBQUklNQVJZIEtFWSwKLSAg IHBhcmVudGlkIGludCBSRUZFUkVOQ0VTIG1lc3NhZ2VzLAotICAgdGhyZWFkaWQgaW50IE5P VCBOVUxMLAotICAgX2Zyb20gdGV4dCBOT1QgTlVMTCwKLSAgIF90byB0ZXh0IE5PVCBOVUxM LAotICAgY2MgdGV4dCBOT1QgTlVMTCwKLSAgIHN1YmplY3QgdGV4dCBOT1QgTlVMTCwKLSAg IGRhdGUgdGltZXN0YW1wdHogTk9UIE5VTEwsCi0gICBsb2FkZGF0ZSB0aW1lc3RhbXB0eiBO T1QgTlVMTCBERUZBVUxUIENVUlJFTlRfVElNRVNUQU1QLAotICAgaGFzX2F0dGFjaG1lbnQg Ym9vbGVhbiBOT1QgTlVMTCwKLSAgIGhpZGRlbnN0YXR1cyBpbnQgTlVMTCwKLSAgIG1lc3Nh Z2VpZCB0ZXh0IE5PVCBOVUxMLAotICAgYm9keXR4dCB0ZXh0IE5PVCBOVUxMLAotICAgcmF3 dHh0IGJ5dGVhIE5PVCBOVUxMLAotICAgZnRpIHRzdmVjdG9yIE5PVCBOVUxMCi0pOworQUxU RVIgVEFCTEUgbWVzc2FnZXMKKyAgIEFERCBDT0xVTU4gcmF3dHh0IGJ5dGVhIE5PVCBOVUxM LAorICAgQUREIENPTFVNTiBmdGkgdHN2ZWN0b3IgTk9UIE5VTEw7CisKIENSRUFURSBJTkRF WCBpZHhfbWVzc2FnZXNfdGhyZWFkaWQgT04gbWVzc2FnZXModGhyZWFkaWQpOwogQ1JFQVRF IFVOSVFVRSBJTkRFWCBpZHhfbWVzc2FnZXNfbXNnaWQgT04gbWVzc2FnZXMobWVzc2FnZWlk KTsKIENSRUFURSBJTkRFWCBpZHhfbWVzc2FnZXNfZGF0ZSBPTiBtZXNzYWdlcyhkYXRlKTsK QEAgLTQyLDIxICsyOSw2IEBAIENSRUFURSBUQUJMRSB1bnJlc29sdmVkX21lc3NhZ2VzKAog CiBDUkVBVEUgVU5JUVVFIElOREVYIGlkeF91bnJlc29sdmVkX21zZ2lkX21lc3NhZ2UgT04g dW5yZXNvbHZlZF9tZXNzYWdlcyhtc2dpZCwgbWVzc2FnZSk7CiAKLUNSRUFURSBUQUJMRSBs aXN0Z3JvdXBzKAotICAgZ3JvdXBpZCBpbnQgTk9UIE5VTEwgUFJJTUFSWSBLRVksCi0gICBn cm91cG5hbWUgdGV4dCBOT1QgTlVMTCBVTklRVUUsCi0gICBzb3J0a2V5IGludCBOT1QgTlVM TAotKTsKLQotQ1JFQVRFIFRBQkxFIGxpc3RzKAotICAgbGlzdGlkIGludCBOT1QgTlVMTCBQ UklNQVJZIEtFWSwKLSAgIGxpc3RuYW1lIHRleHQgTk9UIE5VTEwgVU5JUVVFLAotICAgc2hv cnRkZXNjIHRleHQgTk9UIE5VTEwsCi0gICBkZXNjcmlwdGlvbiB0ZXh0IE5PVCBOVUxMLAot ICAgYWN0aXZlIGJvb2xlYW4gTk9UIE5VTEwsCi0gICBncm91cGlkIGludCBOT1QgTlVMTCBS RUZFUkVOQ0VTIGxpc3Rncm91cHMoZ3JvdXBpZCkKLSk7Ci0KIENSRUFURSBUQUJMRSBsaXN0 X21vbnRocygKICAgIGxpc3RpZCBpbnQgTk9UIE5VTEwgUkVGRVJFTkNFUyBsaXN0cyhsaXN0 aWQpLAogICAgeWVhciBpbnQgTk9UIE5VTEwsCkBAIC03MSwxMyArNDMsNiBAQCBDUkVBVEUg VEFCTEUgbGlzdF90aHJlYWRzKAogKTsKIENSRUFURSBJTkRFWCBsaXN0X3RocmVhZHNfbGlz dGlkX2lkeCBPTiBsaXN0X3RocmVhZHMobGlzdGlkKTsKIAotQ1JFQVRFIFRBQkxFIGF0dGFj aG1lbnRzKAotICAgaWQgc2VyaWFsIG5vdCBudWxsIHByaW1hcnkga2V5LAotICAgbWVzc2Fn ZSBpbnQgbm90IG51bGwgcmVmZXJlbmNlcyBtZXNzYWdlcyhpZCksCi0gICBmaWxlbmFtZSB0 ZXh0IG5vdCBudWxsLAotICAgY29udGVudHR5cGUgdGV4dCBub3QgbnVsbCwKLSAgIGF0dGFj aG1lbnQgYnl0ZWEgbm90IG51bGwKLSk7CiBDUkVBVEUgSU5ERVggaWR4X2F0dGFjaG1lbnRz X21zZyBPTiBhdHRhY2htZW50cyhtZXNzYWdlKTsKIAogQ1JFQVRFIFRBQkxFIGFwaWNsaWVu dHMoCi0tIAoyLjMzLjEKCg== --------------L00OnT3P52v1eCyFHn90kDJZ--