> I've made some inroads towards adding 'ignore duplicates' > functionality to PostgreSQL's COPY command. I've updated the parser > grammar for COPY FROM to now accept: > > COPY [ BINARY ] table [ WITH OIDS ] > FROM { 'filename' | stdin } > [ [USING] DELIMITERS 'delimiter' ] > [ WITH [NULL AS 'null string'] > [IGNORE DUPLICATES] ]
Is there any possibility that COPY could insert a row so the old row will be discarded and a new one inserted instead the old? It could be useful for doing replications on table with modified rows. Dan ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster