Re: [QUESTIONS] Error: ComputeDataSize
Goran Thyni <goran@bs1.bildbasen.kiruna.se>
From: Goran Thyni <goran@bs1.bildbasen.kiruna.se>
To: Patrick Scott Pierce <pspierce@mindspring.net>
Cc: questions@postgresql.org, hackers@postgresql.org
Date: 1998-03-07T11:21:25Z
Lists: pgsql-hackers
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 priority > > And 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