Re: about hacking postgresql

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