left join in cursor - Mailing list pgsql-sql

From Alexey Dashevsky
Subject left join in cursor
Date
Msg-id 20030609142058.877FD1933F@kpgaz.chernigov.ua
Whole thread Raw
Responses Re: left join in cursor
List pgsql-sql
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 backenddied abnormally and
possiblycorrupted shared memory.I have rolled back the current transaction and amgoing to terminate your database
systemconnection and exit.Please reconnect to the database system and repeat your query.
 

Without left join - all rights.

Why?

Thanks in advance.


pgsql-sql by date:

Previous
From: george young
Date:
Subject: find open transactions/locks in 7.2?
Next
From: Richard Huxton
Date:
Subject: Re: Retype