Re: [BUGS] statement stuck when the connection grew up to 45 or more
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 processbatch = '1'SELECT COUNT (*) FROM (SELECT empno as counter1 from pay_master_history as aINNER JOIN (select empno from pay_batch_basic_history where organizationid like '015003%' and processyear = '2006' and processmonth = '05' and processbatch = '1') as bON b.empno = a.empno ) as count_result-or just create the view and use inner join then count :b
[BUGS] length checking and encoding in postgresql 8.1.4
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 field contains N (with a wave-like at top) . The actual length of the string is 40 so it should be accepted considering the fact that it is properly translated as that character mentioned earlier. So far other Pgsql 8.1.3 accepts the record. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[BUGS] pg_restore
I am having problem with pg_restore 8.1.4 pg_restore: [custom archiver] out of memorypg_restore: *** aborted because of error
[BUGS] BUGS: pg_restore custom archiver out of memory
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 - C:\Program Files\PostgreSQL\8.1\bin\pg_restore.exe -i -h localhost -p 5432 -U postgres -d bdoors -a -t product -v "E:\db.backup"pg_restore: connecting to database for restorepg_restore: restoring data for table "product" pg_restore: [custom archiver] out of memorypg_restore: *** aborted because of error Process returned exit code 1. C:\Program Files\PostgreSQL\8.1\bin\pg_restore.exe -i -h localhost -p 5432 -U postgres -d bdoors -a -t demographics -v "E:\db.backup"pg_restore: connecting to database for restorepg_restore: restoring data for table "demographics" pg_restore: [custom archiver] out of memorypg_restore: *** aborted because of error Process returned exit code 1. - Tested machine: xeon 2.8 Memory: 512 OS: Windows XP SP2 and Fedora Core 5 Backup DB size: 366,233,780 DB Size: more than 2 gigabytes Created By: PGADMIN
