Paul J Stevens wrote: > > You will most likely see similar duplicate key violations on the > headervalue table as well. I couldn't think of a better way to handle > this. Mysql will let you do 'REPLACE INTO' but postgres and sqlite do > not. Doing a 'SELECT' before *every* 'INSERT' seemed like excessive. Would something like; see http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.htm l#PLPGSQL-ERROR-TRAPPING
Help for PostgreSQL? LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US