[SQL] Problem with inserting data produced by the function (when the function is performed).

2012-03-23 Thread Bear
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

[SQL] Can I read the data without commit

2012-03-23 Thread John Fabiani
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

Re: [SQL] Can I read the data without commit

2012-03-23 Thread Jonathan S. Katz
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

Re: [SQL] Can I read the data without commit

2012-03-23 Thread Rob Sargent
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

Re: [SQL] Can I read the data without commit

2012-03-23 Thread John Fabiani
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

Re: [SQL] Can I read the data without commit

2012-03-23 Thread Rob Sargent
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

Re: [SQL] Can I read the data without commit

2012-03-23 Thread John Fabiani
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

Re: [SQL] Can I read the data without commit

2012-03-23 Thread Tim Landscheidt
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)