Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jTklJ-0001tl-If for pgsql-interfaces@arkaria.postgresql.org; Wed, 29 Apr 2020 11:20:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jTkkj-0006Vv-O4 for pgsql-interfaces@arkaria.postgresql.org; Wed, 29 Apr 2020 11:19:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jTkkj-0006Ii-GM for pgsql-interfaces@lists.postgresql.org; Wed, 29 Apr 2020 11:19:45 +0000 Received: from homecomputing.fr ([89.234.176.112]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jTkRF-0005R9-G3 for pgsql-interfaces@lists.postgresql.org; Wed, 29 Apr 2020 10:59:44 +0000 Authentication-Results: homecomputing.fr; dmarc=fail (p=quarantine dis=none) header.from=homecomputing.fr Subject: Re: How to insert default value with libpq? To: pgsql-interfaces@lists.postgresql.org References: <4aad674b-64c1-61d4-42f1-0adb292ee989@2ndquadrant.com> From: sanpi+postgersql@homecomputing.fr Autocrypt: addr=sanpi+postgersql@homecomputing.fr; keydata= mQINBFlj0gYBEADtTFu19kS6FwfhGKgJmDpnzE9C0lC+XF8hJhf7yos2sULzWbYANqku6NQY 31OR/NxhJrY9NkxzrRAKm4J9NEhPeZHjMRI0iRIc0ipmd8K+xtuQKXzahY1Wx9BxziR8vit0 ry7LGA1tnCDizzUSwWJPMuGKIl+jIgSFYMnI0NsKA9QJyWolFq9CMuZhglzwxuxqKSnTkRla /Mn+8cq/WWb6VGpVU+VF2/BbIfZtSu5ous+PRDWhjHOx+PVdr6TP2HuoRnlB381BIf3w0aqi +zq9h6esb1h+lJ1SuMgPjT7hr3Ag3g/g2OAUCYIJ3SUeVGZbmrUfZubryxmyLhBD1aPmiazn hZKTl8CDmzECuiBV/rwN8uqgGN+Iw6REaIAogDeNEC54nQ1K9Bmx1cGl6jvqvOil5qRtdwd8 KenJVeRCTx0O1ij3vr5bbzeFqLa1/1HcLxuKMN+SkzlR3DWXDZS+ILCTiALpajW6TyLG1E/c 5FI13GyfKefTkbuTCMxPh1hTAoIRFPfh2Ou+jcmyWbxjOgvlgMeLXT+DZQXCCKUoX8JCcfUR f9GadF3daGHV/ehh3Vr97ccFouWpkXIdfD7Sn40ZxypLmTAY5D1DhCh6wAaOyK3BUdzKq9HW WUcEzM3ehnUHixb98hE+BKAUayY0QonHtp4eGQsDWxVkY7nVOwARAQABtB5TYW5waSA8c2Fu cGlAaG9tZWNvbXB1dGluZy5mcj6JAkkEEwEKADMCGwMCGQEECwcJAwUVCAoCAwQWAAECFiEE 3PrcclxSiGpVTbIBFXxIy7RJLkkFAllj1VsACgkQFXxIy7RJLklJVQ//UvGlHRIic3CipPZA S/hwf6dDZmRubm6oJt+DKGET0YSzOJ5nbghTBX1spEQcCQdb5B5ftEVNFaB5YGa0/0WJe8Vf Gr66dQ4i5FhaAfPE0YstGzo/VLiuDnMYXaJy+XuNyeWgEKiyu3ipx8z2iNuIR0xhVFN/hAwE VLOPqe5uJvJcdHWEb1faA4Zotg6mVy4UlQwqDIyahqTOB/rlxYw7XlliRC6VrynJoiGhpeHq AVJB0two+Vl2BdtKJ1QyC7xg+uBy11ePhRxTu4b5JMoBgm1MC0bHoBlhSfGrgyD/ldGUr5+l M9D6oEB8jwZCmnDJC0RI0nSazpJaII4eX44h430SUlbGSuKSbDpMf+fBc6AWsznKh1KFmWR7 25qcbQKyEAIwYH6q1d7n5ygCPnkI08B1iEkj61VgdClz7xJ6W7Ehtm1XW9xRa/iVZg/VilYN AL/xJ7gEOjl2LvrIfQaBXExrQV7bqsRiMZ93XtUJX9jP0Ks0XyREHfaQLfRmvWhKtn4KU6Ku a0S7mulSp5y7NQwE9kFecHfTJP793rQJSe9uYib/IMihf/lrKggqOwrFJEOCW0I5cx6Lv3H1 WKH0irCIzXCfYaoH1xT20k5uZPvGzU/4FfV+gv7ktmNFaaq+iug0JXXgrRgNGgOnEA1fjtCg GK3kWIM1JNFTKAQ1os65Ag0EWWPSBgEQAM0FbFMOGYjGUPAcgAkRVLVFLAJgJdAfE7ECwPFM fK13fOqR7GETJwdsf8xFJxmD4/EUp+sBaOyiZA5/cFRvteWsqtArNmBAi+Nm7Ts4ICfjv/UY 4sfjVAg0H/sG4uoIyaTj9FI67VB/X/d4N3qQF964+eihsY4IfOFkphrhSJYYFx6Ro0Hwe1hx mEb8ENyeisviD91PT8EAbV4WT5kZH77rsv1z2WCx7GdxJmbodnjMBQBXBBcxYuMe2+siTF+n JC74Z2DjgOMsqd4cW4cELJwYefTILpCAXefKg9vTLvqpboc+j0nk7W7XoHmChsAUJyzYhTuA z/ZB2xsC0wMlvL3pDCcVbEtydV3K1ZAlKas3pjm6wGSAew2bJnmso0WwJLZnGJts70MLruZY PvJli/SyEPrV9bdJ4E6ILCzYAwJgxk7RgRltX2z+b/0o916+sOJ2mgpH0SrSAMtKBQ0P0Ws1 wRUKFSQ+VfAzfr/psyazy6gYp7feDBMuRfYbnMZpf59XHaQslWHCxamp18Oi5gD+pxLm8uHI tieVRxwsXs6hLMxEx1t+pFKjo9Rj9vrLOOhByYjJQb8mqRP77rbUJAPfgSSVwD0pfkY4FSnj wGJrSmCTf9I/gXMtpEmZta8SxFtkdzijL4rcLltVIsEEihHgxfQ2zrVEW7PH4XYWu1yNABEB AAGJAkYEGAEKADACGwwECwcJAwUVCAoCAwQWAAECFiEE3PrcclxSiGpVTbIBFXxIy7RJLkkF Allj/N4ACgkQFXxIy7RJLknohA/+LU+odKRwrg1d3PR2DHl6297TtuPAncpRqmQe23/0r2Lb PkKttngETuSwnsmyvu+y7BBj4zHPXggHKgx2uUlkjKXsu8UN6HQcp+mt6Bvnba7/FNLzEY1m /gx8mjJaBjJ8AyfWt4TCjLbwQig2FOmKXz8OGoR2SYsFt70Ufi+RxJt9B/Ai0sV+XQuRZ0Fe 44bNPqQIPSDcS3wcrCUYfGtbnIB1os/zCI3ml0K4JSHISAUBogcsxWTUpaWOguEzMigmcwG8 LERxiYxYiE/6NiI/a38y15k8Mh3JF/MV4T43MW4kF9bDGNq3kZHgp8uJu1K5YLVdnjdW9lR/ Lr/C3+tWnhbMr8ULufoE7mu5njbYeVRW0NL8Xp95PDh9U3hIt1JnwCUO1eUBOm7vUwKMDkCC M3TjKLg4ptLiaB9dqgyw5x3QXEjkTo4KDDckfUPIHEGuUm9qRCQdUuv3psQqtMyUVo6FY11U Zx9yXuLVOPnQW3a6Ga9L2pm/KpAs1kv5s8HGTepmhzdP4fPyvANUPZ+svVLHlj8HAVp316g/ Aupxgiwp79pcTbp20GMjsufTOuoOnU4YI/sLub70t0042zr63cj7LeXM39y+GYrMcoyQdYV1 aKDzb7LXmzfK6x5gSCo/jLP9n3M5eaNd93mQ3ep14q/Wcj8l8rkeddcNqvW3Cj65Ag0EWWP7 pQEQANv1B1ruo3GBbyjg9+9sY+bxQ12dSAM4Poyna/GVI1FloGh96ngA+UHqP8DF/pL8/bAu E87sBeikKo/137W6eyRWOXZodYnHdFqmjZL4K7b1kODTwZ+CjxA32LCvOxkov6Ai48haRjRN D4FU/xJs7wcafGdy2QCA6Mcb63F4Hn5KSkGdOSFmRAhaVyv2wH9NmOsfdnnh6CSw+lHFODgI jjENDbCJh6idn1H8yNQdYpZvpGJLqOpsDxoyPtqPpkzdrE1PqSecE6CT9e09p1twL+H1G9HM OSYXIujKzvQt+31qsg4DRzuNjVMcEWCrAHwU/6iEDdu3k2hgHTHTj719CK2eZbQH9CSej0p9 CoJjssFpMCt6m2zw9SQXCRDg2nFUnOYnFns1YkZg0qq5jR1Ye06nUIecDXybbDbyibHo7cJ4 +Ky9zJ7VvsSX0Ie4EDvG9trohmj0wPLOLmFtSS5aqnvSn8dN5u3fQxHhAjcmHlLJbQBaMNpp MU1tVPW/wdK6G++jMDnrzJIFc4qzcv0UKHfXfNrV+ppuEvviiJVKRmg5HEy/BXJa/CkfqJyn Uv8xrLbG3LVwkTepawvaZ6s9wAB+pbO6y/O542T6UcIEjQvUqKD6mw0mdh3G4j/rVigEbnNO lKI4zjd96dZiz8wV/2Y2CxboBeba8AG34BY8v8YHABEBAAGJBGwEGAEKACAWIQTc+txyXFKI alVNsgEVfEjLtEkuSQUCWWP7pQIbAgJACRAVfEjLtEkuScF0IAQZAQoAHRYhBEvwS0euhzuj 5oT7++RwtDoiGhqRBQJZY/ulAAoJEORwtDoiGhqRDwEP/ihH6vWxHgHHw7CJwSfCqPxEQHWn rhgMtiCWXJJC0LSao2Rp/+LyFq2CDBbgqgvMD/yZBr3sqXjmHCKt1+LKBUKQxhJ0jYzC0PeN yqDJcTT8x3gDkH9kR01AVapcVr7DN7IVy2r7lrm9ahNtCwTIxU5DjII2NCFoo/G51Gjs9mIY Yb+ZKWECRUzMF5ehO5n4LD3SBEe433wg02BBwRRxb2/Ya7NZkheszUPgNl29LpgbwuIpZm2O 8Q8i6N5UloGQgk/vBFKJ2WS+z4jdUDStRw+/hkfnA7le70aG/dv/d7eCO5k9jL8P4wOSMWrr QuuDkIbhNJdDCflOv7EC1XTaMhpz/zQrm4ucRTSn5rmMTXmNBtQ+dyqj63ZLHl1a6HQpI4ss OCMQF1dOkkNPvJG30iSClZ32cMQvXg1fE7paOdBjww0f9mnKTFz1c3vJqY3jvCO3SqI6PKgw Dop2biiOoPSC9NgTnQBPhTKU5d16fTnDqc9W1/+7z2+KzqVbU8H94CRnGGP92Ym4GedrxC9B e6PVebnJbNIeXOhDoSN/7jkrfsu0okbeeGxPvzYBFi+0NfDVoCX19/Uvnd+N5KH9O6DV0ali poisxAGK3+zldovr3jYRwMn8FLgXLyYLMd0eKVWoLl4HRfJWSaHz3ZBs9aFVUW2l4DX/B1Pw ix6rLpkb0u4P/0wlQvDdYxdxRGMJu9BT2XsXUGdTcCHNQR/eVem/3rgF4ZDx9kfb99VOA/IH DNpYRr6iX6KbZegBWHDKKIUrS+5IQgnUwuZYKA7Me9n1/jO9lXIpgoas2kHABlYjgX76WgxI JWZMYwax5o9MVyMRjxiF1NhO4xrdIE1/w5B+floYGR8KjEpG9wssRJxpf9xzgyp/TA3wXJ8K 3oH5VYAwfrm8LaRRNf0mzX3NNURoM7np185ie0yAZ39uWBLZC1aOxvFXJ+yDG+JhazUI0qG2 4GZGXm1tMTqDfV/4J65lZvBVssupRg0sJYD93hCPbwEJXA56kvqEZCK4k5wde9NN8ccRH/u1 EWgzaank2265IYACsaWMe5dsEBXk/H49KZ2HthwCpuhJev/m7+A6eI1bFkTKD33+RNxEfNx7 8j02kuKoCr50J8yCiAg+geOHLD+CTmqC68Wkab7gdBP5g3yPZelvGeDrnopitt5SMM24WVYI hh+jlWbvmmbZz89/pRgheAWiX4h6wSYxd4WUP/n4pP+SjN7I//y/elGG40pUjPDBgPUgW9Bw TzaAWmcWya80jZn5drXMa0C5LdhHjGqEfJOuuPtoJweZWzTBeSgtU4+hMb/WqocoEe3lXkre C1i8Je1b6fMS7WkuvxxJ6naKtpd098K9o0DUEPmvZXHbZcMe Message-ID: <8dca9799-d550-fcb2-b3cf-88b1f84d9854@homecomputing.fr> Date: Wed, 29 Apr 2020 12:59:31 +0200 MIME-Version: 1.0 In-Reply-To: <4aad674b-64c1-61d4-42f1-0adb292ee989@2ndquadrant.com> Content-Type: text/plain; charset=utf-8 Content-Language: fr Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Le 28/04/2020 à 16:25, Peter Eisentraut a écrit : > but this needs to be pasted into the query string, not passed as a > parameter. Fine, thank you for your help!