On Wed, Dec 19, 2012 at 01:51:08PM +0400, Groshev Andrey wrote:
> >
> > 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" <[email protected]>:
> >>> 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.ВерсияВнешнегоДокумента$Документ-@Файл; Type: FK CONSTRAINT;
> Schema: public; Owner: postgres
> --
>
> ALTER TABLE ONLY "lob.ВерсияВнешнегоДокумента$Документ"
> ADD CONSTRAINT "rlob.ВерсияВнешнегоДокумента$Документ-@Файл"
> 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.ВерсияВнешнегоДокумента$Документ-@Файл")
> But as I understand it, the problem with the primary key.
[ Sorry I have not been replying promptly. I have been sick with the
flue for the past four days, and while I read the email promptly, my
brain isn't sharp enough to send email out for everyone to read. I am
better today so hopefully I will be 100% soon. ]
OK, this tells me that the period is in the table name:
-- Name:
lob.ВерсияВнешнегоДокумента$Документ;
Type: TABLE; Schema: public; Owner: postgres; Tablespace:
I needed to check that the period wasn't a symptom of a bug.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
