Re: [GENERAL] a row not deletes

2014-04-27 Thread Rafał Pietrak
Thenx for explanations. W dniu 27.04.2014 16:56, David G Johnston pisze: Andres Freund-3 wrote Hi, On 2014-04-27 10:23:18 +0200, Rafał Pietrak wrote: I've just experienced an unexpected (for me) "loss" of DELETE. Is this a feature or a bug (postgres v.s. SQL)? I guess you're using 9.2 or ol

Re: [GENERAL] a row not deletes

2014-04-27 Thread David G Johnston
Andres Freund-3 wrote > Hi, > > On 2014-04-27 10:23:18 +0200, Rafał Pietrak wrote: >> I've just experienced an unexpected (for me) "loss" of DELETE. Is this a >> feature or a bug (postgres v.s. SQL)? > > I guess you're using 9.2 or older? You are not allowed to update the > deleted row in a BEFOR

Re: [GENERAL] a row not deletes

2014-04-27 Thread Andres Freund
Hi, On 2014-04-27 10:23:18 +0200, Rafał Pietrak wrote: > I've just experienced an unexpected (for me) "loss" of DELETE. Is this a > feature or a bug (postgres v.s. SQL)? > > test case - > test=# CREATE TABLE test (a int, b text); > test=# INSERT INTO

[GENERAL] a row not deletes

2014-04-27 Thread Rafał Pietrak
Hi the list, I've just experienced an unexpected (for me) "loss" of DELETE. Is this a feature or a bug (postgres v.s. SQL)? test case - test=# CREATE TABLE test (a int, b text); test=# INSERT INTO test (a,b) values (1,'asd'); test=# INSERT INTO