Re: Oracle vs PG

From: James Keener <jim(at)jimkeener(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org,Ravi Krishna <srkrishna1(at)aol(dot)com>,adrian(dot)klaver(at)aklaver(dot)com
Subject: Re: Oracle vs PG
Date: 2018-10-23 23:38:34
Message-ID: 2A133791-7512-4DB9-B7C3-2469CD2D939A@jimkeener.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>I have hardly used savepoints in any application, but if I understand
>it correctly, isn't it something which is typically used
>in a persistent connection. I wonder how it is applicable in a web
>based stateless application like Amazon.com, unless
>even web based application have database level state.

Doesn't need to be a long running connection, you can trap exceptions, roll back, and do something else all in the SQL code or a function from a single call.

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2018-10-23 23:52:52 Re: Oracle vs PG
Previous Message Ravi Krishna 2018-10-23 23:35:37 Re: Oracle vs PG