Re: Error when building new db using pg_restore

From: Jim Longwill <JLongwill(at)psmfc(dot)org>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Jerry Sievers <gsievers19(at)comcast(dot)net>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Error when building new db using pg_restore
Date: 2017-06-22 00:06:21
Message-ID: 8dcff083-5c92-aada-067c-1af10d3fa49c@psmfc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/21/2017 01:21 PM, David G. Johnston wrote:
> On Wed, Jun 21, 2017 at 1:10 PM, Jim Longwill <JLongwill(at)psmfc(dot)org> wrote:
>
>> rdev1=# \dd
>> Object descriptions
>> Schema | Name | Object | Description
>> --------+------+--------+-------------
>> (0 rows)
> Nothing user created has comments by default. \dd only shows a very
> limited subset of user created objects by default. That you didn't
> explicit add comments to any of those types objects is unsurprising.
> See the docs for exactly what "\dd" and "\ddS" will consider.
>
> David J.
Ok.. I've tried again using psql \dd.. type commands to locate this
COMMENT object,
including as 'postgres' and in the source database of the tar file but
it does not show up.
Yes.. we have never put in any object comments, so it must have come in
from the postgres
installation. It'll be tough to delete this thing if I can't find it,
but oh well!

I won't worry about this much more, but if the system identifies it as
an error then
I thought it was at least worth making the inquiry. Thanks!
--Jim :^)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-06-22 00:30:42 Re: Error when building new db using pg_restore
Previous Message David G. Johnston 2017-06-21 20:21:21 Re: Error when building new db using pg_restore