PGAdmin에서 restore를 할때 나는 에러입니다.
밑에 return 1이라고 에러가 리턴되기는 하는데,
그냥 테이블이나, 트리거등을 보면 정상적인것 같습니다.
그냥 사용해도 무관할것 같기도 한데..
그래도 return 에러가 떠서 찝찝해서 질문올려봅니다.
데이터베이스는 새로 생성한 즉시 그 데이터베이스로
복원했구요..
왜 저런 에러가 나는지 아시는분 좀 답변 주시면
감사하겠습니다.
다음은 PGAdmin에서 Restore시 에러메시지입니다.
밑에서
|
|
표시는 길어서 중간생략한겁니다^^
====================================================================================
C:\Program Files\PostgreSQL\8.0\pgAdmin III\pg_restore.exe -i -h
localhost -p 5432 -U postgres -d hicom -v
"D:\Backup\cust\cust.backup"
pg_restore: connecting to database for restore
pg_restore: creating DUMP TIMESTAMP DUMP TIMESTAMP
pg_restore: creating SCHEMA public
pg_restore: creating COMMENT SCHEMA public
pg_restore: creating FUNCTION plpgsql_call_handler()
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 17; 1255 17712
FUNCTION plpgsql_call_handler() postgres
pg_restore: [archiver (db)] could not execute query: ERROR:
function "plpgsql_call_handler" already exists with same argument
types
Command was: CREATE FUNCTION plpgsql_call_handler() RETURNS
language_handler
AS '$libdir/plpgsql', 'plpgsql_call_handler'
LANGUAG...
pg_restore: creating FUNCTION plpgsql_validator(oid)
pg_restore: [archiver (db)] Error from TOC entry 18; 1255 17713
FUNCTION plpgsql_validator(oid) postgres
pg_restore: [archiver (db)] could not execute query: ERROR:
function "plpgsql_validator" already exists with same argument
types
Command was: CREATE FUNCTION plpgsql_validator(oid) RETURNS
void
AS '$libdir/plpgsql', 'plpgsql_validator'
LANGUAGE c;
pg_restore: creating PROCEDURAL LANGUAGE plpgsql
pg_restore: [archiver (db)] Error from TOC entry 344; 16402 17714
PROCEDURAL LANGUAGE plpgsql
pg_restore: [archiver (db)] could not execute query: ERROR:
language "plpgsql" already exists
Command was: CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER
plpgsql_call_handler VALIDATOR plpgsql_validator;
pg_restore: creating FUNCTION func_buyitem_af_de_row()
|
|
pg_restore: creating FUNCTION func_sellitem_update()
pg_restore: creating TABLE accountmain
pg_restore: creating TABLE accountsub
pg_restore: creating SEQUENCE bscp
pg_restore: executing SEQUENCE SET bscp
pg_restore: creating TABLE busisumday
|
|
pg_restore: creating TABLE zipcode
pg_restore: restoring data for table "accountmain"
|
|
pg_restore: restoring data for table "BLOBS"
pg_restore: restored 0 large objects
pg_restore: creating CONSTRAINT accountmain_pkey
|
|
pg_restore: creating CONSTRAINT zipcode_pkey
pg_restore: creating INDEX idx_buyitem_custcode
|
|
pg_restore: creating INDEX idx_sellitem_itemcode
pg_restore: creating INDEX pbsyscatcoldict_idx
|
|
pg_restore: creating INDEX pbsyspbe_idx
pg_restore: creating TRIGGER tr_buyitem_af_de_row
|
|
pg_restore: creating TRIGGER tr_sellitem_af_up_row
pg_restore: creating FK CONSTRAINT
fk_accounts_ref_21978_accountm
|
|
pg_restore: creating FK CONSTRAINT
fk_taxselld_ref_21973_taxsell
pg_restore: creating DUMP TIMESTAMP DUMP TIMESTAMP
pg_restore: setting owner and privileges for DUMP TIMESTAMP DUMP
TIMESTAMP
pg_restore: setting owner and privileges for SCHEMA public
pg_restore: setting owner and privileges for COMMENT SCHEMA
public
pg_restore: setting owner and privileges for ACL public
pg_restore: setting owner and privileges for FUNCTION
plpgsql_call_handler()
pg_restore: setting owner and privileges for FUNCTION
plpgsql_validator(oid)
pg_restore: setting owner and privileges for PROCEDURAL LANGUAGE
plpgsql
pg_restore: setting owner and privileges for FUNCTION
func_buyitem_af_de_row()
|
|
pg_restore: setting owner and privileges for FUNCTION
func_sellitem_update()
pg_restore: setting owner and privileges for TABLE
accountmain
pg_restore: setting owner and privileges for TABLE accountsub
pg_restore: setting owner and privileges for SEQUENCE bscp
pg_restore: setting owner and privileges for TABLE busisumday
|
|
pg_restore: setting owner and privileges for TABLE zipcode
pg_restore: setting owner and privileges for CONSTRAINT
accountmain_pkey
|
|
pg_restore: setting owner and privileges for CONSTRAINT
zipcode_pkey
pg_restore: setting owner and privileges for INDEX
idx_buyitem_custcode
|
|
pg_restore: setting owner and privileges for INDEX
idx_sellitem_itemcode
pg_restore: setting owner and privileges for INDEX
pbsyscatcoldict_idx
|
|
pg_restore: setting owner and privileges for INDEX
pbsyspbe_idx
pg_restore: setting owner and privileges for TRIGGER
tr_buyitem_af_de_row
|
|
pg_restore: setting owner and privileges for TRIGGER
tr_sellitem_af_up_row
pg_restore: setting owner and privileges for FK CONSTRAINT
fk_accounts_ref_21978_accountm
|
|
pg_restore: setting owner and privileges for FK CONSTRAINT
fk_taxselld_ref_21973_taxsell
pg_restore: setting owner and privileges for DUMP TIMESTAMP DUMP
TIMESTAMP
WARNING: errors ignored on restore: 3
--
-- PostgreSQL database dump complete
--
Process returned exit code 1.
====================================================================================
|