Invalid object name 'sysindexkeys' when using migration wizard

From: "Evans, Rick (MN14)" <Rick(dot)Evans(at)honeywell(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Invalid object name 'sysindexkeys' when using migration wizard
Date: 2003-01-23 15:28:55
Message-ID: EECB5C454913D71182A90090279C652F4F0F06@mn14-p01.ssec.honeywell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

When I try to migrate any tables from an SQL Server 6.5 database to a
Postgres 7.3 database it fails. Is the problem in PgAdmin II or elsewhere?
I get the following message in the Migration Wizard.
-----------------
Creating table: PPT_Products

An error occured at: 1/23/2003 8:46:39 AM:
-2147217865: Invalid object name 'sysindexkeys'.

Rolling back... Done.
-----------------

Here is the errors/SQL Pgadmin II log:

2003-01-23 08:45:17 - SQL (template1): SELECT version()
2003-01-23 08:45:17 - SQL (template1): SELECT datlastsysoid FROM pg_database
WHERE datname = 'template1'
2003-01-23 08:45:17 - SQL (template1): SELECT oid, datname, datpath,
datallowconn, pg_encoding_to_char(encoding) AS serverencoding,
pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname
2003-01-23 08:45:17 - SQL (template1): SELECT * FROM pg_group ORDER BY
groname
2003-01-23 08:45:17 - SQL (template1): SELECT * FROM pg_user ORDER BY
usename
2003-01-23 08:45:17 - SQL (template1): SELECT datname, procpid, usename,
current_query FROM pg_stat_activity
2003-01-23 08:46:28 - SQL (ppt_production): SELECT oid, relname,
pg_get_userbyid(relowner) as tableowner, relacl, relhasoids FROM pg_class
WHERE ((relkind = 'r') OR (relkind = 's')) ORDER BY relname
2003-01-23 08:46:39 - SQL (ppt_production): BEGIN
2003-01-23 08:46:39 - SQL (ppt_production): ROLLBACK
-----------------------
here is the psqlodbc log:

conn=55522888, PGAPI_DriverConnect( in)=
'
DRIVER={PostgreSQL};
UID=evans_rick;PWD=********;
SERVER=129.30.159.239;
PORT=5432;
DATABASE=template1;
READONLY=0;PROTOCOL=6.4;
FAKEOIDINDEX=0;
SHOWOIDCOLUMN=0;
ROWVERSIONING=0;
SHOWSYSTEMTABLES=0;
CONNSETTINGS=;
FETCH=100;
SOCKET=4096;
UNKNOWNSIZES=0;
MAXVARCHARSIZE=254;
MAXLONGVARCHARSIZE=65536;
OPTIMIZER=1;
KSQO=1;
USEDECLAREFETCH=0;
TEXTASLONGVARCHAR=1;
UNKNOWNSASLONGVARCHAR=1;
BOOLSASCHAR=1;
PARSE=0;
CANCELASFREESTMT=0;
EXTRASYSTABLEPREFIXES=dd_;
COMMLOG=0;
DEBUG=0;
'
, fDriverCompletion=0
------------------------------------------

Browse pgadmin-support by date

  From Date Subject
Next Message Gunter Fischer 2003-01-23 16:23:18 ODBC Error??
Previous Message Dave Page 2003-01-22 21:34:11 Re: Connection