Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with pg_upgrade after change of unix user running db. - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems with pg_upgrade after change of unix user running db.
Date
Msg-id 21621.1448676464@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems with pg_upgrade after change of unix user running db.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Problems with pg_upgrade after change of unix user running db.
List pgsql-general
Tree view 
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 11/27/2015 08:15 AM, Bruce Momjian wrote:
>> My guess is you are sharing the constraint name "seqno_not_null" with
>> multiple tables.  I think you are going to have to dig into the system
>> tables to see where that is referenced and fix it.

> In the post below the OP shows the tables involved(they where inherited):
> http://www.postgresql.org/message-id/CADbMkNM_y9ewdaWdQ_8DJ1mUC0Z_FGwTyAD2RwCHgExj2jvOHQ@mail.gmail.com

Inherited eh?  Maybe related to 074c5cfbf.

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: 2 questions
Next
From: Adrian Klaver
Date:
Subject: Re: Problems with pg_upgrade after change of unix user running db.