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
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 |