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

2012-12-20 Thread Groshev Andrey
20.12.2012, 13:00, Bruce Momjian br...@momjian.us: 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: CONSTRAINT; Schema: public; Owner: postgres

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

2012-12-20 Thread Groshev Andrey
20.12.2012, 11:43, Bruce Momjian br...@momjian.us:  19.12.2012, 21:47, Tom Lane t...@sss.pgh.pa.us:  Kevin Grittner kgri...@mail.com writes:   Groshev Andrey wrote:     Mismatch of relation names: database database, old rel public.lob.ВерсияВнешнегоДокумента$Документ_pkey, new rel

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 br...@momjian.us:  On Mon, Dec 17,

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

2012-12-19 Thread Groshev Andrey
'::pg_catalog.oid); ALTER TABLE ONLY lob.ВерсияВнешнегоДокумента$Документ ADD CONSTRAINT plob.ВерсияВнешнегоДокумента$Документ PRIMARY KEY (@Файл, Страница); 20.12.2012, 06:35, Bruce Momjian br...@momjian.us: On Wed, Dec 19, 2012 at 01:51:08PM +0400, Groshev Andrey wrote:  Can you post

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

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 t...@sss.pgh.pa.us: Kevin Grittner kgri...@mail.com writes:  Groshev Andrey wrote:    Mismatch of relation names: database database, old rel

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.ВерсияВнешнегоДокумента$Документ PRIMARY

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

2012-12-17 Thread Groshev Andrey
18.12.2012, 05:22, Bruce Momjian br...@momjian.us: 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