Weird psql problem - Mailing list pgsql-general

From Jeffrey Melloy
Subject Weird psql problem
Date
Msg-id EC4D6DA6-D7D6-11D7-8E3E-000393C78AC0@visualdistortion.org
Whole thread Raw
Responses Re: Weird psql problem  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
I recently noticed that in my web app, a \n wasn't getting converted to
a <br />.  (The problem turned out to be that for this particular
record, it was a \r).

When I checked out the record in psql, I got some weird behavior.

What shows up in the web:
amoth4:it is o.o
jm:Speaking of being a sounding board, will you test something?
jm:Ot
jm:It's pretty quick

What shows up in psql:
jmelloy=# select * from messages where message_id = 219897;
  message_id |        message_date        |
                      message
        | sender_id | recipient_id |
  message_idx
------------+----------------------------
+-----------------------------------------------------------------------
--------------------------------------+-----------+--------------
+-----------------------------------------------------------------------
----------------
jm:It's pretty quick |         4 |          126 | 's' 'jm' 'ot' 'o.o'
'test' 'board' 'quick' 'sound' 'speak' 'amoth4' 'pretti' 'someth'

Something is definitely weird.  Using version 7.3 on OS X.

Jeff


pgsql-general by date:

Previous
From: Andreas Fromm
Date:
Subject: Re: many columns with references to one table
Next
From: Tom Lane
Date:
Subject: Re: 7.4b1 vs 7.3.4 performance