pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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
Message-ID: <20030609142058.877FD1933F@kpgaz.chernigov.ua> (raw)

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.



view thread (2+ messages)  latest in thread

Message-ID: <20030609142058.877FD1933F@kpgaz.chernigov.ua>
Permalink:  ../20030609142058.877FD1933F@kpgaz.chernigov.ua/
Also on:    postgresql.org/message-id/20030609142058.877FD1933F@kpgaz.chernigov.ua

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: alex@kpgaz.chernigov.ua
  Subject: Re: left join in cursor
  In-Reply-To: <20030609142058.877FD1933F@kpgaz.chernigov.ua>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox