From: | Alexey Dashevsky <alex(at)kpgaz(dot)chernigov(dot)ua> |
---|---|
To: | "pgsql-sql" <pgsql-sql(at)postgresql(dot)org> |
Subject: | left join in cursor |
Date: | 2003-06-09 14:21:03 |
Message-ID: | 20030609142058.877FD1933F@kpgaz.chernigov.ua |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-06-09 14:22:23 | Re: Column limits in table/ views |
Previous Message | Frank Bax | 2003-06-09 14:13:01 | Re: Creating Views with Column Names based on Distinct |