Thread: postgresql commit.

Oracle database, the other user can't see the uncommited data,  for
postgresql 8.2 , it looks like once you issue insert , the other user will
automatically see new record. was it wrong? I am pretty new to postgresql?
Thanks.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-commit-tp5596729p5596729.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

On Mon, Mar 26, 2012 at 6:22 PM, leaf_yxj <leaf_yxj@163.com> wrote:
> Oracle database, the other user can't see the uncommited data,  for
> postgresql 8.2 , it looks like once you issue insert , the other user will
> automatically see new record. was it wrong? I am pretty new to postgresql?

Most likely you are committing somewhere.  Maybe you are doing this in
psql and autocommit is turned on in the front end?

Best Wishes,
Chris Travers

On Mon, Mar 26, 2012 at 06:22:20PM -0700, leaf_yxj wrote:
> Oracle database, the other user can't see the uncommited data,  for
> postgresql 8.2 , it looks like once you issue insert , the other user will
> automatically see new record. was it wrong? I am pretty new to postgresql?

Did you actually start a transaction (i.e. issue BEGIN)?  If not, your
statement COMMITs automatically.

Also, you might want to note the remark on the PostgreSQL security
pages: "Please note that versions prior to 8.3 are no longer supported
and vulnerabilities for these versions may not be included in this
list. New vulnerabilities in these versions are no longer patched."
See http://www.postgresql.org/support/security/.  I'd plan to upgrade
soon.

Best,

A

--
Andrew Sullivan
ajs@crankycanuck.ca