Re: [GENERAL] trouble with pg_upgrade 9.0 -> 9.1

From: Groshev Andrey <greenx(at)yandex(dot)ru>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] trouble with pg_upgrade 9.0 -> 9.1
Date: 2012-12-19 09:51:08
Message-ID: 588511355910668@web1g.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

>
> Can you post the full definition of the table on this public email list?
> Also, why did the error think this was in the public schema?  Any idea?
>
> ---------------------------------------------------------------------------
>
>>  18.12.2012, 19:38, "Bruce Momjian" <bruce(at)momjian(dot)us>:
>>>  On Mon, Dec 17, 2012 at 09:21:59PM -0500, Bruce Momjian wrote:
>>>>>   Mismatch of relation names: database "database", old rel public.lob.ВерсияВнешнегоДокумента$Документ_pkey, new rel public.plob.ВерсияВнешнегоДокумента$Документ
>>>>>   Failure, exiting
...... snip ....

It's all what I'm found about this table.

--
-- Name: lob.ВерсияВнешнегоДокумента$Документ; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE "lob.ВерсияВнешнегоДокумента$Документ" (
"@Файл" integer NOT NULL,
"Страница" integer NOT NULL,
"Данные" bytea
);

ALTER TABLE public."lob.ВерсияВнешнегоДокумента$Документ" OWNER TO postgres;

--
-- Name: plob.ВерсияВнешнегоДокумента$Документ; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY "lob.ВерсияВнешнегоДокумента$Документ"
ADD CONSTRAINT "plob.ВерсияВнешнегоДокумента$Документ"
PRIMARY KEY ("@Файл", "Страница");

--
-- Name: rlob(dot)ВерсияВнешнегоДокумента$Документ-(at)Файл; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY "lob.ВерсияВнешнегоДокумента$Документ"
ADD CONSTRAINT "rlob(dot)ВерсияВнешнегоДокумента$Документ-(at)Файл"
FOREIGN KEY ("@Файл")
REFERENCES "ВерсияВнешнегоДокумента$Документ"("@Файл")
ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE;

--
-- Name: lob.ВерсияВнешнегоДокумента$Документ; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE "lob.ВерсияВнешнегоДокумента$Документ" FROM PUBLIC;
REVOKE ALL ON TABLE "lob.ВерсияВнешнегоДокумента$Документ" FROM postgres;
GRANT ALL ON TABLE "lob.ВерсияВнешнегоДокумента$Документ" TO postgres;
GRANT SELECT ON TABLE "lob.ВерсияВнешнегоДокумента$Документ" TO view_user;

There is another table "ВерсияВнешнегоДокумента$Документ" (without ^lob.)
It is referenced by a foreign key ("rlob(dot)ВерсияВнешнегоДокумента$Документ-(at)Файл")
But as I understand it, the problem with the primary key.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2012-12-19 13:08:06 Join several tables (to fetch user info), but one of them is optional (user avatar)
Previous Message Glyn Astill 2012-12-19 09:49:41 Re: Vacuum analyze verbose output

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Berg 2012-12-19 10:08:08 Re: configure.in and setproctitle/optreset problem
Previous Message Simon Riggs 2012-12-19 08:34:15 Re: Cascading replication: should we detect/prevent cycles?