BUG #16743: psql doesn't show whole expression in stored column
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #16743: psql doesn't show whole expression in stored column |
| Дата | |
| Msg-id | 16743-7b1bacc4af76e7ad@postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #16743: psql doesn't show whole expression in stored column
|
| Список | pgsql-bugs |
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.
В списке pgsql-bugs по дате отправления: