mathieubossaert (0c356355) at 21 Jul 09:01
Update README.md
mathieubossaert (46b5962b) at 21 Jul 09:01
Update README.md
mathieubossaert (d1a4ab37) at 08 Jul 09:19
suppression du timeout qui interrompait le transfert
mathieubossaert (8b1ecdce) at 01 Jul 11:25
gestion du search path oiyur appel de fonctions dans le schema public
COPY FROM program requires to be invoked by a superuser. So we need to create Central2PG functions as a superuser and set security definers for functions using COPY FROM program in order to be usable by an non superuser role.
mathieubossaert (a09502d3) at 02 Jun 10:13
script à jour
Closed by commit ce1ccfaa
If new questions are added to the form, we need to reflect it on the database side before inserting new data. We need to compare refcursor attribute list to destination table attribute list :
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'xxx' AND table_schema = 'yyy'
ORDER BY ordinal_position
So maybe we could process ike this : 1 : Does the destination table already exists ?
Then create new attributes to the destination table (alter table add column).
And add the attribute list to be inserted in the insert statement of insert_into_from_refcursor.sql using (JSON_EACH(TO_JSON(_row))).key
mathieubossaert (44fea70c) at 28 May 18:01
rewrite the insert statetemant with EXECUTE format(...)
... and 2 more commits
mathieubossaert (b8c34e1c) at 19 May 11:08
closes #6 use search_path to avoid schema reference missing into fu...
mathieubossaert (e3bd1997) at 18 May 08:38
nettoyage des commentaires
mathieubossaert (608a1498) at 18 May 08:03
drop destination schema name where to create function in each funct...
In create_table_from_refcursor.sql add schema_name as a parameter :-) , instead of concatenate it in the table name :-(
mathieubossaert (2fb3e494) at 18 May 07:33
correction de détail et ajout d'un fichier complet central2pg.sql