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.
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 |