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?
Re: Garbage characters for \d table? |
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: