Re: [GENERAL] insert continue on error

2007-10-17 Thread Sam Mason
On Tue, Oct 16, 2007 at 03:37:46PM -0400, Tom Hart wrote: I'm trying to migrate our data mine from a MS Access backend to a postgresql backend, and I'm bumping into problems with the conversion. When I've had to do this before, I've tended to create a table with the same columns but all of

[GENERAL] insert continue on error

2007-10-16 Thread Tom Hart
Hello everybody. I'm trying to migrate our data mine from a MS Access backend to a postgresql backend, and I'm bumping into problems with the conversion. I've got the basic db and tables set up. I want to transfer data from one table to another with insert into ... select from. The from

Re: [GENERAL] insert continue on error

2007-10-16 Thread Raymond O'Donnell
On 16/10/2007 20:37, Tom Hart wrote: What I'd like to know is if there's a way to have postgresql still insert the other rows, and either bounce the bad row to another table, or log the error in another table/file. I'm sure there's a way to do this, but I'm still pretty new to postgresql.