Re: Query inside transaction [GENERAL]

2004-06-30 Thread NMB Webmaster
But if someone else runs the same transaction in the same time what value does "currval('sequence')" return? That one of the first transaction or that one of the other transaction? Moreover, field id is a unique primary key, it does not accept duplicates. On 25/06/2004 11.58, Michal Táborský <[

Re: [GENERAL] Different runtime on the same query

2004-06-20 Thread NMB Webmaster
20.58, Tom Lane <[EMAIL PROTECTED]> wrote: >NMB Webmaster <[EMAIL PROTECTED]> writes: >> I have two database quite similar, one has more tables than the >other. > >Are both of them vacuumed/analyzed recently? The slow plan seems >to be >estimating many more row

Re: [GENERAL] Separating application from data

2004-06-01 Thread NMB Webmaster
Sorry for CC to mailing list, I forgot!! On 01/06/2004 11.35, Richard Huxton <[EMAIL PROTECTED]> wrote: >Please CC: the mailing list too, other people might have something > >useful to say. > >NMB Webmaster wrote: >> It is for backup purpose. I thought that in this