MIME-Version: 1.0
In-Reply-To: <17560.1461945824@sss.pgh.pa.us>
References: 
 <CABS=F1+aHKpE9Z2CwnffwCOxRKn9pFuYBsoAkHCL82YLm2q3eg@mail.gmail.com>
	<CACjxUsM_4O40y_bMjh3UAMmY1q3dTqecJzqRBJFzp-wkZcYCGg@mail.gmail.com>
	<CABS=F1+hjzqLgkx23p6RqPkyim_c2GOdMdsBZgGj27qAwwEyxw@mail.gmail.com>
	<CACjxUsMcsVT3N_znoWem2BtFvHtKtnNFKcJauVT4krtpjujgAw@mail.gmail.com>
	<17560.1461945824@sss.pgh.pa.us>
Date: Fri, 29 Apr 2016 13:30:07 -0300
Message-ID: 
 <CABS=F1+WaN1wXgDY1b+DMOTgGqgWjAoeMuZUiH5zOWVYO+A7gw@mail.gmail.com>
Subject: Re: COPY options
From: "Andrei M. Eichler" <andrei.eichler@unicheck.com.br>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kevin Grittner <kgrittn@gmail.com>,
	"pgsql-docs@postgresql.org" <pgsql-docs@postgresql.org>
Content-Type: multipart/alternative; boundary=94eb2c0cc3f6e1e39b0531a227aa
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--94eb2c0cc3f6e1e39b0531a227aa
Content-Type: text/plain; charset=UTF-8

Thanks for the replies, I'm using postgres since 8.3 and didn't notice at
the time of 9.0 release the change in the syntax, as the old syntax still
works, every time I read the current documentation I didn't notice that I
was using it wrong.

I agree with Tom Lane about leaving it alone.

Another question, I don't know if I should ask it here, why FORCE_NOT_NULL
and FORCE_NULL doesn't allow * as list of columns as FORCE_QUOTE?

2016-04-29 13:03 GMT-03:00 Tom Lane <tgl@sss.pgh.pa.us>:

> Kevin Grittner <kgrittn@gmail.com> writes:
> > It's not really a question of whether we should go back to
> > documenting the deprecated syntax, but whether (and when) support
> > for it should finally be ripped out.  It was last documented in 8.4.
>
> We still document, and support, not only the pre-9.0 COPY syntax but
> also the pre-7.3 COPY syntax; see the bottom of the COPY reference page.
> The timescale for getting rid of that kind of thing is *really* long,
> in part for fear of breaking old pg_dump backups.
>
> BTW, so far as FORCE NULL goes, I think that feature was implemented
> earlier in the 9.0 cycle than where we put in the new generalized
> option syntax.  When we did the latter, we reverted the documentation
> of the old syntax to exactly match 8.4, but did not take out the
> gram.y production allowing the never-released FORCE NULL syntax.
> I do not recall if that was intentional or an oversight.
> We could (a) document it, (b) remove it, or (c) leave it alone.
> At this point I favor the benign neglect approach.
>
>                         regards, tom lane
>

--94eb2c0cc3f6e1e39b0531a227aa
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks for the replies, I&#39;m using postgres since 8.3 a=
nd didn&#39;t notice at the time of 9.0 release the change in the syntax, a=
s the old syntax still works, every time I read the current documentation I=
 didn&#39;t notice that I was using it wrong.<div><br></div><div>I agree wi=
th Tom Lane about leaving it alone.</div><div><br></div>Another question, I=
 don&#39;t know if I should ask it here, why FORCE_NOT_NULL and FORCE_NULL =
doesn&#39;t allow * as list of columns as FORCE_QUOTE?</div><div class=3D"g=
mail_extra"><br><div class=3D"gmail_quote">2016-04-29 13:03 GMT-03:00 Tom L=
ane <span dir=3D"ltr">&lt;<a href=3D"mailto:tgl@sss.pgh.pa.us" target=3D"_b=
lank">tgl@sss.pgh.pa.us</a>&gt;</span>:<br><blockquote class=3D"gmail_quote=
" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><=
span class=3D"">Kevin Grittner &lt;<a href=3D"mailto:kgrittn@gmail.com">kgr=
ittn@gmail.com</a>&gt; writes:<br>
&gt; It&#39;s not really a question of whether we should go back to<br>
&gt; documenting the deprecated syntax, but whether (and when) support<br>
&gt; for it should finally be ripped out.=C2=A0 It was last documented in 8=
.4.<br>
<br>
</span>We still document, and support, not only the pre-9.0 COPY syntax but=
<br>
also the pre-7.3 COPY syntax; see the bottom of the COPY reference page.<br=
>
The timescale for getting rid of that kind of thing is *really* long,<br>
in part for fear of breaking old pg_dump backups.<br>
<br>
BTW, so far as FORCE NULL goes, I think that feature was implemented<br>
earlier in the 9.0 cycle than where we put in the new generalized<br>
option syntax.=C2=A0 When we did the latter, we reverted the documentation<=
br>
of the old syntax to exactly match 8.4, but did not take out the<br>
gram.y production allowing the never-released FORCE NULL syntax.<br>
I do not recall if that was intentional or an oversight.<br>
We could (a) document it, (b) remove it, or (c) leave it alone.<br>
At this point I favor the benign neglect approach.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div><br></div>

--94eb2c0cc3f6e1e39b0531a227aa--