John Fabiani wrote:
> Yes I understand - but I want to know is it possible? Can I read the data I
> just inserted without a commit.
> [...]
Are you talking about a web application? Then no, you'll
have to code that yourself.
Tim
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
On Friday, March 23, 2012 04:00:56 PM Rob Sargent wrote:
> And I believe Jonathon confirmed that you could, with the caveat that
> you must select from within the transaction. I don't see that you've
> laid that out your connection stategy so ymmv.
I didn't see Jonathon response? Must be a dire
And I believe Jonathon confirmed that you could, with the caveat that
you must select from within the transaction. I don't see that you've
laid that out your connection stategy so ymmv.
On 03/23/2012 03:49 PM, John Fabiani wrote:
Yes I understand - but I want to know is it possible? Can I rea
Yes I understand - but I want to know is it possible? Can I read the data I
just inserted without a commit.
Johnf
On Friday, March 23, 2012 03:46:10 PM Rob Sargent wrote:
> If possible have the review done before starting the transaction. No
> sense in holding on to that stuff too long. Potentia
If possible have the review done before starting the transaction. No
sense in holding on to that stuff too long. Potential concurrency issues
etc.
On 03/23/2012 03:40 PM, Jonathan S. Katz wrote:
On Mar 23, 2012, at 5:33 PM, John Fabiani wrote:
I start a transaction.
Begin
Then I insert a l
On Mar 23, 2012, at 5:33 PM, John Fabiani wrote:
> I start a transaction.
> Begin
>
> Then I insert a lot of data - let's say two hundred rows.
>
> Now I need to read the same data (so the user can review).
>
> If the user thinks all is right then
> commit.
>
> Can I read the data I just inse
Hi,
I know this is a newbie question but I have never had the need to do the
following.
I start a transaction.
Begin
Then I insert a lot of data - let's say two hundred rows.
Now I need to read the same data (so the user can review).
If the user thinks all is right then
commit.
Can I read th
The function calculates the data line by line, and inserts into the
table, at the end of the function I need to send data from a table to
another database via dblink. I noticed that the problem is to perform
this operation in one function (or the main function of the two
subfunction). My guess is t
