> Now, how about the same functionality for
> INSERT into table1 SELECT * from table2 ... WITH ERRORS;
> Should allow the insert to complete, even if table1 has unique indexes and
> try to insert duplicate rows. Might save LOTS of time in bulkloading
> not having to do single INSERTs.
1. I prefer Oracle' (and others, I believe) way - put statement(s) in PL
block and define
for what exceptions (errors) what actions should be taken (ie IGNORE for
2. For INSERT ... SELECT statement one can put DISTINCT in select' target
> Guess all this will be available in 7.3?
In response to
pgsql-hackers by date
|Next:||From: Oleg Bartunov||Date: 2002-01-04 07:48:04|
|Subject: Re: RC1 time? |
|Previous:||From: Daniel Kalchev||Date: 2002-01-04 07:36:01|
|Subject: Re: Bulkloading using COPY - ignore duplicates? |