From: Bruce Momjian <bruce@momjian.us>
To: jim_gray@cox.net
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16304: ECPG won't accept input from STDIN
Date: Sun, 22 Mar 2020 22:45:09 -0400
Message-ID: <20200323024509.GD2031@momjian.us> (raw)
In-Reply-To: <16304-c662b00a1322db7f@postgresql.org>
References: <16304-c662b00a1322db7f@postgresql.org>
On Mon, Mar 16, 2020 at 08:48:22PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 16304
> Logged by: James Gray
> Email address: jim_gray@cox.net
> PostgreSQL version: 11.5
> Operating system: AIX
> Description:
>
> On an older version (9.6.3) of Postgres on CentOS 7.7.1908, ECPG accepts
> input from STDIN:
>
> [singha7] (jgray) ~> psql --version
> psql (PostgreSQL) 9.6.3
> [singha7] (jgray) ~>
>
> [singha7] (jgray) ~> ecpg -o - -
> /* Processed by ecpg (4.12.0) */
> /* These include files are added by the preprocessor */
> #include <ecpglib.h>
> #include <ecpgerrno.h>
> #include <sqlca.h>
> /* End of automatic include section */
>
> #line 1 "stdin"
> ^C
> [singha7] (jgray) ~>
>
> On a newer version (11.5) of Postgres on AIX 7.2, ECPG does NOT accept input
> from STDIN:
>
> bash-5.0$ psql --version
> psql (PostgreSQL) 11.5
> bash-5.0$
>
> bash-5.0$ ecpg -o - -
> Try "ecpg --help" for more information.
> bash-5.0$
>
> I suspect a problem in the Postgres version of getopt_long.c
Yeah, you might be right. In some cases we use the libc (maybe GNU)
getopt-long, and in other cases we use our own version, and there are
behavioral differences between the two. The fact you are testing on
CentOS and the other on AIX probably explains it. I think using
/dev/stdin should work on both.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: bruce@momjian.us, jim_gray@cox.net, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16304: ECPG won't accept input from STDIN
In-Reply-To: <20200323024509.GD2031@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox