From: | Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Weird psql problem |
Date: | 2003-08-26 15:06:51 |
Message-ID: | EC4D6DA6-D7D6-11D7-8E3E-000393C78AC0@visualdistortion.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2003-08-26 15:13:43 | Re: Linux ready for high-volume databases? |
Previous Message | Dennis Björklund | 2003-08-26 15:02:56 | Re: Index usage |