pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedAW: BUG #18189: Value partitioned tables: Upd ERROR: more than one row returned by a subquery used as an expression
2+ messages / 2 participants
[nested] [flat]
* AW: BUG #18189: Value partitioned tables: Upd ERROR: more than one row returned by a subquery used as an expression
@ 2023-11-11 08:54 Hans Buschmann <buschmann@nidsa.net>
0 siblings, 1 reply; 2+ messages in thread
From: Hans Buschmann @ 2023-11-11 08:54 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; Hans Buschmann <buschmann@nidsa.net>
Hello Tom,
>Sadly, there are no attachments here; I don't think our bug-submission
>webform can handle them. When you need attachments, I'd suggest just
>mailing the pgsql-bugs list directly without bothering with the webform.
The situation seems much worse in this area:
I sent a "reply to all" mail after I received the Bug-reporting mail (WHY after a longer time of clearance??) yesterday at 15:50 CET.
It contained all 5 attachments just under 10 MB and I received the the copy sent to myself. So I thought all is OK.
Today I noticed, that this mail doesn't appear in buglist #18189 and totally disappeared for the community !!!
It seems there are mechanisms behind the scenes, that are not documented nor obvious for gentle users trying to ameliorate the software...
Now I resend the attachments in 2 mails
(I repackaged the big file to bz2 format)
Best regards
Hans Buschmann
Attachments:
[application/octet-stream] create_tables_ERR.sql (21.0K, ../../8c6d3b59e47943efbba984c532424163@nidsa.net/3-create_tables_ERR.sql)
download
[application/x-zip-compressed] GaiaSource_262134-265343_3E.zip (1.5M, ../../8c6d3b59e47943efbba984c532424163@nidsa.net/4-GaiaSource_262134-265343_3E.zip)
download
[application/octet-stream] source_to_arrays_ERR.sql (4.8K, ../../8c6d3b59e47943efbba984c532424163@nidsa.net/5-source_to_arrays_ERR.sql)
download
[application/octet-stream] steps_for_partition_err.sql (1022B, ../../8c6d3b59e47943efbba984c532424163@nidsa.net/6-steps_for_partition_err.sql)
download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: AW: BUG #18189: Value partitioned tables: Upd ERROR: more than one row returned by a subquery used as an expression
@ 2023-11-11 23:43 Tom Lane <tgl@sss.pgh.pa.us>
parent: Hans Buschmann <buschmann@nidsa.net>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2023-11-11 23:43 UTC (permalink / raw)
To: Hans Buschmann <buschmann@nidsa.net>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Hans Buschmann <buschmann@nidsa.net> writes:
> I sent a "reply to all" mail after I received the Bug-reporting mail (WHY after a longer time of clearance??) yesterday at 15:50 CET.
> It contained all 5 attachments just under 10 MB and I received the the copy sent to myself. So I thought all is OK.
> Today I noticed, that this mail doesn't appear in buglist #18189 and totally disappeared for the community !!!
> It seems there are mechanisms behind the scenes, that are not documented nor obvious for gentle users trying to ameliorate the software...
I think those messages are just hung up in moderation. If you're
not subscribed to pgsql-bugs, whatever you send will be held for
moderator approval (a sadly-necessary spam defense).
Anyway, the error is coming out of this bit:
,qoffs as (
select
...
,(((((ra -(select ra_base from qsum))*1000000000000)::bigint)>>15)&((1::bigint<<31)-1))::int as ira
...
"(select ra_base from qsum)" certainly is a "sub-select used as an
expression", and I guess the difference between your smaller and
larger datasets is how many rows the qsum CTE produces. If I'm
reading it right, that'll produce one row for each distinct value
of "(source_id >> 35+12)&((1<<16)-1)".
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-11-11 23:43 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-11 08:54 AW: BUG #18189: Value partitioned tables: Upd ERROR: more than one row returned by a subquery used as an expression Hans Buschmann <buschmann@nidsa.net>
2023-11-11 23:43 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox