Re: pg_dump: Too much <SPACE> in COPY ouput

> pgsql-bugs(at)postgresql(dot)org writes:
> > Example form two pg_dump outputs
> > 7.1.2 :
> > COPY "list" FROM stdin;
> > 7.0.2 :
> > COPY "list" FROM stdin;
>
> I have a very hard time considering that a bug...

Looks like an easy fix. In fact, the coder had a space after WITH OIDS
already, so there is no need for the extra space after the second %s:

if (oids == true)
oidsPart = "WITH OIDS ";
else
oidsPart = "";
...

sprintf(copyBuf, "COPY %s %sFROM stdin;\n", fmtId(tblinfo[i].relname, force_quotes),
oidsPart);

Patch applied.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026