Re: [GENERAL] Inserting possible dublicate unique keys

2001-03-29 Thread Alvar Freude
Hi, Richard Huxton wrote: > > > CREATE TABLE referer ( > >id SERIAL, > >referer varchar(2048) NOT NULL PRIMARY KEY > >); [...] > > Why have you got id as a serial if referer is your primary key? Oh - I > suppose it's easier to reference a serial of course, less data to carry > aroun

[GENERAL] Inserting possible dublicate unique keys

2001-03-26 Thread Alvar Freude
Hi, what is the best method to make concurrent inserts to a table with unique/primary key? Scenario: I write a DBI logger for Apache, and this uses a table for all referers: CREATE TABLE referer ( id SERIAL, referer varchar(2048) NOT NULL PRIMARY KEY ); so, you can im