2011/6/2 Robert Haas :
>
> It's a fairly unusual case to have two inheritance children one of
> which has a foreign key referencing the other, and to then try to
BTW, when the both tables refer to tr_test1 directly the same thing
happens on truncating:
create table tr_test1(id1 int, primary key
2011/6/2 Alexey Klyukin :
> What would you expect to happen for TRUNCATE .. CASCADE?
>
> One thing I find potentially surprising is that TRUNCATE CASCADE doesn't
> follow the semantics of 'ON DELETE' clause for the foreign key, i.e. it would
> truncate the dependent table even with ON DELETE RES
The following bug has been logged online:
Bug reference: 6048
Logged by: Artiom Makarov
Email address: artiom.maka...@gmail.com
PostgreSQL version: 9.04
Operating system: 2.6.32-30-server #59-Ubuntu SMP Tue Mar 1 22:46:09 UTC
2011 x86_64 GNU/Linux
Description
