<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi,<div><br></div><div>I have pgpool setup with streaming replication and master/slave. I got the following error</div><div><br></div><div>cannot execute INSERT in a read-only transaction</div><div><br></div><div>after this query in the psql client</div><div><br></div><div>INSERT INTO test (testa, testb, testc) VALUES ('hi','hi','hi');</div><div><br></div><div>I couldn't find a solution online. Some threads suggested black list functions but I wasn't sure if that was the avenue to pursue.</div><div><br></div><div>Thanks</div> </div></body>
</html>