Something smells in this schema...

From: Adam Haberlach <adam(at)newsnipple(dot)com>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Something smells in this schema...
Date: 2001-02-16 17:34:13
Message-ID: 20010216093413.A30026@newsnipple.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Version: PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2

(we were planning on going to beta4 in another week, and have done
some testing. This problem doesn't seem to occur on the engineer's
machine, which is already at beta4)

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?

-- time_tasks.schema
create table time_tasks (
name char(2) primary key,
title text,
description text
);

insert into time_tasks (name, title) values ('CO', 'Communication');
insert into time_tasks (name, title) values ('DB', 'Debug');
.
.
.

-- time_cards.schema
create table time_cards (
id serial,
open bool not null default 't',
accounted bool not null default 'f',

uid int4 not null,
task char(2) not null,
project int4,
component text,

time_start int4,
time_stop int4,
total_minutes int4,

notes text
);
create index time_cards_open_pkey on time_cards (open);
create index time_cards_uid_pkey on time_cards (uid);

--
Adam Haberlach |A cat spends her life conflicted between a
adam(at)newsnipple(dot)com |deep, passionate, and profound desire for
http://www.newsnipple.com |fish and an equally deep, passionate, and
'88 EX500 '00 >^< |profound desire to avoid getting wet.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2001-02-16 17:39:08 beta5 ...
Previous Message Bruce Momjian 2001-02-16 17:15:35 Re: Open 7.1 items