Julius Stroffek <[EMAIL PROTECTED]> writes: > Attached is the example script 'repro.sql' which creates two relations > tab1 and tab2. It also creates a rule on tab1 which simply does insert > into tab2. The insert statement into tab1 is executed afterwards. It > responds with 'INSERT 0 1'. However if I would create the same rule with > the where clause the response to the same insert statement is 'INSERT 0 > 0'. The output of the script executed through psql is in 'repro.out'.
> Is this a bug? No. See http://www.postgresql.org/docs/8.2/static/rules-status.html and note that you don't have an unconditional INSTEAD rule. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
