This is the statement which having problem: select count(distinct empno) as counter1 from pay_master_history where empno in (select empno from pay_batch_basic_history whereorganizationid like '015003%')
and processyear = '2006' and processmonth = '05' and processbatc
I got a field with a datatype of varchar(40) in one of my table
client_encoding = LATIN9
When I use COPY to transfer records to my table
I got an error message "Error: value too long for type character varying(40)"
When I check the offending record it seems that one of the character
in the fiel
I am having problem with pg_restore 8.1.4
pg_restore: [custom archiver] out of memorypg_restore: *** aborted because of error
Below is the result of restoring specific tables from backup made by pgadmin using postgresql 8.1.4 for windows
Note: Same result also applies to linux distribution of postgresql 8.1.4
--
