View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004583 | Taler | exchange | public | 2016-06-19 23:54 | 2024-01-12 14:05 |
| Reporter | Christian Grothoff | Assigned To | Christian Grothoff | ||
| 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 23:54 | Christian Grothoff | New Issue | |
| 2016-06-19 23:54 | Christian Grothoff | Status | new => assigned |
| 2016-06-19 23:54 | Christian Grothoff | Assigned To | => Sree Harsha Totakura |
| 2016-06-19 23:54 | Christian Grothoff | Assigned To | Sree Harsha Totakura => |
| 2016-06-19 23:54 | Christian Grothoff | Status | assigned => confirmed |
| 2017-03-18 23:35 | Christian Grothoff | Target Version | => 0.7.1 |
| 2017-04-02 01:05 | Christian Grothoff | Note Added: 0012015 | |
| 2017-04-09 00:08 | Christian Grothoff | Severity | feature => tweak |
| 2017-04-09 00:08 | Christian Grothoff | Assigned To | => Christian Grothoff |
| 2017-04-09 00:08 | Christian Grothoff | Status | confirmed => assigned |
| 2017-04-09 00:17 | Christian Grothoff | Target Version | 0.7.1 => 0.6 |
| 2017-07-14 19:31 | Christian Grothoff | Status | assigned => resolved |
| 2017-07-14 19:31 | Christian Grothoff | Resolution | open => not fixable |
| 2017-07-14 19:31 | Christian Grothoff | Fixed in Version | => 0.4 |
| 2017-07-14 19:31 | Christian Grothoff | Note Added: 0012335 | |
| 2017-07-14 19:31 | Christian Grothoff | Target Version | 0.6 => 0.4 |
| 2017-10-18 15:42 | Christian Grothoff | Status | resolved => closed |
| 2024-01-12 14:05 | Christian Grothoff | Category | exchange Postgres DB backend => exchange |
