Skip site navigation (1) Skip section navigation (2)

Re: BUG #6227: No arguments for COPY OIDS and HEADER

From: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6227: No arguments for COPY OIDS and HEADER
Date: 2011-09-28 03:06:22
Message-ID: CAJW2+qdtLz2k4zOaaPOmk5m6xcMHH9upVZh1w+hdEM=Qr+P+rg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, Sep 28, 2011 at 11:05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Itagaki Takahiro" <itagaki(dot)takahiro(at)gmail(dot)com> writes:
>> Our documentation says OIDS and HEADER options in COPY command take [
>> boolean ] arguments, but actually they don't accept any arguments. We can
>> only set them to TRUE by specifying their names.
>
> Um, these examples all work fine for me in HEAD:

Ah, I was wrong.
The new COPY syntax with parentheses accepts boolean values:

OK: COPY tbl FROM '/file' WITH (OIDS true)
NG: COPY tbl FROM '/file' WITH OIDS true

So, no bugs in the docs. Sorry.

-- 
Itagaki Takahiro

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-09-28 03:30:42
Subject: Re: BUG #6230: strange changes in behavior of string functions
Previous:From: Dmitry RyabovDate: 2011-09-28 02:18:31
Subject: BUG #6230: strange changes in behavior of string functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group