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 1hGa4v-0002W1-9v for pgsql-admin@arkaria.postgresql.org; Wed, 17 Apr 2019 02:13:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hGa4u-0007qL-2X for pgsql-admin@arkaria.postgresql.org; Wed, 17 Apr 2019 02:13:36 +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 1hGa4t-0007q1-MW for pgsql-admin@lists.postgresql.org; Wed, 17 Apr 2019 02:13:35 +0000 Received: from mail-pf1-x431.google.com ([2607:f8b0:4864:20::431]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hGa4r-0004sb-3F for pgsql-admin@lists.postgresql.org; Wed, 17 Apr 2019 02:13:34 +0000 Received: by mail-pf1-x431.google.com with SMTP id 9so11294935pfj.13 for ; Tue, 16 Apr 2019 19:13:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language:content-transfer-encoding; bh=heTeti8p1gSF8CdaEE1168mW/nOIFgO/FlnHuqZrL6g=; b=mTV+fQMyBc0ymdveRUfpGFTfTp/skGCF7Or/6z408Zr+tK+W/i0rgpzdWzgGdeP5O6 O095imGUnyaT9QZMTZIDPfKUkzvGBpnQuLq+Mq183XKHlmy7GzKNQcrTlSgq6Cencjwt Q9k5Y6fqATbud2cYIAZs+U1Y1HPmcFs8VSCVzlMl+zqMPE53sc6RmvtI/DICZXNzmPFr Yo9pSzC54Rzcvdk5NY51d+3iMGaHkLw0xwhkGxl4REPTLZzy9Fj8iBaMiq52uQ3TPeou ZCRV9o8+6sUoep6lWcopj3DfdviJCWXZok16j3i9ThFOr+9Lj685Ev4xxpJVebIF52cI vfeA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=heTeti8p1gSF8CdaEE1168mW/nOIFgO/FlnHuqZrL6g=; b=b4BI/lboAxDAN0f5dpEhX4j/v4+BJgv1VkRN1cKLzg46kkXV9Qsjpwyzv6eYJ33ppp FiU9Md/gd1Xiv+todBfLkqrlBg/NCV1BZLkrABufOINvppQ2N6JjIfPx/fdasgzQsy4C tXhzM2TdLH5DXK7su6JIHh4VkxBOb6W2kmEzUfP6+A9SiaLzuzI131Nh1HKu8PLPv4bq wUt8lGhhdmriXhfw+9eeT3ewhwROqClZ0ZbFnvtr0C/R5rZN4ppPJPuQI3gfwc/8hi8H LvUN5cM8fYWKrpLSUZf8WLVcHFNMlguKxq530A9egecX0aLUdDx6AMY5JIdmJOlH+I2c XLkQ== X-Gm-Message-State: APjAAAVyy8SebN1u/j0VvVfcRmBF6a+hRForFXodeAsmR8595hkHEUMb ySh5fGOK3tl3bNaEu/EeKEpuN+oVr8atmHKNyGF695KtBhkm/0hOG8ZNH8CQ/BcyC3DoL5XZT+6 k31wbHLsLYXWIVBs7wytGmJ/1QMAdmp2qw5PBpapzBlpRksV+BfsHsoZnD5tCKT3icceiT5sgB2 dvKzigMgOxf3d8rSWdeQ== X-Google-Smtp-Source: APXvYqxn2CvXMOU4nbyK/Ab30zTPGJKkLFbAj9j9HLFlt1W58QP7qC9P1AWsZShBiXBI02Yt9ltdRw== X-Received: by 2002:a62:5f84:: with SMTP id t126mr86154990pfb.185.1555467211855; Tue, 16 Apr 2019 19:13:31 -0700 (PDT) Received: from osaka.octopusnet (p7663242-ipngn35201marunouchi.tokyo.ocn.ne.jp. [122.24.232.242]) by smtp.gmail.com with ESMTPSA id w11sm45314853pfi.37.2019.04.16.19.13.30 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 16 Apr 2019 19:13:31 -0700 (PDT) Subject: Re: Error when select global.service table To: =?UTF-8?B?0JXQstCz0LXQvdC40Lkg0JjQu9GO0YjQuNC9?= , pgsql-admin@lists.postgresql.org References: <8E0A5B2F-3061-47F5-91A4-F5CEA1333183@me.com> From: Ian Barwick Message-ID: <627de55f-8c06-4749-576a-c13eced5a939@2ndquadrant.com> Date: Wed, 17 Apr 2019 11:13:28 +0900 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.5.0 MIME-Version: 1.0 In-Reply-To: <8E0A5B2F-3061-47F5-91A4-F5CEA1333183@me.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 4/15/19 4:27 PM, Евгений Илюшин wrote: > Hi > this query, returned this error everytime > But it was worked in pgAdmin 4.3 This is the "pgsql-admin" mailing list, which despite the name's similarity to "pgadmin" is intended for general questions related to administration of PostgreSQL itself. You'll have a better chance of a response on the pgadmin mailing list; see: https://www.pgadmin.org/support/list/ Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services