Re: [GENERAL] error msg when pg_restore

2006-08-23 Thread nuno
hi, there, tom. thank you for your help. i turned -c off and now i find a less no. of errors, however, i still get them! (i used to have approx 70 'errors ignored on restore', now i have approx 30 or even less than that). one of errors is like below; pg_restore: [archiver (db)] Error from TOC

Re: [GENERAL] error msg when pg_restore

2006-08-23 Thread nuno
by the way, i had 3 different types of errors messages; 1. pg_restore: [archiver (db)] Error from TOC entry 17; 1255 17233 FUNCTION database_size(name)* postgres 2. pg_restore: [archiver (db)] could not execute query: ERROR: could not access file $libdir/dbsize**: No such file or directory... 3.

Re: [GENERAL] error msg when pg_restore

2006-08-23 Thread Tom Lane
nuno [EMAIL PROTECTED] writes: pg_restore: [archiver (db)] could not execute query: ERROR: could not access file $libdir/dbsize: No such file or directory Command was: CREATE FUNCTION relation_size(text) RETURNS bigint AS '$libdir/dbsize', 'relation_size' LANGUAGE c STRICT; You

[GENERAL] error msg when pg_restore

2006-08-22 Thread nuno
good'ay everyone. i have this problem which may not be a big deal, however, it'd be great if you could help me if possible. when i restore a database (using a backup file), it shows me some error messages which do not seem to matter at all (there is no data lost in the database, and maybe

Re: [GENERAL] error msg when pg_restore

2006-08-22 Thread Tom Lane
nuno [EMAIL PROTECTED] writes: when i restore a database (using a backup file), it shows me some error messages which do not seem to matter at all (there is no data lost in the database, and maybe they're just warning messages...). pg_restore: [archiver (db)] could not execute query: ERROR: