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
On Thu, Jun 2, 2011 at 11:21 AM, Artiom Makarov
wrote:
> 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. i
On Jun 2, 2011, at 6:21 PM, Artiom Makarov wrote:
> 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
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
On Jun 2, 2011, at 2:23 PM, Artiom Makarov wrote:
>
> 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 M
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:TRUNCATE
