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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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