Garbage characters for \d table? - Mailing list pgsql-bugs

From Josh Berkus
Subject Garbage characters for \d table?
Date
Msg-id 200408171249.06206.josh@agliodbs.com
Whole thread Raw
Responses Re: Garbage characters for \d table?  (Josh Berkus <josh@agliodbs.com>)
Re: Garbage characters for \d table?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Bug summary: PSQL's \d table displaying garbage characters for one table.
Severity:  Annoyance
Reproducability: Poor
Version:  7.4.3 on the client, 7.4.1 on the server.  Both compiled from
source.
Platform: SuSE Linux 9.1, Linux Kernel 2.6.7 (client), RH Linux 8.0 on server.
    Connection btw. client <--> server is over SSH tunnel.

When I do a \d on one table in PSQL, I get the following:

                Table "public.elbs_timekeep"
      Column       |            Type             | Modifiers
-------------------+-----------------------------+-----------
 240240240240240240240240tkinit    | character varying(8)        |
 240240240240240240240240tksort    | integer                     |
 240240240240240240240240tklast    | character varying(20)       |
 240240240240240240240240tkfirst   | character varying(20)       |
 240240240240240240240240tktitle   | character varying(15)       |
 240240240240240240240240tktmdate  | timestamp without time zone |
 240240240240240240240240tkloc     | character varying(4)        |
 240240240240240240240240tkemdate  | timestamp without time zone |
 240240240240240240240240tkinitb   | character varying(8)        |
 240240240240240240240240tglmask   | character varying(64)       |
 240240240240240240240240tkblast   | character varying(20)       |
 240240240240240240240240tkbfirst  | character varying(20)       |
 240240240240240240240240tkstrate  | numeric                     |
 240240240240240240240240tkdept    | character varying(10)       |
 240240240240240240240240tksect    | character varying(10)       |
 240240240240240240240240tkschool  | character varying(20)       |
 240240240240240240240240tkgrdate  | timestamp without time zone |
 240240240240240240240240tkbrdate  | timestamp without time zone |
 240240240240240240240240tkstdcst  | numeric                     |
 240240240240240240240240tprotem   | character varying(7)        |
 240240240240240240240240tkeflag   | character varying(1)        |
 240240240240240240240240tkemail   | character varying(50)       |
 240240240240240240240240tkmoddate | timestamp without time zone |
 240240240240240240240240tkmodtime | character varying(8)        |
 240240240240240240240240tkmoduser | character varying(8)        |
 240240240240240240240240tkceflag  | character varying(1)        |

This does NOT happen:
1) on other tables;
2) when I use PSQL on the server.

Frankly, the circumstances are peculiar enough that I don't expect you to do
anything about this bug report; instead I'm filing it in case any related
problems crop up with 7.4's PSQL.

And, yes, I tried re-connecting in case this was somehow line noise.

--
__Aglio Database Solutions_______________
Josh Berkus               Consultant
josh@agliodbs.com     www.agliodbs.com
Ph: 415-752-2500    Fax: 415-752-2387
2166 Hayes Suite 200    San Francisco, CA

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1222: database owner should have implicit control over public db schema
Next
From: Josh Berkus
Date:
Subject: Re: Garbage characters for \d table?