Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u1RK3-002TJr-Ve for pgsql-hackers@arkaria.postgresql.org; Sun, 06 Apr 2025 14:50:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u1RK1-00F0dT-Ub for pgsql-hackers@arkaria.postgresql.org; Sun, 06 Apr 2025 14:50:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u1RK1-00F0c8-KI for pgsql-hackers@lists.postgresql.org; Sun, 06 Apr 2025 14:50:05 +0000 Received: from mail-yw1-x1134.google.com ([2607:f8b0:4864:20::1134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u1RJz-003IkI-3C for pgsql-hackers@lists.postgresql.org; Sun, 06 Apr 2025 14:50:05 +0000 Received: by mail-yw1-x1134.google.com with SMTP id 00721157ae682-6ff37565232so30952147b3.3 for ; Sun, 06 Apr 2025 07:50:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743951003; x=1744555803; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=uHqYXXrPxqrp+xqWs0xwrp5+IR6oejKoH3Z35A/tKI4=; b=XJYCOZ7/XQSS0l/6Ra1ndLGlBxSvNNumHbsglcZy7UjKsGmnqr0SiW8afPDkFrloP5 Av1EggoLFBMKeqXJBdKn5Y/3MCYTksLHWmjecVusGo6ofKqL1nf3cj6dyyRZ9jzo6U49 po0JkowoafrrYhlsCRddEx1CorXhiB7hoyaY4PjCzYxa3KTgy5AiSegZx71rZTNqTz4w rgdCSoOJcyqBURZG5ky169hI7GwZiEbrLWSVJmrPaEtSs1fxz9y9/YzaOqJm/oV+A//O i2LeiUireyutNN7x3XHz4B8pMBdrvT22hi9RY2EVhaWJvhnZS0FVsk8p/uZKqdsWM/a6 kpnQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743951003; x=1744555803; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=uHqYXXrPxqrp+xqWs0xwrp5+IR6oejKoH3Z35A/tKI4=; b=tq2BYV2nUZOk1t24jUnSmtdLBzQmvHPddAUkDm8Z3lpWHm/UgpVwBoeLf0gM0pa+69 8qS/J77tMcEM02uQFbV2mZ30D9/d4982aKMLvcBKysRM2HOHPmCQodWBk25RQmugD2sP i6UyLZ0Z/e22JbQD+uVWmWh+tmTA35/l+AGSxJYzNowHUiS15JMduaxRSStCcNkBqLzS orNn+6N8w1jHDgdCEOW48KRFyhZtWmTykF7fbMqRy1u8O7IYuDayFDvlxxw/P2wLTeOd +5gVahAKORNwxLXi9OFu8Wr3tTaQWKMlGub4uMW6SPr4PGRvQ1O19eET3h2bAnQp6cFD NJGA== X-Forwarded-Encrypted: i=1; AJvYcCWePXONmjlmZ78nz6KG9f21ZRUdH+nT60B3T4LTVUgfZL4+lyRSEf0l3mIvCBYMhruYt6q+j6A4OsZdReRi@lists.postgresql.org X-Gm-Message-State: AOJu0YxsxTEZLnCZIITsztBRvXZwA1+2l59hkUspznwXt0hbWoPCdEM3 fXjk/V4St8OLOX41MSrZNq4RCFpi/PzqFdNUjDTI0IiBMAyhzruw X-Gm-Gg: ASbGncsalsqnl4vFuphnbtYKLuHmn6YKlWs4R+aZdLtuvjJc93QN312KRf2zOgzNhgz GI6BdgAO60yX0QzxQDsvcrTZ9KDAJc3ZoZt/+YznqF5T7eI5yx+eDJ47Pxa0kFn7MMi6LFYMlwG S/uodgXKeFJ3PfeXFLV4537YUIwjwL8elakF9Q31t6Pj7CDI5od3tWWvl/oy42uZp5Mj8ow/cdp 3Vhvaq2Aa2WlvRte+nH1unSyqV6ofL3qSWY0jeMWcCJTf1qae7xRdJPdaOwI6D23ROr1orIKf2p u/6gYfXV61VUR4BPSypPi4S/gjTi6lCPslXmRcWxbuwCbJBa3606gbcO+bN4UQqF1vhGLEAhDjV jlmBUBHa1IbUsRLkXlEjcmi9llz4qbi5sZFI= X-Google-Smtp-Source: AGHT+IEEK9Qo0aFO1CpjNIb5aPgGLeaTuo9rT/fPNqiga3Tk63DabpvYe5zJWtyyV/6hyZvvV+CeOw== X-Received: by 2002:a05:690c:630a:b0:702:46a3:4721 with SMTP id 00721157ae682-703e153033amr182139047b3.15.1743951002915; Sun, 06 Apr 2025 07:50:02 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 00721157ae682-703d1e8120fsm20355527b3.54.2025.04.06.07.50.02 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 06 Apr 2025 07:50:02 -0700 (PDT) Date: Sun, 6 Apr 2025 09:50:00 -0500 From: Nathan Bossart To: Andrew Dunstan Cc: Mahendra Singh Thalor , =?iso-8859-1?Q?=C1lvaro?= Herrera , Srinath Reddy , pgsql-hackers@lists.postgresql.org Subject: Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Message-ID: References: <202503271303.dsnq652h7e7d@alvherre.pgsql> <1317bb5e-3251-42c3-8874-31fb400398f9@dunslane.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1317bb5e-3251-42c3-8874-31fb400398f9@dunslane.net> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, Apr 06, 2025 at 10:24:58AM -0400, Andrew Dunstan wrote: > On 2025-03-28 Fr 10:43 AM, Nathan Bossart wrote: >> Taking a step back, are we sure that 1) this is the right place to do these >> checks and 2) we shouldn't apply the same restrictions to all names? I'm >> wondering if it would be better to add these checks to the grammar instead >> of trying to patch up all the various places they are used in the tree. > > Maybe. I don't think there is time for that for v18, so we'd have to defer > this for now. I can live with that - it's been like this for a long time. +1, I think deferring is the right call. -- nathan