Re: Join Problem

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Rob Sell <robs(at)facnd(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Join Problem
Date: 2003-07-23 20:32:06
Message-ID: Pine.LNX.4.33.0307231431090.23336-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 23 Jul 2003, Rob Sell wrote:

> 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?

Nah, likely just a version issue (i.e. the new database doesn't have the
system tables that phppgadmin expects)

you can get a dump of the schema / tables with pg_dump on each box:

pg_dump -s dbname -t tablename <- this will dump the schema

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Network Administrator 2003-07-23 20:47:21 Re: birthday calculation
Previous Message Bruce Momjian 2003-07-23 20:30:13 Re: dump_all/restore times?