| From: | "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Corruption or wrong results with 14.10? |
| Date: | 2023-11-23 13:29:34 |
| Message-ID: | GV0P278MB04190AD18660D3E3739ACD02D2B9A@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>smrdbprod=# select count(*) from smrr_mgr.formula where crart_id = 21507180000 and chemin = '@';
> count
>-------
> 1
>(1 row)
>
>smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group by crart_id, chemin having count(*) > 1;
> crart_id | chemin | count
>----------+--------+-------
>(0 rows)
Small update:
smrdbprod=# set enable_indexscan to off;
SET
smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group by crart_id, chemin having count(*) > 1;
crart_id | chemin | count
-------------+--------+-------
35054630000 | @ | 2
4737310000 | @ | 2
10632380000 | @ | 2
14680880000 | @ | 2
4627230000 | @ | 2
10993780000 | @ | 2
....
I think I know what I have to do.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anthony Apollis | 2023-11-23 14:02:22 | Check Code Correction Current Period Prior Period Movement |
| Previous Message | Daniel Westermann (DWE) | 2023-11-23 13:16:57 | Corruption or wrong results with 14.10? |