<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Cliff,</p>
<p>Thank you for including the failing database insert/update. I
think you found a bug.</p>
<p>When QGIS writes the project to the provider, it encodes the
project as a huge hexadecimal string. But your project's hex
string is not valid. I don't know why, but it should not be
invalid.</p>
<p>Please create a new bug report [1]. Include this insert statement
(with the invalid hexadecimal encoding) and the qgs project saved
in the file system (if the project does not contain private
information).</p>
<p>Matthias Kuhn improved this encoding eighth mouths ago, but you
might have some "strange" characters in the project that might not
be suitable to convert with <span class="blob-code-inner
blob-code-marker" data-code-marker="+"><span class="pl-c1">QString::<span
class="x x-first x-last">fromLatin1. That's why it is
important (if possible), that you also include the original
project.</span></span></span></p>
<p><span class="blob-code-inner blob-code-marker"
data-code-marker="+"><span class="pl-c1"><span class="x x-first
x-last">This is just a guess from the insert statement (I've
tried to run it), so I added Matthias in CC, so he can
correct me, if I'm wrong.<br>
</span></span></span></p>
<p><span class="blob-code-inner blob-code-marker"
data-code-marker="+"><span class="pl-c1"><span class="x x-first
x-last">Best regards,</span></span></span></p>
<p><span class="blob-code-inner blob-code-marker"
data-code-marker="+"><span class="pl-c1"><span class="x x-first
x-last">Jorge Gustavo<br>
</span></span></span></p>
<div class="moz-cite-prefix">On 28/05/20 18:26, Cliff Patterson
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CABHmMuPVQivaWa2pU6MRtqT=-qPS+XaQ9fbWOUQ+SzEbJ_NcEg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>Hi QGISers!</div>
<div><br>
</div>
<div>I am unable to save a project to PostgreSQL in QGIS version
3.10.4-A Coruña. "Allow saving/loading projects..." is enabled
for this DB. The user is the db owner and I can insert into
the table using PGAdmin with the same creds. However, when I
try to save a project to the DB in QGIS, I get the following
error: </div>
<div><br>
</div>
<div>
<p style="margin:0px;white-space:pre-wrap">"Unable to save project to storage [db info removed]</p>
<p style="margin:0px;white-space:pre-wrap">
</p>
<p style="margin:0px;white-space:pre-wrap">Unable to insert or update project (project=test) in the destination table on the database. Maybe this is due to table permissions (user=mapleton). Please contact your database admin."</p>
</div>
<div><br>
</div>
Note that the qgis_projects table is created successfully in the
DB before error. Also note that other tables in the DB are
editable in QGIS without error.
<div><br>
</div>
<div>Error Message in QGIS for PostGIS:</div>
<div><br>
</div>
<div>
<p style="margin:0px;white-space:pre-wrap"><span style="color:rgb(220,125,0)">2020-05-28T12:50:37 WARNING </span>Erroneous query: INSERT INTO "maps".qgis_projects VALUES ('test', ('{ "last_modified_time": "' || (now() at time zone 'utc')::text || '", "last_modified_user": "' || current_user || '" }')::jsonb, E'\\x504b03041400000008005266bc50266f065ab61e000031a700002a0000007b65663536623662642d313662662d346435332d383162612d3465633037643731633661617d2e716773ed3ded72db3892bfd74fc1d5566d3217d9fab6e48cac2a59961def5ab663d9c9cca5a654b408495c53a44252b6355bf74e77af70f762d78d0f1224418a9213d7782ab3b36311e86e341a407f1104da7f3dbeecddfc7ad5d7be4e4d4fbbba3d3a3feb696f66bebf785f2acdddf1786feccc4b58b967f8c61bedcdf0d7e14d7ff0a6b3d3a6180fc4f54cc73e2cd4f62ae5bdfa6e57eb39eef2fffe472f680bd7f91719fbb63e278785426747d3da33674eae747fa62de03f5058a2a5bee95ba4d32eb1bf58a22f7dc77775dbd3c73e50d7f0cf035029730cf2063c3fdabe169a158afee1f4041eff2e253ff7a787679f1a510ede0a07ff3e112c06f702870a4893620ee58f71db720d1811e3491abee751730fad75f0ae720517f6910cd996836f4ddd52dcd71cda969e7e7546aa0d52a57620d38f634b585dd5665ab36aad1368663dd22da04e68fe36aba9fecc8dec1c1c17e71d8eb8a9696b6e9af708ca2741b51ba27ba058224bae79bf6b4506c94f11ff55847e9ecabe8d838d328a15c349a387f7ac32f3dddf58967ea76b1fa5bb1fbcb19cce0b7fd9f0a4564ab78797d0c0d00aa7a020af80b80a7cd73846a2ac2edb07bdaff32ec5d5ef5514af7b6f3681780ce75bf1b5b2bdaaed6aaffef7f7fd67c476bb6f0876e1b1a5b7f772b6dec2c6ddf5d01eed1d1e52f5faab53d18ebdd56bd08ffee365b91e90db3bb02dd6d9770298b658dabbfde79877f0e97fe5c7b87b3fdb0d2d4de11cb5a7887b0245b65ed9def3c4ebd56fdb05c94fea7bdc301f60e01cb764606e88b7689d113d43d508646a75a3da8b74bec77588315c811d64815a0ea66f0882cbfe7f5bc484018c41bbbe602156147a588da251942ee28a1da531fbb8ebd9a77a0bb8cdf68b14080fe9b0bcf310d5141596a962b07ed52a24e204d893375f5c5cc1c4f2c7dda99e0946c9762a54ccd96127a36e086ebe2b6a5af88bb0bb386ec4e5d67b9e0986350e3ce1c6017c4f54de29578b9044e7f6aa6715898eb0b8bf88e3dba83a962e8ee6a7440ca07d55a7d32aa8f9bf89faa3ebaab4cca23a356dfdf6fc0f2abee570ada7846c6f704087cf4dfbfefb18782c68c57826641234f0b9898080fb89eb374c70067dc51f8376018df6833c7f30f05e61e410b3a06f5f068c26839d61287c043e3aa2d60fe1f36eae59ab6f4887bf846e0bcd13ccf9a3b0639344c4fbf035d744f56876f262698619c428774ba68fe6a410e076005cd2bc75a4dc15ad2ae5cb9e61c38fd2759ddda26367cf8a6f246f391cee1dfbf2e1dff67de1910287bde637f129d65c5da5b18d5f94f9af7d53aa4b6fd013ae202f9c3c2027a0a2ad62b04d3226dc44af1218b8cf0aee302498dd8c8a481163b2068fa64ded96e68db258acc19905b62735035e9da9ead2f16a055773de2a39af664ae343a28856a81c91e67002a06fac3772c02d612674305004cdb47b34917dcae201af6ac6dda8609825cea169347d05ed0f34871848be7ccf608e39e82f360c4323984451d17142d7689a5d309ce5c2ee012bca0071d5c34db767c56f5c9f44c9c8cd8365b66fe8c0cf4458f420a0151fe3a604a408ced127b6235e4c92776a8d89fe6a6dda9ef575bf5f21e98f76663bfd1dcaf94eb8d46a3da6a9768b5805d51d866bd52afb6f66a955ab55e3928975b00bf5faf83ea5ec9c04f73fda9b35f69d5c1d8349b955aad5aaed64094b572eba08184a13a240c0f75f02f9a078d3d20583b6856ca6558da07e5fa4105090b60d0a912ff6d974ba5536e9782df3b42fd836099ccdc705e28bdd61f7eeb0fbff587dffa27f45bbfb7e79ae5bb6678af79fcd76d3dd82d7cd82dbdd88dfc58a5278b852a3d0d86109c4417ec9f6f5a842af74881b0640bf09e308dd273c05f78f28763709c98e92c05b6534e5e0cc001b1b871b5c814686acb85810911577f84457589ee0d1854774984216560cc4fded0d705666c4e4c33220deca2f33b731e4f08ea18d2c3591ef1db26d04bea554588c0ec30f0898ab9200d83c424626a0f928f607a67f62528f307933c52ff87823dc3092a85031ab019f8a92123dc4ba405c29bf9043c1c3be3fbd0bf094a6ac791341325216603324a0700f35bd76402a33eebcb7ea5fe4495377d602eda0341355e90316ecc39e102b8835910100019b90ce2d2be707c73b292697be67c6141199f21378e45311eefef6e6843720411420f028e00160300d08de0f127e038d50fe0ef326f525474ad29d81d7f36671d346d418ebc2bb700cc5f59a4071317a108a0762d6b182dc35ee9c6a56dad288999ee511247ba470cea439a1658af1358a0917e9e3b00a512ca00969a3e152949852b299cc906b832adfa5eb37cb05fabd55be053821fd468c69cc9c09d6c55f7d10b6a804fd96a50e308ce51b319f526853fd9a8d7c1efdc0365db6a82230a94abd57a6b7f3fea4f061e65ab516fd65a7be0cf36aae808340e9a557404648f32ee536274616c1f3349f907ddd75984dbf9d601ee42f7bc4788c50edf1c91feefbfce3f56bf9e1e1cfc6775f1f0fd82df4218f716f654ea4e0a7441ab879d17f2004690e773d393a70c66a43189cdfe0623a20066211d0a32393a3c1ca59552524936c56abfff87e7ffc3f3ffe1f9ff293dffefeffb677bff99fe7fbe0860fb1860ab2860eb3860c348202516a0c552aa06bc0f6a4106c4d7d19e48e8602b6d704a4c7033d1e6060f520ca4bb582ac3258a24075ab7a74bf06e3a6848f8cfb016ad65875a34e2b74bf449aa8cbf8515c37be7f92ea814a80a7e4a0d9af6bd57920a268478004aff4861993d760c58f35013fc0c6bc76ed492a5dab81f56ee8795fb61e5fea456ee25ecdc3a4bb7c6d6e5b576cfb1775b5abc67d8bc8dad5eaadda36fd822e10a8b48a5544b9a316c8b578a9a301018a18b578bb4f3b43a806799917f39a61dda1f165a1d930566d9ec71f8e69187b1ea1a9e41630917836d29dae5899792942410593ab0b99621e1431427de8d61ea6277aedb60775d6dbc74d1500734e54c570c8727df04a024af14e2d2fe8127d33221743c47a01011474c1e8833ee2e600cdc81003ff21c825d93b9f32060c28710604874773c1310d253984c935be6195060ffa1ca25ecc1d85a64b89adf395681bfd1a4ef63ef588667e2c0f47041df618611333a14d2220fc4f2e4e422ae555a15731e6899a65b8b99ce5e6cd25627a665891ca76864e4ce581363581c23df19b1d98a58b1f5c1d276444ab5590e4ba1526cdd03ce86987922e7a64d0a34b111e5359ce50bed0184f075095e5c41bb3f2c8cf5051dda422915baf1739581d2b7d786eecd32806b4fef25b518c31bc17c1aa1a21c79684633c80c06715444cb40604d618278046b12d6ea68c1d384e9387738aa148f2ee43562a8361ac54ab509dd825f140bdc4f321a3b96bc521368545e01f4ba46ca7bd5fd10fad134fcd97a2985b0f9a4e44c26e0836f36880c67e301e468b9d87261698e60a5c0d25b0bbbf440f274728c369f904c546bbb823a1b4d3948d71885db49e270007949ed285feb037d5148c2c4a13e0e7decaf500af8df8246d37762676a1a3e4308f9c98656b68685416b63546fd4b0ab28b54b970a2781be72ca231e9e528c596faa2423716c5c95067b12e4e8ce337f2774b022163dd0f0921dbe23166e58112a1f556344738b7d3540cc7296fe8d1a0ee35250cadc484e1cdb3ff375cb1cd349083370b8849014020e9a6ce68addf63f13733a0335de806750d8b631a01b76786d4f5f98408481834dc7174a47f753d7e8a11e615a46fa3fbe79ea07b63fa0720e1d20ee70a18ff98e1e5a3a04f9c0ecbb8549cd5f74c4273f42fd93b836c5aa702c981af704a410a103d5f81a08ba7fe99a6096e8601c166610e78013093d286873cc7ca3eef9c07b5c09d16fe996a42b50ab3ea782bcfa2b6613e159eaaea454a9fcc01cc77b76a2cf4d7c0533186ac3197893dab135d5c02a5167e882ce69d034e6187cc2d19ccd7283bec9392c5c93e9d2d25d46e716270bb29c348f6ca8ef969309d85af667bd3c19dc5164945919be93a29d658f17ce09b800520197b1784c1bfd10f896ed9542bdca0a6589b2927f80b879af2bd5567c35b7eff4f13dbe67046fd39be90b8254d9cc473f074baef9a28b965e521d9e2d0809f0d710f3887a56bc6fc05251fc9ff64d02f98c1a99cd19ec60c0de2f49dea412dd30cd1c6c494de480c6714a1b8d80af3cad462645c8b0249e70a1049d66d32600f8740aeca045e00296863ca4f84bac851849362ab142d5084b74a499b45f97b84d8c2d95aad2d74cf184e7ba7b0ff63d78df8f4fc21bdfcc2dded0351ef086d39c638593a163a890625e0564e5a05cac346156372a815f98e21246f12864a84e47ba3d8627f05a516566e3e6f25b231863d31d5bcce1a79e463674d4e75b03bcbdafb8b1bf186db75164ff0aa98305cb72c8a30190639946042b8f14cb118c14e77cad7064f4ed6414a190435486a9d33dac149b363482e79963acc163611f7a5d9b7713b1b6ea1d45ccd129b6801ed0e91ce75b3eb9fdf9fc3efdb7f0eb37f7edbfa57f9fe5e36fe0e7a7f8fa6a7f9f9586ee483c073ad30de751637fa8c726ac0e3ce7744602c853cbb9e35b7158b1d802540e0185552def3545996c87035a5db407805a6b44cb8f4dcf975a50185c2845d3bcf4ba680e83ed44ac867b1b8c7de16740b9e441ec47a940637b8d6891bab94c39c5fd43236b78f3ac87e7ad844dd6c0b799fdea790f333e239ef5e498af148d6bc360311943826f33d77d6d61e963726cba8c25e6f8d0a96090b139a771610d378dd1f76a2a388b4cfc44f9df2dff67b64befb3ab2fce893d654e5918a2752d73ca5ce74780e8cd74179d4a17e3b604b50ef5c480db8be5fc0ef810e1ee407fc2fc22237fe2b85dde1e9dfaba61a8d85d584b885c59d351695149ccc1b3d3825fe1c64ae69ef25d55a77ce75f41738295c52321972c884ed71ffb7684c6d426eef98305062b640c545dc734ce684a30dcb798478b880d87a7c4262ebedd44893d314c11bd7bc47d9022930add45d95b42a18132a60ae3ccc64842414f74122c56d8c5af4bdd106dd41548f2ae4a6080ebe52bc7339105be33f6e6ba78735e3cba2e1e9d17af8be7c59b21fc1c5e8300615eb94b3b223026d4202058493d34004e92b690e6e799c3b7890643873b203d963340a46cc98adc0ed7a76595d42e311fb18b7233a876c54480e99fd97c4e042a343a03b2db8df57e23e050bf465b0cc5139dde2c2f854928e01f37de762db622e6c49dd23cbd2736a5f2fdcb2c23805601191a986cb95ae6dcc485784eb7db060911588b57e613b144aaa65c0e10f52736aca0a77470fa8381a568a62da1d5f86ab822ee95ee3221ff7e067c330a984c17cdf2d4ce3972235190da611f742d709d81f9b1257e295be166d908d6097d912e568ed4cf2af6282ad22cb5bcd63a3dc736e5b74cdfc22ea9ac52864d6af31c665ab2f31b8887f9d63c99c7f95f800a1839939169ebe3316627d9e0ae1309b62d5e371a57a124ffacce449cfa9de3042f02717ddd38a01770f1794123ecbb84cda6164f800434ca1be2a38b20b2309c04fa14911c0efb12b7c23fc8a564d86f44e6a5941afbcd70797998d96105655e1ecbf1449ae82007d1fc4e94059ee98953c4fc0e7b08df89f2ca455857961ae12125e79bbe1be508f7bc50bc25654fa52456e3e76a1c257875998a143539a9f8b1303a95dc60904e02d15311e34d2bdea2a6e2d25c540c3fc84aa562ed978bec5f087762c8610e27159b666f5468d98d96f76a2a249a46c92fd458ea25b750999bb5dd5c5026d4f2b32c25d572b32bbd8ccd8d137b29bb5d5f55793199525a3a02eb6415c765a12fa4859eace77a30a9bef0272f650a913dc89cc826869587ec28e0f2b48a308a5643bb23d3150687fece120bcfcbd09f3c17b3ce3e18cef20e13c63c4d6fda2ceadbdac0041464a73ba0969d98c84b1ae90624e30ef9ba2eb23572e23af32ef576b6ee699cd0b7ef70bc856fd46fea797f836e533adfb3d7b481359d563bd1dc558eec3c881f795112bb0752cf13897e238c852bfa7d5881ccef8801e1cf67d39812df2bd17da96a89c6301f7497ee85c357d95e0e3876e698bc532f8dc976b005013f000e1f829d7a2cf83c92a11265910d8e3c5d8a1bf022cf02684877d8f14f2857c7a63e75f5f935dfa601d1307d6651e90708a27193e7bca0e93e8cf6ddd227e7743f64f4755f9b531144b599d871d0c008d9a6b173da2b7a5dbca49460f957a783f0abd763623b73fc829a46a3ecfb50f1c168a40e8357f9cd7b90c5eeb2379d34812b9f941242f044efdf26f49f82b620b68ce429be2ce55f95a6f60e4808aa74c7b8945d11799c6a932665a800237b396e17bccd60632a34d775892ed20222b933a02f8b0e0bbfb08d1eb4d5e0c52f4ac99c2fe74142e091d5e0d078b2a8234b11930961f8a749bb91e39b3c8af8ed4371b7526c141bd12c3f7b3f1d4b1204f3481bc7e442fb84393cba69248ad82ec56658b8b032a77300c6cbe936d8a1d85d1464aec29ca49c3363afab61465ec5b3682df6617b97ef1809532c91044d524bc453036bc2feed43ecbce1f5f343eba422a7bbb1e35aaea41a00f9a0309a4565a4bc20ab7ae592b1196cac7271c331395e2e2c730cc37d019a2fbee5971de7480f2d887c7744bffbede1e6ece9d2d533849e9a0df938f54412f81413f4402f73b4a2561cedda233100d33ba25b81d2ed787a3e4222d28fe513943989ec9c51488c8e49ca54520d6f5298e130c746523aea01d6b412475472be26a6111d1062983e33d8bc2337e4c9ef43615cfc634a3dc56749b81f49e876296c4aee2ee52e855b673a19ad65f85ab7a7e48fc02dcdbd8cbce59dff8a442c981e555e8b98a59d8eaf47cc7388e65fd3ca9bebb3d1182cc02b13f1d85cc0c478454cc3e2239e87cecf2b94f45a9df18764bafa8a985e2ec0d31b81abe7be42a65fd5f4c0cf2d59caf575314dddc1d1720dd3c7e0d0e3d1557f04a60938e8348e18bd22a6bd95e713ccebfbaf8869e78e7eb2fc6a1c68bab15ec70ccc6b62d822f61f965ffea88e2675cbd4bd483e97966866b005865f1f215246183c96d2c02b09701ebda5625413185204958a554bc51a55d2b1ea49eec2302215ab91c0627e7c2ac27e124138d2a9384d6523dc934dc56a25b024573215eb20b5ad2ce155cae968d50cb4e49490fc9974b46a2a5a2693c98921d9f474b4ba0a4d58d574b4e4d490ec5a3a5a72824896251d2d394702dd9e8e949c22a1824dc73a5063a19693deb7c474479b3c8dada541ba22fdec7d1e0c4b19b527522d3f78c18b1c5a4b8b34227dfb59d0f4c5c25a5ddab7f4b455be2752a99836445728aa0d29a428ae2da9c4a6f9a6bd512bb60da92415dda604548a6f0b26148a70432a298a714b5e9e3738297a73432a296a744b2acfeb518a92dd9c8a4ae76e482545056f482545236fba0c550a7a534e94fa7a1b2231f51d57b9e88de2f1727884b0fc5e2728c5c646f03bfcb642c2604e99e3db4bcb92802a11fd8cb75d7c5d92487d699bb6caaab612ca3cd95cf9bb342769fe976e725479b126e5d3055ea84966805eac3561ad5eb27bdcb4bd5493921d7ce95ebee054952cec4b352999e3976ef205052b19fa176c5278052fd5a4e442bc549392bff162fa5c38272fd6c7c09379d116d1edc96c9066d6e29e8fc44378f850ba5f84de17eee0cac894ad455084a06b715282cedc78a3ca863caa03cbb578c950723d8a2a78ccd590225c5c8b971220e66e6f5341a604816bf152c2bedc789bf29912dae5c15305736bf152c2b7b5782901dbfa09ad0ad1d6b7a60ccaf2a1c5c2b04c3d9371e869b0cb935dd1acc89c75d9ddcd74d734bfd44fec40fb7799ffb3abf88ff8e7bf22c9be94e6423ee8ed1eec1d85e639aecf3fc4c66daaf0d48f06aa94087b71c10f59325c67718cc71f47046a2de776ec5b4f5a161c2a0a422948fbda82ab8dc25db8bb95d87ebb0805de9d10b1921331d2b40838376d3d42440e23bf0921740c9f45480ef99e45880772cfa3118467cf6645045dcf22248752df84a3670f971cf63c8b901ccc7c1342cfee9a1c783c9750104e3c8b901c243c8b90ecfa3f6fb5060efdf3f809ddf4e7d3a1cef73a326804238a5e32379255915d73839ef5a15bf40b88e8a1a98facac147f5f1f2ba696574da6edf90e9e2b12da63e93516a0e0d130e2ba5e762a1f7b118fe5094013266d49598aca8c5f6d550e09c46a5488785bde42f7679d2856509cd658a7fdd72fbde3ee4df7cbdfb4ddffd8d5d831efefb5a53fd96d61c94ea150d8f9787a36a4a7dfe0d9b0b636d31f88a66b572b7f06cec4646933afc29fe9be66b2e36389a13dce0896118a08e53b78dd2031f676766e3d02150019a23a78540eb848e0f668963335c758b482feb26601a98fd736537a3897f02e0b4a5b5030595b05ced419f42fa82cecd0d1dedbe9dad0848e9fbf0359dc8aefbda7fd9bb8ce5cfb8ab7a55dad3efa7b1ff9fe094f33e778519af6913defec801ba5cd5723e46984dd796b802974a645763e4f51e3df88fdf47ee72fa855b44351b22794ccdb9f76fe02b3cc771d0b6a19fadec4b48ddeccb48cb7bca5a25618acf0137dbaa5eca79ddf7eeb24a743e46b352a26d0ad383dc5d76a91327906382ef08b9ffc4dd9013ac460cfac8da05646891d39cfb6bb880a699b477738ec0f8783fec54da19407be770e18a3e1edd186f0b1a02515be7f72d2efdd9c7dea8ff2c1e3253523bc94233ffca07f73fdebe8361ffca0fb61d4bb3ceee784064e7a6757ddf3d166f079a513c057f3c31fe703bd3cfa070a3e2ff4c9093002fd1ce4843f3d19e5a53dfcd0bdeae3fd291b809ff72f7242ff3abce90f46a042f3c1df5e5df5af473767fdebcde0f38e684ad222153e25ebb316fe2e27fd94e03d153e9e224b054cc94264c1abb20fa9f0ca5c533ab43ae7b31ebeba19bc35ca0f9f5390ca74473ab43adb970e9fcc60a6c2aa5328d9e091d44926b43a1b940a9f921d5b0b2f67e1983d8d5cc5c20edab36f9c4582685825edb2ccb4a74a8c4c8b9a89a1ecaa1223d3aa2a3132ed6a1a46ba65556264d856357c9675cdc4c82fa94c0b9b8a719c1738c3caaae1b3ecac1a23cdd22aa1b36c6d3a82dadaaae1b3ecad1223d3e26662e41fe54cababc4c8b4bb991877b9dbc8b4bd4a0cb5f5558266dadf348c740bacc4c8b0c16af82c2b9c8d51dd14c31a6d82915bac19d6580d9f658fd518691659099d6593d311d456590d9f6597951899963913236a9b93a6b8fdc8cfa8916ec0a377d184af2a3ab044f0ac8578b174f1dc8db9e8d04be2f0c74e70655c700c78706b202da191393b4386de1dc131d8117f267de9b9cd75f1aca3fc309a8070e2488cf6e9d20c78676f84e8c92947d692e0018c3c8b87675c76aa8d46bba48051e1d3eb56d71108805414ae89b10e9f838467ec107e5806ada587c82849a4c0a5d05189a21c27929045b43a5d1c29702974d284a28412732f18e2363b45483a1e020fb23b5a0df4857cf085b86a52aa16a46402ed01d1bda51bbab67d719f65ecec0bf9cecb0046508c101124d1900664f1ec1d7a9e709cecbcda2e0595d29933d211c40914bcf0c1c3735124a0182b61e36d700de5a96998b889d6c3bc9c3c028d329d9552ad02899e132b6355f6652c5aad44a3074dca88b57214910284dd77f5c76b980b7814b46a50e5fa08d2ad4d8fe031d29044bd3433f19e49760a52626d845521fccc798441e85a163bcd58d5501c268e1cf63b033b048aa3e3aa005be92918f0dd6548210a1750c16f7c4fd889f5d1fe861501ac10175d90f169885727f16b0ddaa508a4988bc1cc6b5fe9fe2c64a17be739169ee394e45d54052442c4b638093d38da2724b8f41de01b13ee498aa22e9c28ec3c7e7a349317d1423049e4ba800975c3ed21bbaaf69a4c86d215ed57c16dbae2ac9dc88a01720900d1508260fc40a4f643707cd82e3da39e9bf9b68f377663aabce7d8782901a7e8b9e363e2f9dad801eb89c79c914b7029d83dc80b738187e111ed1df82e0bed9d693f686b6f4866a00c8a66f06dbca6457bf7b41a99f6a1ab1bf427de3867906941a347059dc07ff1a434f9c025e44cbeb52fed62f61fd7b2ffb896fdc7b5ec7fca6bd9bfffa5ecd957b2675ec89eef3af6ed2f63dfea2af6ad2f62dff01af6944bd8514a63e9cb56cfcfadc103f5fcf97408132bd0cf9f1d17c2dd53e21804adf79086d1a88beb11052db012eab9d6d8af7d1ff50c6b3394a815aecea9e0d512baf52d68d9d80a84259bb79d38d540a1be05dd1a5504d5fc5433173a15ba58babb07e5e26ea5552ee26587ad72d430d5aafbeb162e320ca2d0de19685b0f61a45af51c6bb2566f5453d724b6bb66493290352b924d9b4dd620efcdb6eb10a39a4dd621f350375e86e1d2a34bf2983fb64b2a2f50f41202191d4f12e788a60111a2393189db6997a40756bbd05d2c9161124522c5634f97fa9474304bc37fb21a747aa194fee125a66fd122fa9795e977b84b78ec4371f0935336ede0244e3af61058f42c733261e31e841963889ee9d056cbd5f26eb9b15b6ddd54aaefeb07ef1bad7629a8957356b22cda5ddbe6c7ea725ffa9c6e1ce10f478e738f5799f247eebb7f32c9637016ecad4778317555a48345dbac8067b114b89d9d7609b7ec7476fe1f504b03041400000000003d66bc500000000000000000000000002a0000007b65663536623662642d313662662d346435332d383162612d3465633037643731633661617d2e716764504b010214031400000008005266bc50266f065ab61e000031a700002a0000000000000000000000b681000000007b65663536623662642d313662662d346435332d383162612d3465633037643731633661617d2e716773504b010214031400000000003d66bc500000000000000000000000002a0000000000000000000000b681fe1e00007b65663536623662642d313662662d346435332d383162612d3465633037643731633661617d2e716764504b05060000000002000200b0000000461f00000000') ON CONFLICT (name) DO UPDATE SET content = EXCLUDED.content, metadata = EXCLUDED.metadata; returned 7 [ERROR: syntax error at or near "ON"
LINE 1: ...764504b05060000000002000200b0000000461f00000000') ON CONFLIC...
^
]</p>
<p style="margin:0px;white-space:pre-wrap">
</p>
<p style="margin:0px;white-space:pre-wrap">I tested saving to DB using another DB and it works fine -- so not likely anything to do with my setup. Any ideas what else needs to be enabled to allow projects to save?
</p>
<div>
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<p style="margin-bottom:0.0001pt">Cliff Patterson
Ph.D.<br>
<br>
<b>PSD</b> | Senior GIS Consultant <br>
P: 519-690-2565 ext. 2616<br>
<a href="http://www.psdrcs.com" target="_blank"
moz-do-not-send="true">www.psdrcs.com</a><br>
London | 148 Fullarton St. 9th Floor <span
style="font-size:small"> </span><br>
</p>
<p style="font-size:12.8px;margin-bottom:0.0001pt"><span
style="font-size:12.8px"><span
style="font-size:9pt;line-height:12.84px;font-family:Verdana,sans-serif;color:rgb(0,112,192)"><img
src="http://psdrcs.com/assets/email_signature.png"
moz-do-not-send="true" width="200"
height="57"></span></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<div class="moz-signature">-- <br>
<title>Email Signature</title>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<table style="width: 525px; font-size: 11pt; font-family: Arial,
sans-serif;" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="text-align:center; font-size: 10pt; font-family:
Arial, sans-serif; border-right: 1px solid;
border-right-color: #fb6303; width: 125px; padding-right:
10px; vertical-align: top;" rowspan="6" width="125"
valign="top"> <a href="https://www.geomaster.pt"
target="_blank"><img alt="Logo" style="width:105px;
height:auto; border:0;"
src="https://geomaster.pt/wp-content/uploads/2017/02/cropped-geomaster300x300-1.png"
width="85" border="0"></a> </td>
<td style="padding-left:10px">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="font-size: 10pt; color:#0079ac;
font-family: Arial, sans-serif; width: 400px;
padding-bottom: 5px; padding-left: 10px;
vertical-align: top;" valign="top"> <strong><span
style="font-size: 14pt; font-family: Arial,
sans-serif; color:#fb6303;">Geomaster</span></strong><br>
<strong><span style="font-size: 11pt; font-family:
Arial, sans-serif; color:black;">Jorge Gustavo
Rocha</span></strong> <span
style="font-family: Arial, sans-serif;
font-size:11pt; color:#000000;"><span
style="padding-right: 5px; padding-left: 5px;">
| </span>Software Engineer</span> </td>
</tr>
<tr>
<td style="font-size: 10pt; color:#444444;
font-family: Arial, sans-serif; padding-bottom:
5px; padding-top: 5px; padding-left: 10px;
vertical-align: top; line-height:17px;"
valign="top"> <span><span style="color: #fb6303;"><strong>e:</strong></span><span
style="font-size: 10pt; font-family: Arial,
sans-serif; color:#000000;"> <a class="moz-txt-link-abbreviated" href="mailto:jgr@geomaster.pt">jgr@geomaster.pt</a></span></span>
<span><span style="padding-left:
5px;padding-right: 5px;"> | </span><span
style="color: #fb6303;"><strong>m:</strong></span><span
style="font-size: 10pt; font-family: Arial,
sans-serif; color:#000000;"> +351 910 333 888<br>
</span></span> <span><span style="color:
#fb6303;"><strong>g:</strong></span><span
style="font-size: 10pt; font-family: Arial,
sans-serif; color:#000000;"> 41.54094,-8.40490</span></span>
<span><span style="padding-left:
7px;padding-right: 5px;"> | </span><span
style="color: #fb6303;"><strong>v: </strong></span><span
style="font-size: 10pt; font-family: Arial,
sans-serif; color:#000000; padding-left: 7px;">
510 906 109<br>
</span></span> <span> <span style="color:
#fb6303;"><strong>a: </strong></span> </span>
<span> <span style="font-size: 10pt; font-family:
Arial, sans-serif; color: #000000;"><span> </span>Rua
António Cândido Pinto, 67, 4715-400 Braga<br>
</span></span> </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>