[Qgis-user] Unable to save project to PostgreSQL

[Jorge Gustavo Rocha]

Hi Cliff,

Thank you for including the failing database insert/update. I think you
found a bug.

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.

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).

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 QString::fromLatin1. That's why it is important (if
possible), that you also include the original project.

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.

Best regards,

Jorge Gustavo

On 28/05/20 18:26, Cliff Patterson wrote:
> Hi QGISers!
>
> 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: 
>
> "Unable to save project to storage [db info removed]
>
> 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."
>
>
> 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.  
>
> Error Message in QGIS for PostGIS:
>
> 2020-05-28T12:50:37     WARNING    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...    
>           ^              ]
>
> 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? 
>
>
> -- 
>
> Cliff Patterson Ph.D.
>
> *PSD* | Senior GIS Consultant
> P: 519-690-2565 ext. 2616
> www.psdrcs.com <http://www.psdrcs.com>
> London | 148 Fullarton St. 9th Floor         
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-- 
Email Signature
Logo <https://www.geomaster.pt> 	
*Geomaster*
*Jorge Gustavo Rocha* | Software Engineer
*e:*jgr at geomaster.pt | *m:*+351 910 333 888
*g:*41.54094,-8.40490 | *v: *510 906 109
*a: * Rua António Cândido Pinto, 67, 4715-400 Braga

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200528/fd8cca5e/attachment-0001.html>