Thread: 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