BUG #16743: psql doesn't show whole expression in stored column

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: turon(dot)david(at)seznam(dot)cz
Subject: BUG #16743: psql doesn't show whole expression in stored column
Date: 2020-11-24 14:17:09
Message-ID: 16743-7b1bacc4af76e7ad@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16743
Logged by: David Turon
Email address: turon(dot)david(at)seznam(dot)cz
PostgreSQL version: 12.5
Operating system: CentOS 7
Description:

Good morning,

when generated column expression length is larger then some value - the rest
of expression is cut in \d[+] output:

CREATE TABLE test(
a text,
b text,
c text,
d text,
ts_vector tsvector GENERATED ALWAYS AS (
setweight(to_tsvector('simple', COALESCE(a, '')), 'A') ||
setweight(to_tsvector('simple', COALESCE(b, '')), 'B') ||
setweight(to_tsvector('simple', COALESCE(c, '')), 'C') ||
setweight(to_tsvector('simple', COALESCE(d, '')), 'D')) STORED
);

postgres(at)pgdist:test=# \d test

Tabulka "public.test"
Sloupec | Typ | Collation | Nullable |
Implicitně

-----------+----------+-----------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------
a | text | | |
b | text | | |
c | text | | |
d | text | | |
ts_vector | tsvector | | | generated always as
(((setweight(to_tsvector('simple'::regconfig, COALESCE(a, ''::text)),
'A'::"char") || setweight(to_tsvector('simple'::regconfig, ) stored

psql (12.5) server/client

pager is off, only way to show whole expresion is use pg_dump i think. Maybe
it was the intention and isn't bug. Thanks.

Best regards
David T.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-11-24 15:46:57 Re: BUG #16743: psql doesn't show whole expression in stored column
Previous Message Sandeep Thakkar 2020-11-24 05:49:55 Re: BUG #16740: Conflicting installations