Received: from mercury.tsunamicreek.com (nat209.153.mpoweredpc.net [142.177.209.153]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5DKcAE02318 for ; Wed, 13 Jun 2001 16:38:10 -0400 (EDT) (envelope-from jeff@tht.net) Received: from localhost (bignose@localhost) by mercury.tsunamicreek.com (8.11.2/8.11.2) with ESMTP id f5DKcD307555 for ; Wed, 13 Jun 2001 17:38:13 -0300 (ADT) (envelope-from jeff@tht.net) X-Authentication-Warning: mercury.tsunamicreek.com: bignose owned process doing -bs Date: Wed, 13 Jun 2001 17:38:12 -0300 (ADT) From: X-X-Sender: Reply-To: To: Subject: large going giving errors. Message-ID: <20010613173427.G296-100000@mercury.tsunamicreek.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200106/200 X-Sequence-Number: 3456 Hi I have a largeish join that is giving me an error.. here's the query SELECT o.name,o,contactname,o.contactphone,o.fax,o.emailaddy,o.freetelephone,o.address1,o.address2,uw.id,m.manufacturer,i.type,uw.model,uw.color,uw.size,uw.price FROM user_wantads AS uw,organisations AS o,users AS u ,itemtypes AS i,itemmanufacturers AS m,provinces AS p,cities AS ct,countries AS cy WHERE uw.owner = u.loginid AND u.belongsto = o.organisationid AND m.id=uw.manufacturer AND i.id=uw.itemtype AND o.provinceid=p.provinceid AND o.cityid=ct.cityid AND o.countryid=cy.countryid AND uw.id=9 and the error ERROR: copyObject: don't know how to copy 704 can anyone shed a little light please ? jeff.