Re: [SQL] Retrieving the new "nextval" for primary keys....

2002-09-02 Thread GB Clark
On Wed, 28 Aug 2002 18:36:10 +0200 (CEST) friedrich nietzsche <[EMAIL PROTECTED]> wrote: > One solution seems to locking table(s), > but I prefer to leave it as last chance... > using table locks, and the trick of writing and > suddenly reading back from DB it probably works, > but it doesn't se

Re: [SQL] Retrieving the new nextval...

2002-09-02 Thread GB Clark
On Wed, 28 Aug 2002 18:32:45 +0200 (CEST) friedrich nietzsche <[EMAIL PROTECTED]> wrote: > Hi all, > I'm in trouble with the same problem, but in PHP.. > With your solution, I cannot be totally sure that last > inserted raw was mine... > Because I'm on a web page, it could be that, as soon > as I

Re: [SQL] union optimization in views

2002-09-02 Thread Stephan Szabo
On Thu, 29 Aug 2002, Josh Berkus wrote: > Joe, > > > We are attempting to move a couple of systems from Oracle to Postgres but > can not do so without application rewrites due to the current use of views > with UNIONs and the criticality of the performances of these views. > > > > I was wondering