Re: Join Problem

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:scott(dot)marlowe(at)ihs(dot)com]
Sent: Wednesday, July 23, 2003 2:55 PM
To: Rob Sell
Cc: pgsql-general(at)postgresql(dot)org
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...