Re : [temporal-tables] postgres 12

Bonjour Pierre,

en solution palliative, je suggère de regarder du coté de periods:
https://github.com/xocolatl/periods

Salutations,

---

Cédric Villemain +33 (0)6 20 30 22 52
https://data-bene.io
PostgreSQL: Expertise - Conseil - Formation - Développement - Assistance Technique

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
Le lundi 24 janvier 2022 à 15:52, CRUMEYROLLE Pierre <pierre(dot)crumeyrolle(at)csgroup(dot)eu> a écrit :

> Bonjour,
> J'essaye d'installer l'extension temporal tables ( https://github.com/arkhipov/temporal_tables
>
> https://github.com/arkhipov/temporal_tables [arkhipov/temporal_tables: Temporal Tables PostgreSQL Extension - GitHub](https://github.com/arkhipov/temporal_tables)
> Temporal Tables Extension. Introduction. A temporal table is a table that records the period of time when a row is valid. There are two types of periods: the application period (also known as valid-time or business-time) and the system period (also known as transaction-time).
> github.com
> ) avec une instance postgres 12 sous ubunutu 20 ,
> L'installation échoue, il semblerait que cette extension ne soit pas compatible avec postgres 12 ?
> quelqu' un a-t-il tester cette extension ?
> merci
> cordialement
>
> # pgxn install temporal_tables
> INFO: best version: temporal_tables 1.2.0
> INFO: saving /tmp/tmp4ditsaj8/temporal_tables-1.2.0.zip
> INFO: unpacking: /tmp/tmp4ditsaj8/temporal_tables-1.2.0.zip
> INFO: building extension
> gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -I. -I./ -I/usr/include/postgresql/12/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/mit-krb5 -c -o temporal_tables.o temporal_tables.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -I. -I./ -I/usr/include/postgresql/12/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/mit-krb5 -c -o versioning.o versioning.c
> versioning.c: In function ‘versioning’:
> versioning.c:249:16: error: incompatible types when assigning to type ‘Form_pg_attribute’ {aka ‘struct FormData_pg_attribute *’} from type ‘FormData_pg_attribute’ {aka ‘struct FormData_pg_attribute’}
> 249 | period_attr = tupdesc->attrs[period_attnum - 1];
> | ^~~~~~~
> versioning.c: In function ‘fill_versioning_hash_entry’:
> versioning.c:502:10: error: incompatible types when assigning to type ‘Form_pg_attribute’ {aka ‘struct FormData_pg_attribute *’} from type ‘FormData_pg_attribute’ {aka ‘struct FormData_pg_attribute’}
> 502 | attr = tupdesc->attrs[i];
> | ^~~~~~~
> versioning.c:514:18: error: incompatible types when assigning to type ‘Form_pg_attribute’ {aka ‘struct FormData_pg_attribute *’} from type ‘FormData_pg_attribute’ {aka ‘struct FormData_pg_attribute’} 514 | history_attr = history_tupdesc->attrs[history_attnum - 1];