[Qgis-user] [QGIS-pt] error in XML qgis layer style

[Pedro Costa]

I am using qgis but also tried with  a query.
I add what you said but do not work to.



Em 21-10-2014 09:12, Luigi Pirelli escreveu:
> are you saving using sql or qgis functionalities? it seems you have an
> already prepared XML and you want to insert in postgres styles table
> using sql. If it so, add
>
> SET XML OPTION DOCUMENT;
>
> before the update or insert statement
>
> regards, Luigi Pirelli
>
> On 21 October 2014 09:57, Pedro Costa <pedrocostaarma at sapo.pt> wrote:
>> Sorry I write it in portuguese by mistake.
>> I'm trying to save a qgis style in postgresql database but i receive this
>> error.
>> I think it's an error on XML document and tried to find in XML validator but
>> i get no errors.
>> Any tip about how to fix that or what is the problem?
>>
>> Thanks
>>
>>
>> Em 21-10-2014 08:38, Luigi Pirelli escreveu:
>>> are you trying to restore a pgdump?
>>> estas probando a reimportar un dump de postgres?
>>>
>>> a presto Luigi Pirelli
>>>
>>> 2014-10-20 18:26 GMT+02:00 Pedro Costa <pedrocostaarma at sapo.pt>:
>>>> Boa tarde pessoal,
>>>>
>>>> Estou a tentar gravar um ficheiro de estilo numa BD postgres mas recebo o
>>>> seguinte erro na query:
>>>>
>>>> ERRO:  invalid XML document
>>>> DETAIL:  Entity: line 1: parser error : Unfinished System or Public ID "
>>>> or
>>>> ' expected
>>>> <!DOCTYPE qgis PUBLIC "http://mrcc.com/qgis.dtd" "SYSTEM">
>>>>
>>>>
>>>> Pelos vistos é um erro no documento XML do INSERT da query:
>>>>
>>>> INSERT INTO (...)
>>>>
>>>> XMLPARSE(DOCUMENT
>>>>
>>>> '<!DOCTYPE qgis PUBLIC ''http://mrcc.com/qgis.dtd'' ''SYSTEM''>
>>>> <qgis version="2.4.0-Chugiak" minimumScale="-4.65661e-10"
>>>> maximumScale="1e+08" simplifyDrawingHints="0" minLabelScale="0"
>>>> maxLabelScale="1e+08" simplifyDrawingTol="1" simplifyMaxScale="1"
>>>> hasScaleBasedVisibilityFlag="0" simplifyLocal="1"
>>>> scaleBasedLabelVisibilityFlag="0">
>>>>    <renderer-v2 symbollevels="0" type="singleSymbol">...
>>>>
>>>> (...)
>>>>
>>>>
>>>>
>>>>
>>>> Alguém já se deparou com ele ou tem uma dica para o contornar? Já
>>>> coloquei
>>>> no XML Validator que não encontrou nada.
>>>>
>>>> OS Win7 64 bits
>>>> Qgis 2.4
>>>>
>>>> Abraços
>>>>
>>>> _______________________________________________
>>>> QGIS-pt mailing list
>>>> QGIS-pt at lists.osgeo.org
>>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/qgis-pt
>>>>
>>> _______________________________________________
>>> QGIS-pt mailing list
>>> QGIS-pt at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/qgis-pt
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user