[ADMIN] Bug in psql's "-R" option?
There seems to be a bug in psql's -R option (and the -P recordsep= ) version. I find that whereas the following succeeds: /usr/local/pgsql/bin/psql -U -d -h \ -P format=unaligned -P fieldsep='\t' -P tuples_only \ -c "select * from tab where yoo='hoo'" | /usr/local/pgsql/bin/psql -U -d -h \ -c "copy bar from stdin" adding -R '\n' or -P recordsep='\n' or -P recordsep=newline all give an error that the last field's data is too long for that field's format. Presently, this seems a bogus option, since the COPY command cannot handle any record separator except a newline, but the documentation for the "copy from" command states that '\n' will be parsed as a newline, so this seems a bug. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] Bug in psql's "-R" option?
psql -R controls the record separator for query output, not COPY. --- Murthy Kambhampaty wrote: > There seems to be a bug in psql's -R option (and the -P recordsep= ) > version. I find that whereas the following succeeds: > > /usr/local/pgsql/bin/psql -U -d -h \ > -P format=unaligned -P fieldsep='\t' -P tuples_only \ > -c "select * from tab where yoo='hoo'" | /usr/local/pgsql/bin/psql > -U -d -h \ > -c "copy bar from stdin" > > adding -R '\n' or -P recordsep='\n' or -P recordsep=newline all give an > error that the last field's data is too long for that field's format. > Presently, this seems a bogus option, since the COPY command cannot handle > any record separator except a newline, but the documentation for the "copy > from" command states that '\n' will be parsed as a newline, so this seems a > bug. > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] Bug in psql's "-R" option?
OK, sorry for the muddle-headed post (I realized my error as I walked away from my desk ...). The bug seems to be in the copy from parsing, which does not follow the documentation as I related in my original message. -Original Message- From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us] Sent: Tuesday, November 05, 2002 14:21 To: Murthy Kambhampaty Cc: '[EMAIL PROTECTED]' Subject: Re: [ADMIN] Bug in psql's "-R" option? psql -R controls the record separator for query output, not COPY. --- Murthy Kambhampaty wrote: > There seems to be a bug in psql's -R option (and the -P recordsep= ) > version. I find that whereas the following succeeds: > > /usr/local/pgsql/bin/psql -U -d -h \ > -P format=unaligned -P fieldsep='\t' -P tuples_only \ > -c "select * from tab where yoo='hoo'" | /usr/local/pgsql/bin/psql > -U -d -h \ > -c "copy bar from stdin" > > adding -R '\n' or -P recordsep='\n' or -P recordsep=newline all give an > error that the last field's data is too long for that field's format. > Presently, this seems a bogus option, since the COPY command cannot handle > any record separator except a newline, but the documentation for the "copy > from" command states that '\n' will be parsed as a newline, so this seems a > bug. > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]