Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 4151E200C26 for ; Sat, 11 Feb 2017 03:27:24 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 3FE40160B69; Sat, 11 Feb 2017 02:27:24 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 893F9160B5C for ; Sat, 11 Feb 2017 03:27:23 +0100 (CET) Received: (qmail 25497 invoked by uid 500); 11 Feb 2017 02:27:22 -0000 Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hawq.incubator.apache.org Delivered-To: mailing list dev@hawq.incubator.apache.org Received: (qmail 25485 invoked by uid 99); 11 Feb 2017 02:27:22 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 11 Feb 2017 02:27:22 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id E1FCA18495F for ; Sat, 11 Feb 2017 02:27:21 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.799 X-Spam-Level: * X-Spam-Status: No, score=1.799 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, RCVD_IN_SORBS_SPAM=0.5] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=pivotal-io.20150623.gappssmtp.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id WaOxDdp9Sb2E for ; Sat, 11 Feb 2017 02:27:19 +0000 (UTC) Received: from mail-qk0-f172.google.com (mail-qk0-f172.google.com [209.85.220.172]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 6D0CC5FB7A for ; Sat, 11 Feb 2017 02:27:19 +0000 (UTC) Received: by mail-qk0-f172.google.com with SMTP id 11so57447632qkl.3 for ; Fri, 10 Feb 2017 18:27:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pivotal-io.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=WQkn5cvvIYpxms4pOafvMiufCymTDHnEnvJsktoq+o4=; b=Ko+7j7V3Dk76ZR38kKfH2zd4gsrWOe//RQw/wKsK7dcPvtZmFnzYZCEJWBCa3diuV3 eAPjLGn0YeGErhqcu6DmBsuBX/d4bgkDvvI7HFLAeOPADBtZHHQd0oGjRKQysXiyrsao HtT8zFBGUxLkWjqitmkxXFza2TaEmKYiwYHfF/kA1gAi+ZlhCgLesHEEjwe5+HOYCffI Lj4vtq+DZHRsKz0n6DKO7G9Rmu4r5CSBBPLp0kZOpCrgI11vYvjbQ525SjuBB7rZqFS1 uA8LwwyaMgEo/lJK/F2pfzH93/oD8a8TIrEqwEA8JJOGpi3AkoFTG2WJplpzgTPgskkh 0SHg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=WQkn5cvvIYpxms4pOafvMiufCymTDHnEnvJsktoq+o4=; b=AXVbX1lDNTx3lkExaojikcq7v6yN0FaD6NnflpspBny4OnEkSjzWrU2zvQ6z82MzTi Mez8U/T95cRgNmrpAsRBFlXQ+IKKAApb3lTP8ZhXRb/+LpLoo+1J2LJOXSPPqC5jqowl 4wHU1TCSGJf6H2Ln4mjdlCib29jGSVN0OZScFfFdM7gq7bGjz88pv9DMXYQvb68va6Of IAU1TFLybvu1Q2DtcAqxm7yaAZQUkP7xcNFGcfRZy3QhWrgRz8H85aYRUyHLQFESP4Bu 9CmWDqMkevKVP0Q2FKs3CZ6Im/E9Whaccrkx2ckNMKhM6wPOJjQOGFCRkKJuHb4WqeBU p1wA== X-Gm-Message-State: AMke39mDHkr2tU2ySmdaR2w96NCNbuXz4W+1crrdoVWFrfDP+1Lwpgv3swmpqzIbpT4gA7vz9e2vBQ2vS3+qnjsM X-Received: by 10.233.216.68 with SMTP id u65mr11223385qkf.68.1486780037753; Fri, 10 Feb 2017 18:27:17 -0800 (PST) MIME-Version: 1.0 Received: by 10.55.81.135 with HTTP; Fri, 10 Feb 2017 18:27:17 -0800 (PST) From: "Alex (Oleksandr) Diachenko" Date: Fri, 10 Feb 2017 18:27:17 -0800 Message-ID: Subject: HAWQ upgrade command To: dev@hawq.incubator.apache.org Content-Type: multipart/alternative; boundary=94eb2c043ac6028392054837f42d archived-at: Sat, 11 Feb 2017 02:27:24 -0000 --94eb2c043ac6028392054837f42d Content-Type: text/plain; charset=UTF-8 Hi, I saw HAWQ-1171 was merged to master recently, and I am trying to figure out how it works. The scripts drops gp_relfile_insert_for_register procedure if it exists and creates it again using latest signature. I tried it out and it worked for me in a case when gp_relfile_insert_for_register doesn't exist. But in case when gp_relfile_insert_for_register exist I am getting: *ERROR: cannot drop function gp_relfile_insert_for_register(oid,oid,oid,oid,oid,cstring,character,character,oid) because it is required by the database system* Is it even intended to be run when procedure exists? Do I have to set any GUCs to make it work? Regards, Alex. --94eb2c043ac6028392054837f42d--