X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 83C5F311A47
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 10 Jun 2003 08:42:01 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 59050-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 10 Jun 2003 05:41:51 -0300 (ADT)
Received: from elit.ci.net.ua (mail.cn.ua [212.86.96.11])
	by svr1.postgresql.org (Postfix) with ESMTP id F1516311BB3
	for <pgsql-sql@postgresql.org>; Mon,  9 Jun 2003 14:24:02 +0000 (GMT)
Received: (from uucp@localhost)
	by elit.ci.net.ua (8.11.6/8.11.5) with UUCP id h59EP9938986
	for pgsql-sql@postgresql.org; Mon, 9 Jun 2003 17:25:09 +0300 (EEST)
X-Spam-Filter: check_local@elit.ci.net.ua by digitalanswers.org
Received: from localhost (localhost.localdomain [127.0.0.1])
	by kpgaz.chernigov.ua (Postfix) with SMTP id E9B0819485
	for <pgsql-sql@postgresql.org>; Mon,  9 Jun 2003 17:20:58 +0300 (EEST)
Received: from there (develop.kpgaz2 [192.168.20.13])
	by kpgaz.chernigov.ua (Postfix) with SMTP id 877FD1933F
	for <pgsql-sql@postgresql.org>; Mon,  9 Jun 2003 17:20:58 +0300 (EEST)
Content-Type: text/plain;
  charset="koi8-u"
From: Alexey Dashevsky <alex@kpgaz.chernigov.ua>
To: "pgsql-sql" <pgsql-sql@postgresql.org>
Subject: left join in cursor
Date: Mon, 9 Jun 2003 17:21:03 +0300
X-Mailer: KMail [version 1.3.1]
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <20030609142058.877FD1933F@kpgaz.chernigov.ua>
X-Archive-Number: 200306/76
X-Sequence-Number: 13834

Hi.

Exists too tables (PostgreSQL 7.2.3):

a ("cl" integer primary key, a1, a2, ...) - 100000 records;

b ("cl" integer primary key, b1, b2, ...) - 800 records.

BEGIN;

DECLARE "c" SCROLL CURSOR FOR select a.*,r.b1 as rb1 from a left join b using 
(cl) order by a.cl;

FETCH FORWARD 100 in "c"; 

FETCH FORWARD 100 in "c";

MOVE -200 in "c";

NOTICE:  Message from PostgreSQL backend:
	The Postmaster has informed me that some other backend
	died abnormally and possibly corrupted shared memory.
	I have rolled back the current transaction and am
	going to terminate your database system connection and exit.
	Please reconnect to the database system and repeat your query.

Without left join - all rights.

Why?

Thanks in advance.