Re: [temporal-tables] postgres 12

Bonjour,

Cette extension n'est plus maintenue par son auteur depuis au moins 4 ans.
Cependant, sur le github, il y a eu des mises à jour pour la rendre
compatible avec les dernières versions de PG. Il faut faire une
installation en compilant le module.

David

Le lun. 24 janv. 2022 à 16:01, 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];
>
>

--
David Piscitelli
104 La Bellerie
44390 Nort Sur Erdre
Tel: 06-76-72-67-57