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 1hvhQX-00065F-Vi for pgsql-admin@arkaria.postgresql.org; Thu, 08 Aug 2019 12:21:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hvhQW-0001VJ-Ck for pgsql-admin@arkaria.postgresql.org; Thu, 08 Aug 2019 12:21:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hvhQW-0001VC-3J for pgsql-admin@lists.postgresql.org; Thu, 08 Aug 2019 12:21:52 +0000 Received: from mail-dasl.optinet.hr ([85.114.35.2]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hvhQT-00022x-Oz for pgsql-admin@lists.postgresql.org; Thu, 08 Aug 2019 12:21:51 +0000 Received: from [192.168.0.20] (89-201-194-84.dsl.optinet.hr [89.201.194.84]) by mail-dasl.optinet.hr (OptimaMail-adsl2) with SMTP for pgsql-admin@lists.postgresql.org; Thu, 08 Aug 2019 14:21:47 +0200 (CEST) Subject: Re: Problem with schemas, possibly oids? To: pgsql-admin@lists.postgresql.org References: <3cabefc3-0713-7f5d-27c5-c0dab55cd8c6@Bios-ICT.hr> 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: Date: Thu, 8 Aug 2019 14:21:47 +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: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: hr-HR X-OM-Umi: 89.201.194.84:44142:973607 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Thank you for your response. On 08/08/2019 14.08, Luca Ferrari wrote: > On Thu, Aug 8, 2019 at 11:04 AM Arni Kromić wrote: >> Moreover, trying to clone some of the existing schemas also fails: >> call clone_schema ('HR16101766338-2018', 'test') >> >> NOTICE: source schema HR16101766338-2018 does not exist! >> >> The source schema DOES exist. > This could lead to a catalog corruption, even if it is a lot strange! > What does: > SELECT oid, nspname FROM pg_namespace WHERE nspname = quote_ident( > 'HR16101766338-2018'); > > return? That returns nothing... > And what about > > SELECT oid, nspname FROM pg_namespace WHERE nspname like > '%HR16101766338-2018%'; > > Luca > > > This works! I get:  oid  |      nspname -------+--------------------  16385 | HR16101766338-2018 (1 row) I get the same thing if I try with '%HR16101766338-2018'. So it seems as if there were some characters prepended to the name... I've checked for spaces, but there are none. What could this mean?