Invalid object name 'sysindexkeys' when using migration wizard
От | Evans, Rick (MN14) |
---|---|
Тема | Invalid object name 'sysindexkeys' when using migration wizard |
Дата | |
Msg-id | EECB5C454913D71182A90090279C652F4F0F06@mn14-p01.ssec.honeywell.com обсуждение исходный текст |
Список | 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 ------------------------------------------
В списке pgadmin-support по дате отправления: