bug in COPY

From: nconway(at)klamath(dot)dyndns(dot)org (Neil Conway)
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: bug in COPY
Date: 2002-07-24 17:59:39
Message-ID: 20020724175939.GA15950@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This behavior doesn't look right:

nconway=# create table foo (a int default 50, b int default 100);
CREATE TABLE
nconway=# copy foo from stdin;
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>>
>> \.
nconway=# select * from foo;
a | b
---+---
0 |
(1 row)

(The first line of the COPY input is blank: i.e. just a newline)

The problem appears to be in both 7.2.1 and current CVS.

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-07-24 20:23:56 Re: bug in COPY
Previous Message Joe Conway 2002-07-24 16:51:10 Proposal: anonymous composite types for Table Functions (aka SRFs)