pg_bulkload vs postgres bulk loader step

[madhupenta]

Hi,

I was checking if the postgres bulk loader step uses the pg_bulkload utility? I doubt, because i read from the wiki that it uses COPY DATA FROM STDIN. Some changes between copy and pg_bulkload are as mentioned here :
http://pgbulkload.projects.postgresql.org/

so should it be a better option to invoke a shell script from pentaho which runs the pg_bulkload?

P.S. I had another query. . pentaho does not abort if there is an error in inserting a record while using postgres bulk loader any help on this to abort the process if some records fail to insert?

[MattCasters]

http://wiki.pentaho.com/display/EAI/...QL+Bulk+Loader

[madhupenta]

Yep that is where I read already from :| .... I wanted to know if someone had actually tried both pg_bulkload and copy command and the difference in performance!!

[madhupenta]

As for my second query, how do I fail the transformation, if an insert fails via bulkloader?