From: | Szcząchor Tomasz <tszczachor(at)zke(dot)com(dot)pl> |
---|---|
To: | "postgres" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Cursors and waiting users |
Date: | 1999-06-09 13:03:20 |
Message-ID: | 01beb278$73179ea0$020018ac@szczachor.zke.com.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Linux kernel : 2.0.36, postgresql-6.4.2.
Hello!
I run psql and begin command with transaction :
xxx=>begin work;
BEGIN
xxx=>declare kur1 cursor for select * from tab_name;
Then I run psql on second session and I try to insert something to this
table :
xxx=>insert into tab_name values ('something');
I can't finish this command until I close transaction on first session.
Why?
Does the declaring of cursor lock table for insert and I can't insert into
table? But I use cursor only for viewing of table.
Than, if one user use cursor on the table, second one can't insert data to
that table?
I am beginner in postgress. Help me find my mistakes.
(Sorry for my English).
From | Date | Subject | |
---|---|---|---|
Next Message | José Soares | 1999-06-09 13:15:48 | Re: [SQL] automatic incrementation |
Previous Message | Nuchanard Chiannilkulchai | 1999-06-09 08:47:25 | automatic incrementation |