| From: | "Luiz K(dot) Matsumura" <luiz(at)planit(dot)com(dot)br> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | problem with CR+LF in files in psql \i command |
| Date: | 2005-03-10 03:31:56 |
| Message-ID: | 422FBFAC.6010102@planit.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Hi,
I need to backup my database with pg_dump and recover it in other
windows machine.
I recover my database running the pg_dump generated script in psql with
\i command
At each time I do this operation , misteriously the space between lines
multiplies in my functions and comments.
Well, I discover that when I use \i <file> command in psql with a file
generated in windows format ( CR+LF terminated lines) psql actually
sends the CR character at each line break to postgres, causing this effect.
I make a change in input.c that resolve this problem, but I'm not a
expert in c, therefore if someone have a better solution,
please do the necessary changes.
Thanks in advance.
| Attachment | Content-Type | Size |
|---|---|---|
| input.c.diff | text/plain | 411 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-03-10 03:51:27 | Re: [pgsql-hackers-win32] snprintf causes regression tests |
| Previous Message | Tom Lane | 2005-03-09 22:34:01 | Re: Functions and transactions |