<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
h1
{mso-style-priority:9;
mso-style-link:"Título 1 Car";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:24.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EstiloCorreo17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;
font-weight:normal;
font-style:normal;}
span.Ttulo1Car
{mso-style-name:"Título 1 Car";
mso-style-priority:9;
mso-style-link:"Título 1";
font-family:"Times New Roman",serif;
mso-fareast-language:ES;
font-weight:bold;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="ES" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi erveryone!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It’s Miguel Soleto from National Library of Spain.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I would like to ask you for some help. We are trying to upgrade our Postgres version. Actually, we use 9.4 version and have tested with version 13, 12 and 11. In all cases, CWEB (Version 6.2.1) doesn’t work, and shows this error:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<h1 style="background:#525D76"><span style="font-size:16.5pt;font-family:"Tahoma",sans-serif;color:white">PreparedStatementCallback; bad SQL grammar [SELECT p.uid as p_uid, p.active as p_active, p.comments as p_comments, p.createdon as p_createdon, p.lastupdatedon
as p_lastupdatedon, p.url as p_url, p.additionalurls as p_additionalurls, p.seedtitle as p_seedtitle, p.contentnotes as p_contentnotes, p.technicalnotes as p_technicalnotes, p.harvesttype as p_harvesttype, p.harvestconfig_id as p_harvestConfig_id, b.uid, b.baskettype,
b.active, b.visible, b.codename, b.comments, b.name, b.createdon, b.lastupdatedon, u.uid as u_uid, u.firstname as u_firstname, u.lastname as u_lastname, u.organization as u_organization, u.login as u_login, u.password as u_password, u.email as u_email, u.comments
as u_comments, u.usertype as u_usertype, u.active as u_active, u.memo as u_memo, u.lastconnectedon as u_lastconnectedon, ucreator.uid as ucreator_uid, ucreator.firstname as ucreator_firstname, ucreator.lastname as ucreator_lastname, ucreator.organization as
ucreator_organization, ucreator.login as ucreator_login, ucreator.password as ucreator_password, ucreator.email as ucreator_email, ucreator.comments as ucreator_comments, ucreator.usertype as ucreator_usertype, ucreator.active as ucreator_active, ucreator.memo
as ucreator_memo, ucreator.lastconnectedon as ucreator_lastconnectedon, ueditor.uid as ueditor_uid, ueditor.firstname as ueditor_firstname, ueditor.lastname as ueditor_lastname, ueditor.organization as ueditor_organization, ueditor.login as ueditor_login,
ueditor.password as ueditor_password, ueditor.email as ueditor_email, ueditor.comments as ueditor_comments, ueditor.usertype as ueditor_usertype, ueditor.active as ueditor_active, ueditor.memo as ueditor_memo, ueditor.lastconnectedon as ueditor_lastconnectedon,
t.uid as t_uid, t.name as t_name, d.uid as d_uid, d.name as d_name, hc.harvestfrequency_id as hc_harvestfrequency_id, hf.name as hf_name, hf.nasschedulename as hf_nasname, hc.harvestdepth_id as hc_harvestdepth_id, hd.name as hd_name, hd.nasharvesttemplatename
as hd_nasharvestTempName, hc.harvestbudget_id as hc_harvestbudget_id, hb.name as hb_name, hb.maxobjects as hb_maxobjects, array_to_string(array_agg(k.uid), '|||') as listKeywordUID, array_to_string(array_agg(k.name), '|||') as listKeywordNAME, array_to_string(array_agg(pk.priority),
'|||') as listKeyWordPriority, max(pk.priority) as maxPriority FROM proposition p left outer join basket b on b.uid = p.basket_id left outer join thematic t on t.uid = p.thematic_id left outer join domain d on d.uid = p.domain_id left outer join harvestconfig
hc on hc.uid = p.harvestconfig_id left outer join harvestfrequency hf on hf.uid = hc.harvestfrequency_id left outer join harvestdepth hd on hd.uid = hc.harvestdepth_id left outer join harvestbudget hb on hb.uid = hc.harvestbudget_id left outer join proposition_keyword
pk on pk.proposition_id = p.uid left outer join keyword k on k.uid = pk.keyword_id left outer join useraccount u on u.uid = p.user_id inner join useraccount ucreator on ucreator.uid = p.creator_id inner join useraccount ueditor on ueditor.uid = p.last_editor_id
WHERE basket_id = ? GROUP BY p.uid,p.active , p.comments , p.createdon, p.lastupdatedon , p.url, p.harvesttype , p.harvestconfig_id , b.uid, b.baskettype, b.active, b.visible, p.additionalurls, p.contentnotes, p.technicalnotes, b.codename, b.comments, b.name,
b.createdon, b.lastupdatedon, u.uid , u.firstname ,u.lastname , u.organization , u.login , u.password , u.email , u.comments , u.usertype , u.active , u.memo , u.lastconnectedon ,ucreator.uid , ucreator.firstname , ucreator.lastname , ucreator.organization
, ucreator.login , ucreator.password ,ucreator.email , ucreator.comments , ucreator.usertype , ucreator.active , ucreator.memo , ucreator.lastconnectedon ,ueditor.uid , ueditor.firstname , ueditor.lastname , ueditor.organization , ueditor.login , ueditor.password
,ueditor.email , ueditor.comments , ueditor.usertype , ueditor.active , ueditor.memo , ueditor.lastconnectedon ,t.uid , t.name , d.uid , d.name , hc.harvestfrequency_id , hf.name , hf.nasschedulename , hc.harvestdepth_id , hd.name ,hd.nasharvesttemplatename
, hc.harvestbudget_id , hb.name , hb.maxobjects ]; nested exception is org.postgresql.util.PSQLException: ERROR: la función array_agg(bigint) no es única<o:p></o:p></span></h1>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Which means: “array_agg(bigint) is not unique”. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">On June’s webinar, I asked you what versions of postgres do you use, and someone from France told me that they were using version 11. Does anybody know how to fix this error? Any idea if I am doing something wrong?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks to all!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Best regards.<o:p></o:p></p>
</div>
<hr width="100%">
<font size="1">Este mensaje y cualquier fichero adjunto están dirigidos únicamente a sus destinatarios y contiene información confidencial. Si usted ha recibido este correo electrónico por error, le informamos que no puede realizar ninguna revisión, alteración,
impresión, copia, transmisión, difusión ni utilización alguna de este mensaje ni de cualquier fichero adjunto que pudiese contener. La realización de cualquiera de los actos indicados está expresamente prohibida por las Normas que regulan estas materias. Por
todo ello se solicita que, en caso de existir error en la recepción de este mensaje, se lo notifique al remitente respondiendo a este e-mail y elimine el mensaje y su contenido inmediatamente. La Biblioteca Nacional de España se reserva las acciones legales
que le correspondan en el caso de que se infrinja lo indicado anteriormente.</font>
<hr width="100%">
<font size="1">The information in this e-mail and any attachments is confidential and it is intended for the addressee only. If you have received this e-mail in error, you are notified that any revision, amendment, print, copy, disclosure, distribution or use
of the contents is unauthorized. Carrying out any of the above actions, is expressly banned by rules governing this matter. Hence we request that if you are not the intended recipient, please notify the sender answering this e-mail, and delete the message
and any attachments. The National Library of Spain reserves itself the right to take the appropriate legal actions in the event of the above mentioned matter is being infringed.</font>
<hr width="100%">
</body>
</html>