Re: Something smells in this schema...

Adam Haberlach <adam(at)newsnipple(dot)com> writes:
> I had postgres start blocking all it's UPDATEs on a production
> database today, when an engineer added the following two tables,
> among other things. We've had to restore from backup, and the
> interesting thing is that when we re-add these tables, things
> break again.

"blocking"? Please define symptoms more precisely.

> My first thought was the index on the boolean field in the time_cards,
> which I could have sworn has caused me problems before. Anyone else see
> anything wrong?

Pre-7.1 versions do have problems with large numbers of equal keys in
a btree index, which is more or less the definition of an index on
boolean. I'm dubious that such an index is of any value anyway ...

regards, tom lane