Re: RLS makes COPY TO process child tables

2023-03-10 Thread Tom Lane
Stephen Frost writes: > Yeah, that should also be updated. Perhaps you'd send an updated patch > which includes fixing that too and maybe adds clarifying documentation > to COPY which mentions what happens when RLS is enabled on the relation? I couldn't find anything in copy.sgml that seemed to

Re: RLS makes COPY TO process child tables

2023-03-10 Thread Tom Lane
Stephen Frost writes: >> Tom Lane wrote: >>> Yugo NAGATA writes: I think this is a bug because the current behaviour is different from the documentation. >>> I agree, it shouldn't do that. > Yeah, I agree based on what the COPY table TO docs say should be > happening. Yeah, the doc

Re: RLS makes COPY TO process child tables

2023-02-07 Thread Stephen Frost
Greetings, * Yugo NAGATA (nag...@sraoss.co.jp) wrote: > On Wed, 01 Feb 2023 11:47:23 -0500 > Tom Lane wrote: > > > Yugo NAGATA writes: > > > Antonin Houska wrote: > > >> While working on [1] I noticed that if RLS gets enabled, the COPY TO > > >> command > > >> includes the contents of child t

Re: RLS makes COPY TO process child tables

2023-02-01 Thread Antonin Houska
Yugo NAGATA wrote: > On Wed, 01 Feb 2023 12:45:57 +0100 > Antonin Houska wrote: > > > While working on [1] I noticed that if RLS gets enabled, the COPY TO command > > includes the contents of child table into the result, although the > > documentation says it should not: > > > > "COPY TO c

Re: RLS makes COPY TO process child tables

2023-02-01 Thread Yugo NAGATA
On Wed, 01 Feb 2023 11:47:23 -0500 Tom Lane wrote: > Yugo NAGATA writes: > > Antonin Houska wrote: > >> While working on [1] I noticed that if RLS gets enabled, the COPY TO > >> command > >> includes the contents of child table into the result, although the > >> documentation says it should no

Re: RLS makes COPY TO process child tables

2023-02-01 Thread Tom Lane
Yugo NAGATA writes: > Antonin Houska wrote: >> While working on [1] I noticed that if RLS gets enabled, the COPY TO command >> includes the contents of child table into the result, although the >> documentation says it should not: > I think this is a bug because the current behaviour is differen

Re: RLS makes COPY TO process child tables

2023-02-01 Thread Yugo NAGATA
On Wed, 01 Feb 2023 12:45:57 +0100 Antonin Houska wrote: > While working on [1] I noticed that if RLS gets enabled, the COPY TO command > includes the contents of child table into the result, although the > documentation says it should not: > > "COPY TO can be used only with plain tables,