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

2012-12-20 Thread Groshev Andrey
20.12.2012, 11:43, "Bruce Momjian" : >>  19.12.2012, 21:47, "Tom Lane" : >>>  "Kevin Grittner" writes: >>>>   Groshev Andrey wrote: >>>>     Mismatch of relation names: database "database

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

2012-12-20 Thread Groshev Andrey
20.12.2012, 13:00, "Bruce Momjian" : > On Thu, Dec 20, 2012 at 08:55:16AM +0400, Groshev Andrey wrote: > >>  No, old database not use table plob.. >>  only primary key >> >>  -- >>  -- Name: plob.ВерсияВнешнегоДокумента$Документ; Type: C

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

2012-12-19 Thread Groshev Andrey
I'm initialize data dir with use ru_RU.UTF8, but this databse use CP1251, ie one byte per character. 19.12.2012, 21:47, "Tom Lane" : > "Kevin Grittner" writes: > >>  Groshev Andrey wrote: >>    Mismatch of relation names: database "database&

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

2012-12-19 Thread Groshev Andrey
No, people can confuse writing, but it makes a computer. Unfortunately, I have not found developer this database, but I understand the logic was: plob - primary key (lob ~ BLOB) rlob - reference key (lob ~ BLOB) Maybe if I describe the task, this part of the database, the problem is clear. We need

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

2012-12-19 Thread Groshev Andrey
65369'::pg_catalog.oid); ALTER TABLE ONLY "lob.ВерсияВнешнегоДокумента$Документ" ADD CONSTRAINT "plob.ВерсияВнешнегоДокумента$Документ" PRIMARY KEY ("@Файл", "Страница"); 20.12.2012, 06:35, "Bruce Momjian" : > On Wed, Dec 19, 2012 at

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

2012-12-19 Thread Groshev Andrey
> > 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" : >>>  On Mon, Dec 17, 2012

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

2012-12-18 Thread Groshev Andrey
later in the log pg_dump, I found the definition of "new rel" -- -- Name: plob.ВерсияВнешнегоДокумента$Документ; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY "lob.ВерсияВнешнегоДокумента$Документ" ADD CONSTRAINT "plob.ВерсияВнешнегоДокумента$Документ" PR

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

2012-12-17 Thread Groshev Andrey
18.12.2012, 05:22, "Bruce Momjian" : > This is the first pg_upgrade mismatch report we have gotten about 9.1. > I have asked the reporter for details. > > Is what is the full 9.1 version number? > > --- >>  # rpm -qa |grep p