Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hvhhJ-0006iP-Ro for pgsql-admin@arkaria.postgresql.org; Thu, 08 Aug 2019 12:39:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hvhhI-0004CP-Fw for pgsql-admin@arkaria.postgresql.org; Thu, 08 Aug 2019 12:39:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hvhhI-0004CH-3M for pgsql-admin@lists.postgresql.org; Thu, 08 Aug 2019 12:39:12 +0000 Received: from mail-dasl.optinet.hr ([85.114.35.7]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1hvhhE-00014l-U7 for pgsql-admin@lists.postgresql.org; Thu, 08 Aug 2019 12:39:10 +0000 Received: from [192.168.0.20] (89-201-194-84.dsl.optinet.hr [89.201.194.84]) by mail-dasl.optinet.hr (OptimaMail-adsl1) with SMTP for pgsql-admin@lists.postgresql.org; Thu, 08 Aug 2019 14:39:04 +0200 (CEST) Subject: Re: Problem with schemas, possibly oids? To: pgsql-admin@lists.postgresql.org References: <3cabefc3-0713-7f5d-27c5-c0dab55cd8c6@Bios-ICT.hr> <39dd43b7-8c8a-53c4-5a0b-545e66c10bad@Bios-ICT.hr> <66506893-a4c9-ea43-24a5-e9c1decff93a@gmail.com> From: Arni Openpgp: preference=signencrypt Autocrypt: addr=Arni.Kromic@Bios-ICT.hr; prefer-encrypt=mutual; keydata= xsFNBFq+khoBEACdC7vnOWflosSNLuIZrzGNh4ADaQbLSGWQVBal0etZB+HZhLK86dKLoMPd ZQdKg3L8hTSj8mnRawDupUoi/CQeWpnhVH9QWXPtCpf7WD9u4VDK/g9i1WTOIKw+tcN/KGzC CxIXyvZgwNGy5oxTmSxwbHS9De4p9/LxceXmVIKpcqMnw213rPCN4i4x9G/owZ0cUmymdzTm +bXDlJ+LICpzDCyUSLFCYp4IXIFxSYUV8EmSqmnxcC7JZ0y+XgusnHZtfQrBrePxv0GVqJnI 4oqji+phi1i9Xq3ZytPxelsmiIXbmlhXrICBlZyE/pZZ9GqMUEw3l61kg4KcRAkSvqDkxjtl Ta3GUf7yCrCGQV/lLfFKymkdWSJtuvp9lI00JoIC+uPfhGa3RU7IP4J78KnCB1DjiPAJ+8Jo TneTZTqgTgwS8WKL8zoHqygIaI1JYNfNeJLW/bXtHsaVX9/vYRHw5kGbgjPBaPusy7EcHFnT n4RprQxjNy3CQ01L1El+QFjAg652f08Q74zDxVPJ/gql9A1lpBo73lpQ2C69xoVIQEJqs/oo hWPyRNN1gFHOty4hJn6yIJ57dUlFNVN4s080hYgwstSqKu+MFVbfQ365SHfj87OyJa0ElviC lsD2de5YSd5jFTMUCF/sCLac0jtD5iZsicaGh5m8FgyCQvCnCwARAQABzSZBcm5pIEtyb21p xIcgPGFybmkua3JvbWljQGJpb3MtaWN0LmhyPsLBlAQTAQgAPhYhBFrGWVRUJ9AMiVAUCX3z nnWrztCCBQJavpIaAhsjBQkJZgGABQsJCAcCBhUKCQgLAgQWAgMBAh4BAheAAAoJEH3znnWr ztCCYm4P/1Y7W1NjRq2GGZxlfeFI6v7sWJA5U8bpJZa+FhdHA/8XmqGvWIYCcCiXYEIi+4Id CcWfuSwkSSwZ2iJdNyvR7C7nOpYq2SWTNXRn5jE2JzSBsU+tLaoA51lTvo10Ql93OvG4ZmxH TGUPu4mXoHyLkhERdijlrzOp+cte/2++yoJpb5o0TbbeOodXRJbid0Ywo/qgSzXSn2jPoWgU bp1/gpisC70fmlo7en+KwG0ZLWI3bv0zAkGf6e7FGqBYGfOIQ/wsGIvMs27QI8T80axHuSFx VAdfElSj2oG/aicEZIj0Y40r4nAe5YHdClHl+XGTpu5rfTRb7lPQA/c6eTDgQdFEBP3gxdPC C5PrpzzlQ80Hkh2QoAXvrb1K3ZDrzIAznhazxdcFGSxy8TTer9BNVU7Vm84SYfEOZNMKm5Tw UUWIyzNe/pgVru+awTSpwztKHWhLv3EXC3kgDMkl0WBilQ2ggeyCsVMgK80xAi/osiXKVs/N yARWEykNypoeVl6LTl9Ajcxzod8D/fc84dQgiFC+tJdcnOa5fzBze6FsCWJ6Wp60Lbi9jz+P 9erwqc7eKC8xic1Sz69k9r4oqJx1ze+Gxd5zvPkRgmBcHK9xPECgRuormE+HYPjY5HBquRfj OkMM1QrbvIh6snyPXiHYNL8uWtahRqlLM01Iv9su3kzmzsFNBFq+khoBEACxJcgeuQYA/1A1 A+IdSsPBF7ZL7cqBGV1BROZSy1ugCWI88yF29CQENEBkpJ2QihIx7u1SA/8qYMGw5Nda7bUZ DfbYenznvh3lEn2eBVKeg1UMVjmrD1ZxWpy1mbzpSgjPu4AkdLG2YkbO8spjw/gd5btcZ/dP gjL9D7WwuMlCKUyyzOakdjZtD1ry2Ppps/LFPHcYBMJRWYARZruKAawI+cLTeohtFuQPxNzQ 2hVNAqZLBl7miYt6kG4nF2gYvw1eOa6XSjlvvNqTRUiZUzZOhZAE+l/tDiguu7qsud0JdBx5 FMX8nd9aS9aXajJZ54vQd/7jwikrRaqfVg7uKL6sxWggPNgxZCm7aeJZxfi5EJndgaBCoacQ K6QfMblE495DvEeVCjH/lcyW7Nx/dw4xD7kKt8SW+0hKADW9cVW0eMxeu7pz3XBBBDMNnM7c gODiTC0You5d8zCnePwXS8aWqvTuCR/yh9sKi2NQX3ogJKEPvcMhGYvRSXi+LpcUKFCcfgkt ErktPuDeqYpqe3Q0WnIsEnSKzZITm3ZLhuNdTwW0t94Wh8c/tGHS+kXQeurN2N9gg4C55F92 LIyXp2IHAqdvcoMfSRpzaQ88MDghR/N7+u5fcX7mHgcakXZdBdNgaHIeeWm55X9ntxD/1rVI SpSN0Bh8FMhqVJCGnCExBwARAQABwsF8BBgBCAAmFiEEWsZZVFQn0AyJUBQJffOedavO0IIF Alq+khoCGwwFCQlmAYAACgkQffOedavO0IIjfQ/7Bh5bViTTu6V2MtUkuGX3r5sbWv25PJOJ u2fMLhB/2FfbseP6HmuHcXx7hCPVMYKqClGtKlJJzyyTsQNw7yyfZzR1YFl1gmn6i6kWOQzj RJgEJBF1BybdGvYRW0AnrlsMKJwo9yRi0y/dd6Tqwz70/LrpdjufM5OKKfTBRS97zeY7di4Y G0iZEcCFGS+y0DQn6lT6DsJIQWattI4yKnWss7rJhLYNLa5mZIsyTceT88DicDwZLK7T/bJs LZ5iqqDjb3XQeXxpI654Z3QAjrtQ01Q+oiEZTvyYVbTaIi3UgSnNT1zp58c+lPxxjZgOhZAz 7HCCgtsQlBQW05O1t2D96EekIkKQFoFIB+wgc5EazDpRSZHKe9e+76yqWuNafRGjevNy60UI TTx05+po7kNWxd24C/MUj+otdyALGr1qmPbtbePs4LcOuQr/vhVFG9Kf4swxzx1C+Yc/icRz bblJQJTfGnHI7iQQNxMN7l0HFtlhtnyCk41cTBbM7eCDHxZNyK/Yhw+u74woiSElmhhkpIiW iXvy0/k/XoiKhGY4erYee5dDIY/DFuOv8C1g8snZ/XBEmp3u6tkZXmG5JKC0iJ87Hg623fvU SKjtNgnUGhTCURtzrIPjthErfOcIPaQdpa1h1076+2N6An7uqWnJBR6/ztqQlVP+IGemNP6y 6w0= Organization: BIOS ICT d.o.o. Split Message-ID: <0bc785cb-3849-3fcf-50c2-19baff549fcf@Bios-ICT.hr> Date: Thu, 8 Aug 2019 14:39:03 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.8.0 MIME-Version: 1.0 In-Reply-To: <66506893-a4c9-ea43-24a5-e9c1decff93a@gmail.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: hr-HR X-OM-Umi: 89.201.194.84:47176:423303 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 08/08/2019 14.33, Ron wrote: > On 8/8/19 7:30 AM, Arni wrote: >> Thank you for the response. >> >> On 08/08/2019 14.14, Ron wrote: >>> On 8/8/19 4:04 AM, Arni Kromić wrote: >>>> ...snip... >>> Maybe there's a bug in clone_schema or it's wants some assumptions >>> that you aren't fulfilling. >> I'm not sure, but clone_schema has been successfully used to create >> about 170 new schemas before this... > > I also mentioned "or it's wants some assumptions that you aren't > fulfilling" (which can also be considered a bug). > So far I can't identify anything like that. Also considering that it has worked flawlessly until now and that some other quirks (like PGAdmin's message) have occured, I believe the culprit might be somewhere else in the database...