Left join error

From: "Ligia Pimentel" <lmpimentel(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Left join error
Date: 2001-11-05 17:39:02
Message-ID: 9s6j7s$2vvf$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello.
I have a table with 146000+ records. I tried to select with a left join to
another table but I get this message:

ERROR: MemoryContextAlloc: invalid request size 4294967293

This is the query.

select * from cheques left join formasenblanco on cheques.cheque=
formasenblanco.cheque where formasenblanco.cheque is null;

The table cheques has about 146000+ records. Formasenblanco is smaller. I
know I can use subquerys, but in theory, this is much slower.
I'm using Postgres 7.1 on Redhat 6.2

Does anyone have a suggestion?

Thank you.

Ligia

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message X 2001-11-05 18:13:15 copy command with PSQL
Previous Message Josh Berkus 2001-11-05 16:57:10 Re: Help with a complex Update