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.