Received: from mail.utexas.edu (wb2-a.mail.utexas.edu [128.83.126.136]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5DL0qE10462 for ; Wed, 13 Jun 2001 17:00:52 -0400 (EDT) (envelope-from webmaster@robbyslaughter.com) Received: (qmail 16258 invoked by uid 0); 13 Jun 2001 21:00:44 -0000 Received: from adsl-208-190-152-1.dsl.austtx.swbell.net (HELO robmanbox) (208.190.152.1) by umbs-smtp-2 with SMTP; 13 Jun 2001 21:00:44 -0000 Reply-To: From: "Robby Slaughter" To: , Subject: RE: large going giving errors. Date: Wed, 13 Jun 2001 16:00:24 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <20010613173427.G296-100000@mercury.tsunamicreek.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200106/201 X-Sequence-Number: 3457 What happens when you don't join quite so much? That is, take off the AND blah blocks, one by one? -Robby -----Original Message----- From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of jeff@tht.net Sent: Wednesday, June 13, 2001 3:38 PM To: pgsql-sql@postgresql.org Subject: [SQL] large going giving errors. 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.addr ess1,o.address2,uw.id,m.manufacturer,i.type,uw.model,uw.color,uw.size,uw.pri ce 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster