Thread

1. Re: [QUESTIONS] Error: ComputeDataSize

   Goran Thyni <goran@bs1.bildbasen.kiruna.se> — 1998-03-07T11:21:25Z

   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

2. Re: [QUESTIONS] Error: ComputeDataSize

   Patrick Scott Pierce <pspierce@slacker.design.mindspring.net> — 1998-03-07T14:33:47Z

   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:
   
   > 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: 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 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,
   > -- 
   > ---------------------------------------------
   > Gran Thyni, sysadm, JMS Bildbasen, Kiruna