[GENERAL] How to implement the skip errors for copy from ?

2014-05-29 Thread xbzhang
I want to?implement the skip errors for copy from,lik as :create table A (c int primary key);copy A from stdin;112\. copy will failed:ERROR: duplicate key violates primary key constraint "CC_PKEY" CONTEXT: COPY CC, line 2: "1" I want skip the error, and continue to copy the reset of tuple

[GENERAL] Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?

2014-01-03 Thread xbzhang
Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ? Can i set it to other value ? If i extend or decrease it , can it affect the performance of sending message? 张晓博 研发二部 北京人大金仓信息技术股份有限公司 地址:北京市海淀区上地西路八号院上地科技大厦4号楼501 邮编:100085 电话:(010) 5885 1118 - 8450 手机:15311394463 邮箱:xbzh

[GENERAL] Are there rules for add parameter in postgresql.conf?

2014-04-22 Thread xbzhang
I want to add some function for INSERT statement,?but i can not decide that i need?add one parameterin postgresql.conf or need?add?parameter in INSERTstatement.Are there some rules for developer to decide it ? 张晓博?? 研发二部 北京人大金仓信息技术股份有限公司 地址:北京市海淀区上地西路八号院上地科技大厦4号楼501 邮编:100085 电话:(010)