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 1hgQS6-0006VF-OT for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Jun 2019 09:12:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hgQS5-0000AR-JU for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Jun 2019 09:12:21 +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 1hgQS4-00005H-UY for pgsql-hackers@lists.postgresql.org; Thu, 27 Jun 2019 09:12:21 +0000 Received: from cyclops.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hgQS1-0003GZ-Vr for pgsql-hackers@lists.postgresql.org; Thu, 27 Jun 2019 09:12:19 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 059F121C40AF for ; Thu, 27 Jun 2019 12:12:16 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru X-Spam-Flag: NO X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=x tagged_above=-99 required=4 WHITELISTED tests=[] autolearn=unavailable Received: from [192.168.27.237] (gw.postgrespro.ru [93.174.131.141]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id D4E7821C40AD for ; Thu, 27 Jun 2019 12:12:15 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1561626735; bh=ojz/7uej/mz8ypdWlyAve9w58IrvX58D+duHb/vRaKc=; h=To:From:Subject:Date; b=UTB4Xy34KltcmMyaghsbinGMhBeCMV7kHb1LLNI0bBi/EkUycnBDMefpracJnAlqs +8HwrVOze8Kz+/9/Ckngm2XNrQHrC8TAdNz5sfQbewYcIv0jkFt7wJUuXAfrzycFRB UO5Rk0/ozXLO96654chEe+RRd+RAyaQ222pjPoZ8= To: PostgreSQL Hackers From: Arthur Zakirov Subject: Extra quote_all_identifiers in _dumpOptions Message-ID: Date: Thu, 27 Jun 2019 12:12:15 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.7.1 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------E67D81C5AD5009E440A4A885" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------E67D81C5AD5009E440A4A885 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hello hackers, While working on pg_dump I noticed the extra quote_all_identifiers in _dumpOptions struct. I attached the patch. It came from refactoring by 0eea8047bf. There is also a discussion: https://www.postgresql.org/message-id/CACw0%2B13ZUcXbj9GKJNGZTkym1SXhwRu28nxHoJMoX5Qwmbg_%2Bw%40mail.gmail.com Initially the patch proposed to use quote_all_identifiers of _dumpOptions. But then everyone came to a decision to use global quote_all_identifiers from string_utils.c, because fmtId() uses it. -- Arthur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company --------------E67D81C5AD5009E440A4A885 Content-Type: text/x-patch; name="extra_quote_all_identifiers.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="extra_quote_all_identifiers.patch" diff --git a/src/bin/pg_dump/pg_backup.h b/src/bin/pg_dump/pg_backup.h index db30b54a92..8c0cedcd98 100644 --- a/src/bin/pg_dump/pg_backup.h +++ b/src/bin/pg_dump/pg_backup.h @@ -153,7 +153,6 @@ typedef struct _dumpOptions int no_synchronized_snapshots; int no_unlogged_table_data; int serializable_deferrable; - int quote_all_identifiers; int disable_triggers; int outputNoTablespaces; int use_setsessauth; --------------E67D81C5AD5009E440A4A885--