Skip site navigation (1) Skip section navigation (2)

PgAdmin Bugs & Issues

From: "Alex Girchenko" <gsmdib(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: PgAdmin Bugs & Issues
Date: 2006-11-17 18:24:30
Message-ID: 567e52cd0611171024i333bd2ebv2208416a38f974d0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
The version is that comes with Postgres 8.2 beta3.
1. Under Windows it won't remember the location I've saved dump to.
Instead, I'll always see my home folder. That's quite an unhandy
thing. E.g. I save a dump to c:\dumps and at the next step want to
restore it. Consider it more logical to see c:\dumps in the dialog
window.
2. Dumps created under windows won't restore.
 2.1 Dump (.backup) created from Ubuntu server running PostgreSQL
8.1.4 that is being restored to a PostgreSQL 8.2 under WinXP (UTF-8
both) would fail with
--
pg_restore: [archiver (db)] Error from TOC entry 2341; 0 16548 TABLE
DATA doc_type postgres
pg_restore: [archiver (db)] COPY failed: ERROR:  value too long for
type character varying(50)
CONTEXT:  COPY doc_type, line 7, column alias:
"Инвентаризационные ведомости"
--

Runs flawlessly when restoring under Ubuntu with PgAdmin 1.4.3

 2.2 The same dump restored on the same Ubuntu server with PgAdmin 1.6
would cause even more errors:
--
pg_restore: creating SEQUENCE OWNED BY price_types_archive_id_seq
pg_restore: [archiver (db)] Error from TOC entry 2506; 0 0 SEQUENCE
OWNED BY price_types_archive_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  syntax
error at or near "OWNED"
LINE 1: ALTER SEQUENCE price_types_archive_id_seq OWNED BY price_typ...
                                                  ^
    Command was: ALTER SEQUENCE price_types_archive_id_seq OWNED BY
price_types_archive.id;
--
--
pg_restore: creating SEQUENCE OWNED BY plugin_id_seq
pg_restore: [archiver (db)] Error from TOC entry 2496; 0 0 SEQUENCE
OWNED BY plugin_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  syntax
error at or near "OWNED"
LINE 1: ALTER SEQUENCE plugin_id_seq OWNED BY plugin.id;
                                     ^
    Command was: ALTER SEQUENCE plugin_id_seq OWNED BY plugin.id;
pg_restore: executing SEQUENCE SET plugin_id_seq
--
--
pg_restore: creating SEQUENCE OWNED BY menu_tree_revision_id_seq
pg_restore: [archiver (db)] Error from TOC entry 2478; 0 0 SEQUENCE
OWNED BY menu_tree_revision_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  syntax
error at or near "OWNED"
LINE 1: ALTER SEQUENCE menu_tree_revision_id_seq OWNED BY menu_tree_...
                                                 ^
    Command was: ALTER SEQUENCE menu_tree_revision_id_seq OWNED BY
menu_tree_revision.id;
pg_restore: executing SEQUENCE SET menu_tree_revision_id_seq
--
And the like.

3. Ctrl+A won't work work in the window that displays restoration log.

That's it, folks ;)

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2006-11-17 19:34:40
Subject: Re: Could not find your PostgreSQL installation
Previous:From: Luca FerrariDate: 2006-11-17 17:48:32
Subject: Could not find your PostgreSQL installation in /usr/lib/postgresql/8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group