Re: pg_upgrade & tablespaces - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_upgrade & tablespaces
Date
Msg-id 52C34044.1020906@gmail.com
Whole thread Raw
In response to Re: pg_upgrade & tablespaces  (Joseph Kregloh <jkregloh@sproutloud.com>)
Responses Re: pg_upgrade & tablespaces  (Joseph Kregloh <jkregloh@sproutloud.com>)
List pgsql-general
On 12/31/2013 01:31 PM, Joseph Kregloh wrote:
>
>         ERROR:  relation "sys_errors" does not exist
>         LINE 1: SELECT * FROM sys_errors ORDER BY created_ts DESC LIMIT 100;
>                                 ^
>         ********** Error **********
>
>         ERROR: relation "sys_errors" does not exist
>         SQL state: 42P01
>         Character: 15
>
>
>     sys_errors is a table in the tablespace correct?
>
>
> Yes it is.

Completely different thought, is sys_errors in a schema other than PUBLIC?

If so, what is your search_path setting for the new server?

--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_upgrade & tablespaces
Next
From: peterlen
Date:
Subject: Re: Format of Pioint datatype.... lat/long or long/lat??