Re: [QUESTIONS] Error: ComputeDataSize
Patrick Scott Pierce wrote:
I run this query:
select distinct task.*
from project, task
where task.projid = (select projid from project where custid =
(select custid from customer where domain = 'atlantahighrise.com')
and title = 'Initial site design')
and task.owner = 'ninjaman' order by priorityAnd get this error:
ERROR: ComputeDataSize: attribute 0 has len 0
At least 6.3 is strict about tables.
The table "project" is not used in the main query,
remove it and it should be OK.
I don't know if this behaviour is intentional or a "feature",
anyone having more insite into this.
regards,
--
---------------------------------------------
G�ran Thyni, sysadm, JMS Bildbasen, Kiruna
Import Notes
Reference msg id not found: 19980306.21202400@slacker.design.mindspring.net
I changed the query after sending it (within minutes) and all was and is
well. Thanks.
Patrick Scott Pierce
pspierce@mindspring.com
CGI Programming
Mindspring Enterprises
On Sat, 7 Mar 1998, Goran Thyni wrote:
Show quoted text
Date: Sat, 07 Mar 1998 12:21:25 +0100
From: Goran Thyni <goran@bs1.bildbasen.kiruna.se>
To: Patrick Scott Pierce <pspierce@mindspring.net>
Cc: questions@postgresql.org, hackers@postgresql.org
Subject: Re: [QUESTIONS] Error: ComputeDataSizePatrick Scott Pierce wrote:
I run this query:
select distinct task.*
from project, task
where task.projid = (select projid from project where custid =
(select custid from customer where domain = 'atlantahighrise.com')
and title = 'Initial site design')
and task.owner = 'ninjaman' order by priorityAnd get this error:
ERROR: ComputeDataSize: attribute 0 has len 0At least 6.3 is strict about tables.
The table "project" is not used in the main query,
remove it and it should be OK.I don't know if this behaviour is intentional or a "feature",
anyone having more insite into this.regards,
--
---------------------------------------------
G�ran Thyni, sysadm, JMS Bildbasen, Kiruna