Re: [HACKERS] Unworkable column delimiter characters for COPY

2007-12-27 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: Tom Lane wrote: I think at minimum we need to forbid b, f, n, r, t, v, which are the control character representations currently recognized by COPY. But I'm tempted to make it reject all 26 lower-case ASCII letters, as a form

Re: [HACKERS] Unworkable column delimiter characters for COPY

2007-12-27 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I think at minimum we need to forbid b, f, n, r, t, v, which are the >> control character representations currently recognized by COPY. >> But I'm tempted to make it reject all 26 lower-case ASCII letters, >> as a form of future-proofi

Re: [HACKERS] Unworkable column delimiter characters for COPY

2007-12-27 Thread Andrew Dunstan
Tom Lane wrote: Currently, copy.c rejects newline, carriage return, and backslash as settings for the column delimiter character (in non-CSV mode). These all seem necessary to avoid confusion. However, I just noticed that the letters r, n, t, etc would also not work: on output, data character

[HACKERS] Unworkable column delimiter characters for COPY

2007-12-27 Thread Tom Lane
Currently, copy.c rejects newline, carriage return, and backslash as settings for the column delimiter character (in non-CSV mode). These all seem necessary to avoid confusion. However, I just noticed that the letters r, n, t, etc would also not work: on output, data characters matching such a de