Re: [GENERAL] postgresql commit.
Hi Andrew, Thanks. I got it. Regards. Grace At 2012-03-27 12:36:18,"Andrew Sullivan-8 [via PostgreSQL]" wrote: 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 [hidden email] -- Sent via pgsql-general mailing list ([hidden email]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/postgresql-commit-tp5596729p5596931.html To unsubscribe from postgresql commit., click here. NAML -- View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-commit-tp5596729p5599238.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Re: [GENERAL] postgresql commit.
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 a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql commit.
On Mon, Mar 26, 2012 at 6:22 PM, 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? 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general