On Mon, 15 Aug 2005, Mage wrote: > 2005-08-12 19:08:43: ERROR: duplicate key violates unique constraint > "common_adviewnum_adid_site_day_index" Between your select and your insert someone else inserted a row making the insert fail. See this example of how you can update or insert depending on what is in the table: http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE If you don't have 8.0 so you can do as the example you need to lock the table so no one else can insert between your select and your insert. -- /Dennis Björklund ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
