Re: [HACKERS] Does psql use nested transactions?

2004-08-17 Thread Haroldo Stenger
Hola Alvaro On Tue, 17 Aug 2004 16:58:56 -0400, Alvaro Herrera Munoz <[EMAIL PROTECTED]> wrote: > > On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > > > The other objection is that this would create very substantial overhead. > > > > why? > > Establishing a savepoint is a

Re: [HACKERS] Does psql use nested transactions?

2004-08-17 Thread Haroldo Stenger
Hi Tom On Wed, 11 Aug 2004 11:47:35 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > The other objection is that this would create very substantial overhead. why? > It might be reasonable to offer that behavior as an option, but I think > I'd only want it on for interactive input. How could the ser

Re: [HACKERS] Nested Transaction TODO list

2004-07-03 Thread Haroldo Stenger
On Sat, 03 Jul 2004 17:40:23 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Why does START have a different Node from BEGIN anyway? This seems to > > be a leftover from when people thought they should behave differently. > > They are the same now, so th

[HACKERS] [Fwd: [ADMIN] Transaction Aborting on sql call failure]

2001-09-15 Thread Haroldo Stenger
Sorry, I forgot to repost in hackers. Stephan Szabo wrote: > > > We are running into a situation where psql is aborting the transaction > > when one call returns an error. Is there a way to continue on with > > transaction or at least save what has already happened (like an Oracle > > Save Poi

Re: [HACKERS] Need feedback: GeneXus will support PostgreSQL

2001-09-13 Thread Haroldo Stenger
(On-topic since GeneXus' people decision of supporting PG.) Horst Herb wrote: > > On Thursday 13 September 2001 15:34, Ryan Mahoney wrote: > > What is it? 8) is it middleware? Is it pre-built applications? I'm > > confused! > > It is sort of an application framework and builder. > IMHO not v

Re: [HACKERS] Need feedback: GeneXus will support PostgreSQL

2001-09-13 Thread Haroldo Stenger
Ryan Mahoney wrote: > > What is it? 8) is it middleware? Is it pre-built applications? I'm confused! Genexus is a VRAD tool, database oriented. You code in a mix of graphical forms, and plain code. The code combines logic paradigm, event oriented programming, and imperative code. There is a v

[HACKERS] Need feedback: GeneXus will support PostgreSQL

2001-09-12 Thread Haroldo Stenger
Hi dear people, (My condolences to all afected by terrorist acts in US) As I have been telling for a while, GeneXus database rapid application developing tool, will now add to its set of four databases supported, PostgreSQL. I think this is Great News (C) ;-) Why? Because GeneXus has a great dea

Re: [HACKERS] Abort state on duplicated PKey in transactions

2001-09-10 Thread Haroldo Stenger
If the count was 0 then only insert, else if 1 update, else make some noise > :). > > The alternative is to actually fetch the rows which can be slower. > > Regards, > Link. > > At 12:20 PM 08-09-2001 -0500, Haroldo Stenger wrote: > >transaction should have to be

Re: [HACKERS] Abort state on duplicated PKey in transactions

2001-09-08 Thread Haroldo Stenger
"Matthew T. O'Connor" wrote: > > > A solution, could be to query for the existance of the PK, just before the > > insertion. But there is a little span between the test and the > > insertion, where another insertion from another transaction could void > > the existance test. Any clever ideas on

[HACKERS] Abort state on duplicated PKey in transactions

2001-09-08 Thread Haroldo Stenger
Hi dear people, Now I'm reposting this on hackers from general, sorry if no fully suitable. We are building a RAD tool (GeneXus) support, for PostgreSQL, as I have mentioned before a number of times. A problem which arose, is that within a transaction, if one inserts on a table and the PK restr