BUG #15051: Additional information to bug

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: alkonstantinov(at)outlook(dot)com
Subject: BUG #15051: Additional information to bug
Date: 2018-02-05 12:01:50
Message-ID: 151783211024.1240.1027113681603902624@wrigleys.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: 15051
Logged by: Alexander Konstantinov
Email address: alkonstantinov(at)outlook(dot)com
PostgreSQL version: 10.0
Operating system: Ubuntu
Description:

This is additional information to bug #15040
This is the loop in the end of the function which does RETURN NEXT:

FOR ord , doc_id, score , titles, org_id, langs, thematics, doctype,
from_dt, to_dt, dtad_from, dtad_to, dtterm_from, dtterm_to, dtif_from,
dtif_to IN
SELECT t.id , t.doc_id, t.score, jsonb_agg(d.title)/*, t.excerpt*/,
t.org_id, t.langs::jsonb, t.thematics::jsonb, d.typ, t.from_dt::date,
t.to_dt::date,
t.dtad_from::date, t.dtad_to::date, t.dtterm_from::date,
t.dtterm_to::date, t.dtif_from::date, t.dtif_to::date
FROM _t t JOIN lucy.vw_docs_txt_mat d ON t.doc_id = d.doc_id
GROUP BY t.id, t.doc_id, t.score, d.typ
ORDER BY t.id-- DESC
OFFSET _offset LIMIT _count
LOOP
SELECT INTO _ex t.excerpt FROM _t t WHERE t.id = ord;
-- SELECT INTO excerpt _ex; -- Doesn't work
-- SELECT INTO excerpt _ex::varchar; -- Works if field is of type
varchar(text)
SELECT INTO excerpt _ex::varchar::jsonb; -- works!!!, and _ex е is of
type jsonb???
RETURN NEXT;
END LOOP;

Browse pgsql-bugs by date

  From Date Subject
Next Message Petr Jelinek 2018-02-05 15:33:14 Re: BUG #15044: materialized views incompatibility with logical replication in postgres 10
Previous Message Pavan Teja 2018-02-05 11:45:01 Re: BUG #15049: Initdb.exe failing to create DB