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 f5DLNME18801 for ; Wed, 13 Jun 2001 17:23:22 -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 f5DLNFl07697; Wed, 13 Jun 2001 18:23:20 -0300 (ADT) (envelope-from jeff@tht.net) X-Authentication-Warning: mercury.tsunamicreek.com: bignose owned process doing -bs Date: Wed, 13 Jun 2001 18:23:14 -0300 (ADT) From: X-X-Sender: Reply-To: To: Robby Slaughter cc: Subject: RE: large going giving errors. In-Reply-To: Message-ID: <20010613182245.L296-100000@mercury.tsunamicreek.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200106/204 X-Sequence-Number: 3460 i actually found the problem, SELECT o.name,o,contactname should be SELECT o.name,o.contactname jeff On Wed, 13 Jun 2001, Robby Slaughter wrote: > 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 > >