Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5DLcxE24130 for ; Wed, 13 Jun 2001 17:38:59 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f5DLcj003122; Wed, 13 Jun 2001 17:38:45 -0400 (EDT) To: jeff@tht.net cc: pgsql-sql@postgresql.org Subject: Re: large going giving errors. In-reply-to: <20010613173427.G296-100000@mercury.tsunamicreek.com> References: <20010613173427.G296-100000@mercury.tsunamicreek.com> Comments: In-reply-to message dated "Wed, 13 Jun 2001 17:38:12 -0300" Date: Wed, 13 Jun 2001 17:38:45 -0400 Message-ID: <3119.992468325@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/204 X-Sequence-Number: 3462 writes: > 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 > ERROR: copyObject: don't know how to copy 704 You probably wanted "o.contactname" not "o,contactname". 7.2 will give a more useful error message for this sort of mistake ... regards, tom lane