Ok I was going to send in the schema from both db's and when trying to get the schema through phppgadmin it works fine on the old db, but on the new db I get this error "PostgreSQL said: ERROR: Relation "pg_relcheck" does not exist"
What is that? And could that be related to my problem? Rob -----Original Message----- From: scott.marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:55 PM To: Rob Sell Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Join Problem On Wed, 23 Jul 2003, Rob Sell wrote: > We are migrating to a new database server and one piece of code doesn't work > from the old to new. > Old server is 7.2.1 > New server is 7.3.2 > > The sql in question is "Select * from inven as i Left Outer Join conn_xr as > c on i.partnum = c.facpn" > > This produces the desired effects on the 7.2.1 server but doesn't work as > expected on 7.3.2 > > I have looked at the release notes from 7.2.1 through 7.3.2 and didn't see > any mention of anything that would affect that particular command. I'm not sure you've given us enough info to help you. Is there anything odd about your table structure? Maybe the two databases were inited with different locales? Maybe some sample schema and data might help... ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
