Обсуждение: about hacking postgresql
<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top"><p class="MsoNormal" style="MARGIN:0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language: EN-GB"><font size="3"><font face="Times New Roman">hello,</font></font></span><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language:EN-GB"><font face="Times New Roman" size="3">here more of details</font></span><p class="MsoNormal"style="MARGIN: 0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language: EN-GB"><font size="3"><font face="TimesNew Roman">I have a set of transaction.<span style="mso-spacerun: yes"> </span>Naturally, the transactions executethemselves in competition.<span style="mso-spacerun: yes"> </span>But I would want to give to every transaction apriority. Thus the transaction more priority must execute itself in first.<span style="mso-spacerun: yes"> </span></font></font></span><pclass="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language:EN-GB"><font size="3"><font face="Times New Roman"></font></font></span> <p class="MsoNormal" style="MARGIN:0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language: EN-GB"><font size="3"><font face="Times New Roman">Ithought, as first step, to change the transaction syntax as follows </font></font></span><p class="MsoNormal" style="MARGIN:0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language: EN-GB"><font size="3"><font face="Times New Roman">Starttransaction (priority) </font></font></span><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-GB"style="mso-ansi-language: EN-GB"><font size="3"><font face="Times New Roman"></font></font></span> <p class="MsoNormal"style="MARGIN: 0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language: EN-GB"><font size="3"><font face="TimesNew Roman">But I do not know where to do exactly the change in gram.y </font></font></span><p class="MsoNormal"style="MARGIN: 0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language: EN-GB"><font size="3"><font face="TimesNew Roman">for I have to try to change in TransactionStmt, but I always receive the message syntax error at nownear (</font></font></span><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language:EN-GB"><font size="3"><font face="Times New Roman"></font></font></span> <p class="MsoNormal" style="MARGIN:0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language: EN-GB"><font size="3"><font face="Times New Roman">thanksyou a lot</font></font></span><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-GB" style="mso-ansi-language:EN-GB"><font size="3"><font face="Times New Roman"></font></font></span> </td></tr></table><br />
abdelhak benmohamed wrote: > > hello, > > here more of details > > I have a set of transaction. Naturally, the transactions execute > themselves in competition. But I would want to give to every > transaction a priority. Thus the transaction more priority must > execute itself in first. > > > > I thought, as first step, to change the transaction syntax as follows > > Start transaction (priority) > > > > But I do not know where to do exactly the change in gram.y > > for I have to try to change in TransactionStmt, but I always receive > the message syntax error at now near ( > > > > thanks you a lot > > > > hello ... if you pump then in through the same database connection you do basically the same thing. if you want transactions to lock out each other, take a look at advisory locks. implementing this for "start transaction" seems pretty useless to me however. best regards, hans -- Cybertec Schönig & Schönig GmbH Professional PostgreSQL Consulting, Support, Training Gröhrmühlgasse 26, A-2700 Wiener Neustadt Web: www.postgresql-support.de