Database Design Advice

[Matt Lawrence]

On 18/11/13 11:18, Philip Skinner wrote:
> Auto-increment a double column primary key, something like:
>
> uid int(11) not null auto_increment, revision int(11) not null 
> auto_increment, primary key(uid, revision)
>
> ; works in mysql. You won't have your concurrent query issues there, 
> for the most part anyway. Maybe marking a records as tainted.

As far as I know that only works with MyISAM in mysql. It certainly 
doesn't work like that in Postgres.

Matt