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 inserted without committing?
Yes, as long as you run your SELECT within the transaction that you started. Jonathan -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
