View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007159 | Taler | exchange | public | 2022-01-24 23:38 | 2022-11-04 19:53 |
| Reporter | Florian Dold | Assigned To | Christian Grothoff | Resolution deadline | |
| Implementer | Reviewer | ||||
| Release signed by | Deployed by | ||||
| Verifier | Communicator | ||||
| Data protection authority notification required | No | ||||
| CSIRT notification required | No | ||||
| Estimated effort (hours) | Actual effort (hours) | 0 | |||
| Fast-track | No | ||||
| Work package | none | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Product Version | git (master) | ||||
| Target Version | 0.9 | Fixed in Version | 0.9 | ||
| Summary | 0007159: exchange requires postgres>=13, does not work on focal-fossa anymore | ||||
| Description | Due to foreign key constraints on partitioned tables, we don't support postgres=12 anymore. This is a problem on Ubuntu focal-fossa only supports postgresql-12 (https://packages.ubuntu.com/focal/postgresql). | ||||
| Tags | No tags attached. | ||||
| In particular, the following error message appears on postgres=12 but not on 13: psql:/home/demo-green/local/share/taler/sql/exchange/exchange-0001.sql:142: ERROR: cannot reference partitioned table "reserves" 2022-01-24T23:56:37.088736+0100 taler-exchange-dbinit-2163761 WARNING Could not run PSQL on file /home/demo-green/local/share/taler//sql/exchange/exchange-0001.sql: psql exit code was 3 | |
| Yeah, that's an easy back-port, if we simply disable partitioning. Will do near the release if deemed necessary... | |
| bc3ec563..3f23bede now documents the requirement for Postgres 13. I no longer see a strong reason to support Focal Fossa... | |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-01-24 23:38 | Florian Dold | New Issue | |
| 2022-01-24 23:38 | Florian Dold | Status | new => assigned |
| 2022-01-24 23:38 | Florian Dold | Assigned To | => Christian Grothoff |
| 2022-01-24 23:39 | Florian Dold | Note Added: 0018664 | |
| 2022-01-25 21:59 | Christian Grothoff | Note Added: 0018669 | |
| 2022-02-19 20:35 | Christian Grothoff | Status | assigned => informing |
| 2022-02-19 20:35 | Christian Grothoff | Resolution | open => fixed |
| 2022-02-19 20:35 | Christian Grothoff | Fixed in Version | => 0.9 |
| 2022-02-19 20:35 | Christian Grothoff | Note Added: 0018703 | |
| 2022-02-19 20:35 | Christian Grothoff | Product Version | => git (master) |
| 2022-02-19 20:35 | Christian Grothoff | Target Version | => 0.9 |
| 2022-11-04 19:53 | Christian Grothoff | Status | informing => closed |