Re: [HACKERS] [BUG] Column-level privileges on inherited tables

2009-03-05 Thread Stephen Frost
KaiGai, * KaiGai Kohei (kai...@ak.jp.nec.com) wrote: The attached patch fixes the matter. It fixes up attribute number of child relation when it is extracted. Thanks! It looks good to me, but we'll need Tom or some other committer to review it and commit it, of course. Thanks again,

Re: [HACKERS] [BUG] Column-level privileges on inherited tables

2009-03-05 Thread Tom Lane
Stephen Frost sfr...@snowman.net writes: KaiGai, * KaiGai Kohei (kai...@ak.jp.nec.com) wrote: The attached patch fixes the matter. It fixes up attribute number of child relation when it is extracted. Thanks! It looks good to me, but we'll need Tom or some other committer to review it and

[HACKERS] [BUG] Column-level privileges on inherited tables

2009-03-04 Thread KaiGai Kohei
I've observed the behavior of column-level privileges and required permissions with a few elog()s injected. I noticed rte-selectedCols is incorrect when we make a query on inherited tables. See below: - postgres=# CREATE TABLE t1 (a int, b int, c

Re: [HACKERS] [BUG] Column-level privileges on inherited tables

2009-03-04 Thread KaiGai Kohei
KaiGai Kohei wrote: I've observed the behavior of column-level privileges and required permissions with a few elog()s injected. I noticed rte-selectedCols is incorrect when we make a query on inherited tables. See below: - postgres=#

Re: [HACKERS] [BUG] Column-level privileges on inherited tables

2009-03-04 Thread KaiGai Kohei
Stephen, The attached patch fixes the matter. It fixes up attribute number of child relation when it is extracted. (*) Injected elog()s are removed. postgres=# select * from t1; NOTICE: markRTEForSelectPriv: ACL_SELECT on t1.a NOTICE: markRTEForSelectPriv: ACL_SELECT on t1.c NOTICE: