View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004583 | Taler | exchange | public | 2016-06-19 21:54 | 2024-01-12 13:05 |
| Reporter | Christian Grothoff | 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 | none | Severity | tweak | Reproducibility | N/A |
| Status | closed | Resolution | not fixable | ||
| Platform | i7 | OS | Debian GNU/Linux | OS Version | squeeze |
| Product Version | 0.0 | ||||
| Target Version | 0.4 | Fixed in Version | 0.4 | ||
| Summary | 0004583: should use CREATE TYPE to define amount type in postgres backends | ||||
| Description | https://www.postgresql.org/docs/current/static/sql-createtype.html | ||||
| Tags | No tags attached. | ||||
| Should probably also do this for common types: http://www.sqlines.com/postgresql/how-to/create_user_defined_type | |
| Close investigation shows that custom types cannot declare constraints (like not-null, length limits) so they are useless for keys/hashes. Also, for the amount, we then cannot use libpq to easily extract the values without some atrocious "(amount).val AS amount_val" SQL which defeats the point of using the custom types in the first place for amounts. TLTR: custom types cannot be used in a useful way for us. | |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-06-19 21:54 | Christian Grothoff | New Issue | |
| 2016-06-19 21:54 | Christian Grothoff | Status | new => assigned |
| 2016-06-19 21:54 | Christian Grothoff | Assigned To | => Sree Harsha Totakura |
| 2016-06-19 21:54 | Christian Grothoff | Assigned To | Sree Harsha Totakura => |
| 2016-06-19 21:54 | Christian Grothoff | Status | assigned => implementing |
| 2017-03-18 22:35 | Christian Grothoff | Target Version | => 0.7.1 |
| 2017-04-01 23:05 | Christian Grothoff | Note Added: 0012015 | |
| 2017-04-08 22:08 | Christian Grothoff | Severity | feature => tweak |
| 2017-04-08 22:08 | Christian Grothoff | Assigned To | => Christian Grothoff |
| 2017-04-08 22:08 | Christian Grothoff | Status | implementing => assigned |
| 2017-04-08 22:17 | Christian Grothoff | Target Version | 0.7.1 => 0.6 |
| 2017-07-14 17:31 | Christian Grothoff | Status | assigned => informing |
| 2017-07-14 17:31 | Christian Grothoff | Resolution | open => not fixable |
| 2017-07-14 17:31 | Christian Grothoff | Fixed in Version | => 0.4 |
| 2017-07-14 17:31 | Christian Grothoff | Note Added: 0012335 | |
| 2017-07-14 17:31 | Christian Grothoff | Target Version | 0.6 => 0.4 |
| 2017-10-18 13:42 | Christian Grothoff | Status | informing => closed |
| 2024-01-12 13:05 | Christian Grothoff | Category | exchange Postgres DB backend => exchange |