Added to TODO:
Enable creation of RETURNING rules on inherited tables that have dropped
columns
http://archives.postgresql.org/pgsql-bugs/2008-06/msg00183.php
---
Tom Lane wrote:
> "Alex
Hello, Tom!
> What did you do *exactly*?
Here's the example of command sequence that lead to this error:
luh=# create table foo(a int);
CREATE TABLE
luh=# alter TABLE foo add column b int;
ALTER TABLE
luh=# alter TABLE foo drop column b;
ALTER TABLE
luh=# alter TABLE foo add column c int;
ALT
"Alexey Bashtanov" <[EMAIL PROTECTED]> writes:
>> What did you do *exactly*?
> Here's the example of command sequence that lead to this error:
> luh=# create table foo(a int);
> CREATE TABLE
> luh=# alter TABLE foo add column b int;
> ALTER TABLE
> luh=# alter TABLE foo drop column b;
> ALTER
"Alexey Bashtanov" <[EMAIL PROTECTED]> writes:
> I have created a partitioned table cache with partitions cache_id_g_4184088
> and cache_id_le_4184088 those inherit cache.
> I provided insert by the following rule:
> CREATE RULE cache_partic AS ON INSERT TO cache DO INSTEAD INSERT INTO
> cache_id_g
The following bug has been logged online:
Bug reference: 4271
Logged by: Alexey Bashtanov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: linux
Description:dropped columns conflict with returning rules
Details:
I have created a partition
