[HACKERS] RLS and LEAKPROOF functions

2015-08-11 Thread Ted Toth
I built an index on a jsonb column of a table with RLS enabled but it was not being used. Turns out the the function jsonb_contains needed to be LEAKPROOF (thanks Joe Conway). However I do not actually know if jsonb_contains is LEAKPROOF. Who's responsibility is it to insure functions are

Re: [HACKERS] security labels on databases are bad for dump restore

2015-07-14 Thread Ted Toth
...@ak.jp.nec.com -Original Message- From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Ted Toth Sent: Wednesday, July 15, 2015 2:59 AM To: Kohei KaiGai Cc: Robert Haas; Adam Brightwell; Andres Freund; pgsql-hackers@postgresql.org; Alvaro

Re: [HACKERS] security labels on databases are bad for dump restore

2015-07-14 Thread Ted Toth
I'm sort of new to this so maybe I'm missing something but since the sepgsql SELinux userspace object manager was never integrated into postgresql (AFAIK KaiGais branch was never merged into the mainline) who uses these labels? What use are they? Ted On Tue, Jul 14, 2015 at 12:09 PM, Adam

Re: [HACKERS] security labels on databases are bad for dump restore

2015-07-14 Thread Ted Toth
Haas robertmh...@gmail.com wrote: On Tue, Jul 14, 2015 at 1:22 PM, Ted Toth txt...@gmail.com wrote: I'm sort of new to this so maybe I'm missing something but since the sepgsql SELinux userspace object manager was never integrated into postgresql (AFAIK KaiGais branch was never merged

Re: [HACKERS] rhel6 rpm file locations

2015-05-28 Thread Ted Toth
Are there any other packagers following the Fedora 'standards' that you are aware of? On Wed, May 27, 2015 at 2:40 PM, Robert Haas robertmh...@gmail.com wrote: On Wed, May 27, 2015 at 3:25 PM, Ted Toth txt...@gmail.com wrote: On Wed, May 27, 2015 at 1:31 PM, Robert Haas robertmh...@gmail.com

Re: [HACKERS] rhel6 rpm file locations

2015-05-27 Thread Ted Toth
http://yum.postgresql.org/9.4/redhat/rhel-6.5-x86_64/ On Wed, May 27, 2015 at 1:31 PM, Robert Haas robertmh...@gmail.com wrote: On Wed, May 27, 2015 at 11:35 AM, Ted Toth txt...@gmail.com wrote: I'm trying to use a newer version than is available from RH in our custom distro but am having

[HACKERS] rhel6 rpm file locations

2015-05-27 Thread Ted Toth
I'm trying to use a newer version than is available from RH in our custom distro but am having problems install both x86_64 and i686 rpms because file conflicts. We have some i686 packages that use libgdal which pulls in libpq which ends up in the same location in both the x86_64 and i686