: [HACKERS] How to implement the skip errors for
copy from ?
2014-06-17 7:30 GMT+02:00 xbzhang xbzh...@kingbase.com.cn:
Use subtransaction , the tuples that had inserted into heap must be inserted
again when some exception is raised,
it is too expensive.My solution is :1. delete the tuple
:xbzh...@kingbase.com.cn
From: Amit KapilaDate: 2014-06-17 17:10To: xbzhangCC: Pavel Stehule; Alvaro
Herrera; pgsql-hackersSubject: Re: [HACKERS] How to implement the skip errors
for copy from ?On Tue, Jun 17, 2014 at 12:16 PM, xbzhang
xbzh...@kingbase.com.cn wrote:
one resource owner per
:40To:?xbzhangCC:?Amit Kapila; Pavel Stehule;
Alvaro Herrera; pgsql-hackersSubject:?Re: [HACKERS] How to implement the skip
errors for copy from ?xbzhang xbzh...@kingbase.com.cn writes:
LWlocks can record in resource owner per tuples, so they can be released��at
rigth way, but the memory
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.
it feasible? Anybody give
me some suggestion?
张晓博 研发二部
北京人大金仓信息技术股份有限公司
地址:北京市海淀区上地西路八号院上地科技大厦4号楼501
邮编:100085
电话:(010) 5885 1118 - 8450
手机:15311394463
邮箱:xbzh...@kingbase.com.cn
From: Alvaro HerreraDate: 2014-06-17 02:37To: Pavel StehuleCC: xbzhang;
pgsql-hackersSubject: Re: [HACKERS] How