Skip site navigation (1) Skip section navigation (2)

BUG #6602: concurrent psql session clobbers history

From: i+pgbugs(at)avdd(dot)tk
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6602: concurrent psql session clobbers history
Date: 2012-04-19 10:02:35
Message-ID: E1SKoCB-00068b-5S@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6602
Logged by:          Adrian Dries
Email address:      i+pgbugs(at)avdd(dot)tk
PostgreSQL version: 9.1.3
Operating system:   Ubuntu ppa:pitti/postgresql
Description:        

A concurrent psql session will overwrite the history of the first.  This
does not look good: a database tool causing me to lose my data!

# session 1

$ psql -q
postgres=# \echo first session exits first
first session exits first
postgres=# \q
$ cat .psql_history 
\echo first session exits first
\q
$ psql -q
postgres=# 
$ cat .psql_history 
\echo second session exits second
\q
$ psql -q
postgres=# \echo first session exits second
first session exits second
postgres=# \q
$ cat .psql_history 
\echo second session exits second
\q
\echo first session exits second
\q

# session 2

$ psql -q
postgres=# \echo second session exits second
second session exits second
postgres=# \q
$ cat .psql_history 
\echo second session exits second
\q
$ psql -q
postgres=# \echo second session exits first
second session exits first
postgres=# \q
$ cat .psql_history 
\echo second session exits second
\q
\echo second session exits first
\q
 



Responses

pgsql-bugs by date

Next:From: ljwilsonDate: 2012-04-19 13:30:06
Subject: Re: BUG #6204: Using plperl functions generate crash
Previous:From: Amit KapilaDate: 2012-04-19 02:38:50
Subject: FW: clarification for generate join implied equalities

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group