I am having an interesting problem. I have a Postgres database with a table containing a text field. In the text field is stored data that in some cases has a '*' and a newline return as the first line first few characters followed by several other lines.
The strange part is when a record is written the data looks correct, however, when the record is read all line feed and carriage returns are stripped in the response data.
I am using the GEM postgres-pr driver 0.4.0 on rails 2.0.2
Is there any reason this would occur? If I have other records without the '*' as described above the data read is correct (all new lines and returns remain).
Sample Text data written as a string, when read no line feeds or carriage returns: