From: | Kevin Way <kevin(dot)way(at)overtone(dot)org> |
---|---|
To: | Kovacs Baldvin <kb136(at)hszk(dot)bme(dot)hu> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Bug?: Update on ancestor for a row of a child |
Date: | 2001-09-24 02:51:50 |
Message-ID: | 20010924025150.A6840@bean.overtone.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
> The problem is: when updating a row in an ancestor table,
> which is really belongs to a child, there's something wrong
> with the CHECK system.
Well, I believe you found one minor problem. The bigger one is still
lurking in the shadows though. To duplicate it, take my previous schema,
and add
lastlog TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
to the users table, between pass_hash and logged_in.
After doing so, you'll find that postgres actually crashes when you try
to insert a vote into the uservote table. That's the one that has me
looking at the costs involved with migrating to Oracle.
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2001-09-24 03:01:54 | Re: an already existing alter table drop column ?!?!?! |
Previous Message | Tatsuo Ishii | 2001-09-24 02:47:31 | Re: UTF-8 support |
From | Date | Subject | |
---|---|---|---|
Next Message | Frederick Klauschen | 2001-09-24 02:55:14 | loading array_iterator.so does not work with Postgresql 7.0.3/7.1.3 |
Previous Message | Frederick Klauschen | 2001-09-24 02:41:52 | problem loading array |