From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: turon.david@seznam.cz
Subject: BUG #16743: psql doesn't show whole expression in stored column
Date: Tue, 24 Nov 2020 14:17:09 +0000
Message-ID: <16743-7b1bacc4af76e7ad@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16743
Logged by: David Turon
Email address: turon.david@seznam.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@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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, turon.david@seznam.cz
Subject: Re: BUG #16743: psql doesn't show whole expression in stored column
In-Reply-To: <16743-7b1bacc4af76e7ad@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox