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