Dmitry Kotelnikov wrote:
Идея хороша, но через генератор неверное не хорошо будет т.к. он вне
транзакции. А брать что-то типа семафора из специальной таблицы будет
накладно, на каждое срабатывание триггера целый селект.
Целый селект! Да еще по первичному ключу! Из таблички с 1 записью. Ну
жутко много времени займет... ;-)
Подсказка: пихай в табличку ПК записи, на которую не нужно срабатывание
триггера, а в after триггере ее удаляй и будет тебе счастье.
X-Google-Language: RUSSIAN,KOI8R
Received: by 10.54.68.15 with SMTP id q15mr185883wra;
Mon, 22 May 2006 00:03:35 -0700 (PDT)
Return-Path: <[EMAIL PROTECTED]>
Received: from ciao.gmane.org (main.gmane.org [80.91.229.2])
by mx.googlegroups.com with ESMTP id v11si882346cwb.2006.05.22.00.03.34;
Mon, 22 May 2006 00:03:35 -0700 (PDT)
Received-SPF: pass (googlegroups.com: domain of [EMAIL PROTECTED] designates
80.91.229.2 as permitted sender)
Received: from list by ciao.gmane.org with local (Exim 4.43)
id 1Fi4Ro-0000Kf-8M
for [email protected]; Mon, 22 May 2006 09:03:24 +0200
Received: from 212.114.3.235 ([212.114.3.235])
by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
id 1AlnuQ-0007hv-00
for <[email protected]>; Mon, 22 May 2006 09:03:24 +0200
Received: from konst by 212.114.3.235 with local (Gmexim 0.1 (Debian))
id 1AlnuQ-0007hv-00
for <[email protected]>; Mon, 22 May 2006 09:03:24 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: [email protected]
From: "Konstantin R. Beliaev" <[EMAIL PROTECTED]>
Subject: Re: =?KOI8-R?Q?=F4=F2=E9=E7=E5=F2_=C9_=E1=F0=E4=E5=EA=F4_=D7?=
=?KOI8-R?Q?_=CF=C4=CE=CF=CA_=D4=D2=C1=CE=DA=C1=CB=C3=C9=C9?=
Date: Mon, 22 May 2006 11:03:15 +0400
Lines: 9
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]><[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL
PROTECTED]> <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64
X-Complaints-To: [EMAIL PROTECTED]
X-Gmane-NNTP-Posting-Host: 212.114.3.235
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
In-Reply-To: <[EMAIL PROTECTED]>
Sender: news <[EMAIL PROTECTED]>
RG1pdHJ5IEtvdGVsbmlrb3Ygd3JvdGU6Cj4g0JjQtNC10Y8g0YXQvtGA0L7RiNCwLCDQvdC+INGH
0LXRgNC10Lcg0LPQtdC90LXRgNCw0YLQvtGAINC90LXQstC10YDQvdC+0LUg0L3QtSDRhdC+0YDQ
vtGI0L4g0LHRg9C00LXRgiDRgi7Qui4g0L7QvSDQstC90LUKPiDRgtGA0LDQvdC30LDQutGG0LjQ
uC4g0JAg0LHRgNCw0YLRjCDRh9GC0L4t0YLQviDRgtC40L/QsCDRgdC10LzQsNGE0L7RgNCwINC4
0Lcg0YHQv9C10YbQuNCw0LvRjNC90L7QuSDRgtCw0LHQu9C40YbRiyDQsdGD0LTQtdGCCj4g0L3Q
sNC60LvQsNC00L3Qviwg0L3QsCDQutCw0LbQtNC+0LUg0YHRgNCw0LHQsNGC0YvQstCw0L3QuNC1
INGC0YDQuNCz0LPQtdGA0LAg0YbQtdC70YvQuSDRgdC10LvQtdC60YIuCgrQptC10LvRi9C5INGB
0LXQu9C10LrRgiEg0JTQsCDQtdGJ0LUg0L/QviDQv9C10YDQstC40YfQvdC+0LzRgyDQutC70Y7R
h9GDISDQmNC3INGC0LDQsdC70LjRh9C60Lgg0YEgMSDQt9Cw0L/QuNGB0YzRji4g0J3RgyAK0LbR
g9GC0LrQviDQvNC90L7Qs9C+INCy0YDQtdC80LXQvdC4INC30LDQudC80LXRgi4uLiA7LSkK0J/Q
vtC00YHQutCw0LfQutCwOiDQv9C40YXQsNC5INCyINGC0LDQsdC70LjRh9C60YMg0J/QmiDQt9Cw
0L/QuNGB0LgsINC90LAg0LrQvtGC0L7RgNGD0Y4g0L3QtSDQvdGD0LbQvdC+INGB0YDQsNCx0LDR
gtGL0LLQsNC90LjQtSAK0YLRgNC40LPQs9C10YDQsCwg0LAg0LIgYWZ0ZXIg0YLRgNC40LPQs9C1
0YDQtSDQtdC1INGD0LTQsNC70Y/QuSDQuCDQsdGD0LTQtdGCINGC0LXQsdC1INGB0YfQsNGB0YLR
jNC1LgoKCi0tfi0tfi0tLS0tLS0tLX4tLX4tLS0tfi0tLS0tLS0tLS0tLX4tLS0tLS0tfi0tfi0t
LS1+Ci1+LS0tLS0tLS0tLX4tLS0tfi0tLS1+LS0tLX4tLS0tLS1+LS0tLX4tLS0tLS1+LS1+LS0t
Cgo=
