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 1jT3Pa-0007oQ-2z for pgsql-interfaces@arkaria.postgresql.org; Mon, 27 Apr 2020 13:03:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jT3PX-00074O-7n for pgsql-interfaces@arkaria.postgresql.org; Mon, 27 Apr 2020 13:02:59 +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 1jT3PX-00071P-0j for pgsql-interfaces@lists.postgresql.org; Mon, 27 Apr 2020 13:02:59 +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 1jT3PO-000116-Nr for pgsql-interfaces@lists.postgresql.org; Mon, 27 Apr 2020 13:02:57 +0000 Authentication-Results: homecomputing.fr; dmarc=fail (p=quarantine dis=none) header.from=homecomputing.fr 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 To: pgsql-interfaces@lists.postgresql.org Subject: How to insert default value with libpq? Message-ID: Date: Mon, 27 Apr 2020 15:02:38 +0200 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------921DE6B88287A2CAA356C9D8" Content-Language: fr List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------921DE6B88287A2CAA356C9D8 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Hello, I would like to insert the default value for a field with libpq, but inserting null or "default" doesn’t work. I attached a simple example also available here https://gitlab.com/snippets/1970590 Is it possible? --------------921DE6B88287A2CAA356C9D8 Content-Type: text/x-csrc; charset=UTF-8; name="main.c" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="main.c" #include #include #include "libpq-fe.h" static void exec(PGconn* conn, const char* param) { const char* values[1] =3D {param}; PGresult* res =3D PQexecParams( conn, "INSERT INTO test (id) VALUES ($1);", sizeof(values) / sizeof(*values), NULL, // types values, NULL, // lengths NULL, // formats 1 ); printf("%s", PQresultErrorMessage(res)); PQclear(res); } int main(int argc, char** argv) { const char* conninfo; if (argc > 1) { conninfo =3D argv[1]; } else { conninfo =3D "host=3Dlocalhost"; } PGconn* conn =3D PQconnectdb(conninfo); if (PQstatus(conn) !=3D CONNECTION_OK) { fprintf(stderr, "Connection to database failed: %s", PQerrorMessa= ge(conn)); exit(1); } PQexec(conn, "CREATE TEMPORARY TABLE test (id SERIAL PRIMARY KEY);");= exec(conn, NULL); exec(conn, "default"); PQfinish(conn); return 0; } --------------921DE6B88287A2CAA356C9D8--