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 по дате отправления: