Pessoal, quando coloco a string em [1] no pgAdmin (Query tool) versão 1.14.x, ela some.
Observações: - Testei usando a versão para windows; - Versão do PostgreSQL = 9.04; - Isso também ocorre na ferramenta de visualização de dados em forma de tabela e no psql; - S.O Utilizado para o teste: Windows 7 X64; - Tipo de campo para armazenamento de [1]: xml. [1] '<procEventoNFe versao="1.00" xmlns="http://www.portalfiscal.inf.br/nfe";><evento xmlns="http://www.portalfiscal.inf.br/nfe"; versao="1.00"><infEvento Id="ID1101102812060770329000018955001000000227100002638706"><cOrgao>28</cOrgao><tpAmb>2</tpAmb><CNPJ>07703290000189</CNPJ><chNFe>28120607703290000189550010000002271000026387</chNFe><dhEvento>2012-07-16T15:23:04-03:00</dhEvento><tpEvento>110110</tpEvento><nSeqEvento>6</nSeqEvento><verEvento>1.00</verEvento><detEvento versao="1.00"><descEvento>Carta de Correcao</descEvento><xCorrecao>Teste de correcao de NF de Entrada 06</xCorrecao><xCondUso>A Carta de Correcao e disciplinada pelo paragrafo 1o-A do art. 7o do Convenio S/N, de 15 de dezembro de 1970 e pode ser utilizada para regularizacao de erro ocorrido na emissao de documento fiscal, desde que o erro nao esteja relacionado com: I - as variaveis que determinam o valor do imposto tais como: base de calculo, aliquota, diferenca de preco, quantidade, valor da operacao ou da prestacao; II - a correcao de dados cadastrais que implique mudanca do remetente ou do destinatario; III - a data de emissao ou de saida.</xCondUso></detEvento></infEvento><Signature xmlns=" http://www.w3.org/2000/09/xmldsig#";><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><Reference URI="#ID1101102812060770329000018955001000000227100002638706"><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><DigestValue>Tg52Qk3mlHCxuSRUlz0vTab3Eho=</DigestValue></Reference></SignedInfo><SignatureValue>UmM5guiuDebIzGUN6WpSDf9hO0iCnmVuuwd43VcRDUw42Nh3mZ3k/gN9T0ytlR7lQ03tKylkMQBIIf35ikedQX1wK2vUmTFYJaKCHSTVSCltli8F1jA5QGoBN6nV1VUWYNHWbW+Oxbu4P+Cm51AzR4kdoLxfwSLk41oZFMkydZQ=</SignatureValue><KeyInfo><X509Data><X509Certificate>MIIGWjCCBUKgAwIBAgIIWRNrZWT0oY8wDQYJKoZIhvcNAQEFBQAwdTELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEgZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEZMBcGA1UEAxMQQUMgU0VSQVNBIFJGQiB2MTAeFw0xMTExMTcxMTI5NDNaFw0xMjExMTYxMTI5NDNaMIHXMQswCQYDVQQGEwJCUjELMAkGA1UECBMCU0UxEjAQBgNVBAcTCUlUQUJBSUFOQTETMBEGA1UEChMKSUNQLUJyYXNpbDE2MDQGA1UECxMtU2VjcmV0YXJpYSBkYSBSZWNlaXRhIEZlZGVyYWwgZG8gQnJhc2lsIC0gUkZCMRYwFAYDVQQLEw1SRkIgZS1DTlBKIEExMRIwEAYDVQQLEwlBUiBTRVJBU0ExLjAsBgNVBAMTJUlOREVYIElORk9STUFUSUNBIExUREE6MDc3MDMyOTAwMDAxODkwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAK/IWuRA2uTrVZyGMCgv4e8NY08BNvtptVSab0/rpk4+koKuQsAIwYoW+wG8zVqSiv+ziM360swWC30As3SX4G5/RP7aiP/unYKDXyQ+29QBDt4cDRI2ixKKgiS2jPH8vHFlYQton8iB6F0uJWvY/1B136h7eMg3XsASuA9oLmvvAgMBAAGjggMNMIIDCTAJBgNVHRMEAjAAMA4GA1UdDwEB/wQEAwIF4DAdBgNVHSUEFjAUBggrBgEFBQcDAgYIKwYBBQUHAwQwHwYDVR0jBBgwFoAUmt0itvZ36UJvSMJRQKBW4vN0P7swgcAGA1UdEQSBuDCBtYEWSU5ERVguRklPTFVYQEdNQUlMLkNPTaAnBgVgTAEDAqAeExxKT1NJTUEgRkVSTkFOREVTIERFIE1FREVJUk9ToBkGBWBMAQMDoBATDjA3NzAzMjkwMDAwMTg5oD4GBWBMAQMEoDUTMzI5MDcxOTY2NDE2MDA3MDM0NTMxNzAwMDg5MjM3MjAwMDAwMDAxMDA3OTE3MlNTRFNQQqAXBgVgTAEDB6AOEwwwMDAwMDAwMDAwMDAwVwYDVR0gBFAwTjBMBgZgTAECAQ0wQjBABggrBgEFBQcCARY0aHR0cDovL3d3dy5jZXJ0aWZpY2Fkb2RpZ2l0YWwuY29tLmJyL3JlcG9zaXRvcmlvL2RwYzCB8wYDVR0fBIHrMIHoMEqgSKBGhkRodHRwOi8vd3d3LmNlcnRpZmljYWRvZGlnaXRhbC5jb20uYnIvcmVwb3NpdG9yaW8vbGNyL3NlcmFzYXJmYnYxLmNybDBEoEKgQIY+aHR0cDovL2xjci5jZXJ0aWZpY2Fkb3MuY29tLmJyL3JlcG9zaXRvcmlvL2xjci9zZXJhc2FyZmJ2MS5jcmwwVKBSoFCGTmh0dHA6Ly9yZXBvc2l0b3Jpby5pY3BicmFzaWwuZ292LmJyL2xjci9TZXJhc2EvcmVwb3NpdG9yaW8vbGNyL3NlcmFzYXJmYnYxLmNybDCBmQYIKwYBBQUHAQEEgYwwgYkwSAYIKwYBBQUHMAKGPGh0dHA6Ly93d3cuY2VydGlmaWNhZG9kaWdpdGFsLmNvbS5ici9jYWRlaWFzL3NlcmFzYXJmYnYxLnA3YjA9BggrBgEFBQcwAYYxaHR0cDovL29jc3AuY2VydGlmaWNhZG9kaWdpdGFsLmNvbS5ici9zZXJhc2FyZmJ2MTANBgkqhkiG9w0BAQUFAAOCAQEAZ4uZHKq4/5pJ1VlikrvCIbHOQLh02kjm02Nt5qUR/DYhHli+TM9CR9YosSBGdPLMSa/HIyZfVEWFVso2h3zMO1V/rG3Y64CNX4k+4Hz72kQ/JqqTkpozRNErvtN/LrgrYAXWKUJNuNSvHDUyDpahrRNTSFJ5RI6NSBlLjLK2vvbPAde9KWHCd5ObaDd2KATy0cA4cb478nVlh2EKGz/wt02ULLDGjmc4OKKG61cBuw9/xEsV/a9U+sgW310copsnX1va4zm2NYpSWdKPnB6CBlmv7HD0LLnlEVqPbelU0g/9pQqQKEz3KGk5BWVnv8mUlRoA6YoqE3EHSdnHsXh1lQ==</X509Certificate></X509Data></KeyInfo></Signature></evento><retEvento versao="1.00"><infEvento Id="ID328120000022720" xmlns=" http://www.portalfiscal.inf.br/nfe";><tpAmb>2</tpAmb><verAplic>SVRS20110530105153</verAplic><cOrgao>28</cOrgao><cStat>135</cStat><xMotivo>Evento registrado e vinculado a NF-e</xMotivo><chNFe>28120607703290000189550010000002271000026387</chNFe><tpEvento>110110</tpEvento><nSeqEvento>6</nSeqEvento><CNPJDest>99999999000191</CNPJDest><dhRegEvento>2012-07-16T15:23:21-03:00</dhRegEvento><nProt>328120000022720</nProt></infEvento></retEvento></procEventoNFe>' -- * *ADENILTON Batista da Silva
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
