| 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: | Whole Thread | Raw Message | 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 |