Skip site navigation (1) Skip section navigation (2)

Garbage characters for \d table?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Garbage characters for \d table?
Date: 2004-08-17 19:49:06
Message-ID: 200408171249.06206.josh@agliodbs.com (view raw or flat)
Thread:
Lists: 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(at)agliodbs(dot)com	 www.agliodbs.com
Ph: 415-752-2500	Fax: 415-752-2387
2166 Hayes Suite 200	San Francisco, CA

Responses

pgsql-bugs by date

Next:From: Josh BerkusDate: 2004-08-17 19:58:17
Subject: Re: Garbage characters for \d table?
Previous:From: Stefanos HarhalakisDate: 2004-08-17 19:11:26
Subject: pgsql 8.0.0b1 - openssl detection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group