Received: from zezam.zke.com.pl (zezam.zke.com.pl [195.205.217.141]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA76942 for ; Wed, 9 Jun 1999 09:09:57 -0400 (EDT) (envelope-from tszczachor@zke.com.pl) Received: from szczachor.zke.com.pl ([172.24.0.2] (may be forged)) by zezam.zke.com.pl with SMTP (8.8.6 (PHNE_14041)/8.7.1R1.0) id PAA06395 for ; Wed, 9 Jun 1999 15:04:54 +0200 (METDST) From: "=?iso-8859-2?Q?Szcz=B1chor_Tomasz?=" To: "postgres" Subject: Cursors and waiting users Date: Wed, 9 Jun 1999 15:03:20 +0200 Message-ID: <01beb278$73179ea0$020018ac@szczachor.zke.com.pl> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.71.1712.3 X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 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).